Analytics Engineer: Data Pipelines & Power BI

National Corporate Housing; Northern (KY); Hybrid; USD 90,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k plan with discretionary match

Company paid life insurance

Disability insurance

Paid time off

Job summary

National Corporate Housing is seeking an Analytics Engineer to centralize data, build robust pipelines, and deliver trusted Power BI reporting. You will balance data foundation work with delivering insights on top of it, collaborating with operations, sales, and finance to answer critical business questions.

You’ll craft scalable SQL, design clean data models, and maintain dashboards used daily by teams. A strong Microsoft-centric tech stack and a focus on data quality are essential for success.

Qualifications

• 3–5 years of analytics engineering or BI experience.
• Strong SQL with joins, window functions, and data modeling.
• Strong Power BI skills with data modeling and dashboards.

Responsibilities

• Write, tune, and maintain performant SQL to transform data into clean models.
• Design and build Power BI datasets, reports, and dashboards that are fast and reliable.
• Own data quality: validate sources and implement checks for trustworthy numbers.
• Partner with operations, sales, and finance to translate business questions into data models and reporting.
• Build and maintain data integrations from source systems and automate reporting feeds.
• Document models, metrics, and definitions so everyone shares a single source of truth.

Skills

SQL

Power BI

Data modeling

Azure

NoSQL

Salesforce

Git

ETL/ELT

DAX

Tools

Microsoft SQL Server

Azure Data Factory

Azure Logic Apps

Azure Functions

APIs

NoSQL databases

Job description

National Corporate Housing is seeking an Analytics Engineer to centralize data, build robust pipelines, and deliver trusted Power BI reporting. You will balance data foundation work with delivering insights on top of it, collaborating with operations, sales, and finance to answer critical business questions.

You’ll craft scalable SQL, design clean data models, and maintain dashboards used daily by teams. A strong Microsoft-centric tech stack and a focus on data quality are essential for success.