Analytics Engineer

Summary

National Corporate Housing provides customized corporate housing and related services for relocations, assignments, and travel. The Analytics Engineer will build and maintain data foundations, SQL models, Power BI datasets and dashboards, data integrations, and data quality processes while partnering with operations, sales, and finance teams to deliver actionable reporting.

Responsibilities

• Write, tune, and maintain performant SQL to transform raw data into clean, well-documented models teams can rely on
• Design and build Power BI datasets, reports, and dashboards — and keep them accurate, fast, and easy to use
• Own data quality: validate sources, catch issues early, and build the checks that keep numbers trustworthy
• Partner with operations, sales, and finance to translate business questions into data models and reporting
• Build and maintain data integrations — pulling from source systems and automating the flows that feed reporting
• Document your models, metrics, and definitions so the whole company shares a single source of truth

Skills

• 3–5 years of experience in analytics engineering, BI development, data analysis, or a similar data-focused role
• Strong SQL. You write clean, efficient queries and are comfortable with joins, window functions, and data modeling
• Strong Power BI. You build data models, DAX measures, and polished, reliable dashboards — not just charts
• A builder's mindset: you care about accuracy, documentation, and making data usable for non-technical teammates
• Clear communication and the ability to work independently in a remote, collaborative environment
• Experience working in a Microsoft-centered technology environment, particularly with Microsoft SQL Server and the broader Microsoft data and application ecosystem
• Familiarity with .NET applications and architectures, including the ability to understand how application data is structured, generated, and exposed for integrations and reporting
• Hands-on experience building integrations and automated data flows using Azure services such as Azure Data Factory, Azure Logic Apps, Azure Functions, and APIs or webhooks
• Experience working with Azure Cosmos DB or other NoSQL data stores, and modeling that data for analytics and reporting
• A working understanding of the Salesforce data model — objects, relationships, and how to pull and model CRM data reliably
• Familiarity with version control (Git), data warehousing concepts, and modern ELT tooling
• Experience in hospitality, real estate, travel, or another operations-heavy industry

Qualifications

Must Haves

• 3–5 years of experience in analytics engineering, BI development, data analysis, or a similar data-focused role
• Strong SQL. You write clean, efficient queries and are comfortable with joins, window functions, and data modeling
• Strong Power BI. You build data models, DAX measures, and polished, reliable dashboards — not just charts
• A builder's mindset: you care about accuracy, documentation, and making data usable for non-technical teammates
• Clear communication and the ability to work independently in a remote, collaborative environment

Nice to Haves

• Experience working in a Microsoft-centered technology environment, particularly with Microsoft SQL Server and the broader Microsoft data and application ecosystem
• Familiarity with .NET applications and architectures, including the ability to understand how application data is structured, generated, and exposed for integrations and reporting
• Hands-on experience building integrations and automated data flows using Azure services such as Azure Data Factory, Azure Logic Apps, Azure Functions, and APIs or webhooks
• Experience working with Azure Cosmos DB or other NoSQL data stores, and modeling that data for analytics and reporting
• A working understanding of the Salesforce data model — objects, relationships, and how to pull and model CRM data reliably
• Familiarity with version control (Git), data warehousing concepts, and modern ELT tooling
• Experience in hospitality, real estate, travel, or another operations-heavy industry

Benefits

• Medical, dental, and vision insurance options
• 401k plan with discretionary match
• Company paid life insurance, short term disability, and long term disability
• Supplemental life insurance, critical illness, accident, and identity theft protection
• Inclusive Awards and Recognition Program
• Vacation, sick, and floating holidays
• Paid time off
• Paid volunteer time
• Wellness program
• Complimentary use of corporate apartments for vacation or travel (when available)
• Fully remote setup