Analytics Engineer

Ultipro; Greenwood Village, Northern (CO, KY); On-site; USD 93,000 - 105,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k with discretionary match

Company paid life insurance

Short/long-term disability

Paid time off

Wellness program

Commuter or travel benefits

Job summary

National Corporate Housing is seeking an Analytics Engineer to build data pipelines and reports. You will model, move, and turn data into dashboards used daily by operations, sales, and finance. The role balances data foundation work with delivering analytics and reporting on top of it.

If you love sharp SQL, clean data models, and trustworthy Power BI reports, you’ll fit in. This full-time, remote position offers ownership and impact across teams.

Qualifications

• 3–5 years of experience in analytics engineering, BI development, data analysis, or a similar data-focused role.
• Strong SQL: joins, windowing, and data modeling.
• Strong Power BI: data models, DAX, and reliable dashboards.
• Experience with Microsoft SQL Server and Azure-based data tooling.

Responsibilities

• Write, tune, and maintain performant SQL to transform raw data into clean models.
• Design and build Power BI datasets, reports, and dashboards that are accurate and fast.
• Own data quality: validate sources, catch issues early, and implement checks.
• Partner with operations, sales, and finance to translate business questions into data models and reporting.
• Build and maintain data integrations from source systems to feed reporting.
• Document models, metrics, and definitions for a single source of truth.

Skills

SQL

Power BI

Data modeling

Git/version control

Azure

Tools

Microsoft SQL Server

Azure Data Factory

Azure Logic Apps

Azure Functions

Cosmos DB

Job description

• Pay or shift range: $92,500 USD to $105,000 USD
  The estimated range is the budgeted amount for this position. Final offers are based on various factors, including skill set, experience, location, qualifications and other job-related reasons.
• Corporate Other
• Full-Time
• Requisition #: ANALY001323

Description

About National

At National Corporate Housing, we turn complex temporary housing challenges into comfortable, seamless solutions. Since 1999, we've delivered customized corporate housing and 360-degree services to clients around the world - the behind-the-scenes team that makes relocations, assignments, and travel feel like home. We move fast, we care about the details, and we rely on good data to do it well.

The role

We're looking for an Analytics Engineer who is equally comfortable building the pipes and building the reports. You'll sit at the center of our data - modeling it, moving it, and turning it into the dashboards our teams use every day. If you love writing sharp SQL, shaping clean data models, and shipping Power BI reporting that people actually trust, you'll fit right in.

This is a genuinely blended role: roughly half your time is spent building and maintaining the data foundation, and half is spent delivering the analytics and reporting on top of it. You'll work closely with our operations, sales, and finance teams to understand what they need and give them answers they can act on.

What you’ll do

• 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.

What you bring (required)

• 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.
• Microsoft ecosystem. Experience working in a Microsoft-centered technology environment, particularly with Microsoft SQL Server and the broader Microsoft data and application ecosystem.
• .NET applications. Familiarity with .NET applications and architectures, including the ability to understand how application data is structured, generated, and exposed for integrations and reporting.
• Azure integrations. 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.
• NoSQL data stores. Experience working with Azure Cosmos DB or other NoSQL data stores, and modeling that data for analytics and reporting.
• Salesforce schema. 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.

Why you'll love it here

You'll join a company that treats people as the difference-maker and gives you the ownership to do your best work. We offer competitive compensation, comprehensive benefits, and a fully remote setup with a team that genuinely has your back. Your work won't sit in a drawer - the data you build powers real decisions across the business every day.

• 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
• Wellness program
• Complimentary use of corporate apartments for vacation or travel (when available)
• National is a drug & alcohol-free workplace. Please note that we conduct a background check and 5 panel drug screen after a contingent offer has been made.

Additional Information:

Will not provide assistance with relocation costs

National Corporate Housing is an equal opportunity employer. Qualified applicants will be considered without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, religion, or veteran status.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.