Senior Analytics Engineer: Power BI & Fabric Data Platform

Thomas James Homes, LLC.; Aliso Viejo, Northern (CA, KY); Hybrid; USD 120,000 - 151,000; Full time

Job summary

Thomas James Homes, LLC. is seeking a data engineer to design, build, and operate the enterprise data platform in Microsoft Fabric.

You will develop reliable data pipelines, lakehouses, warehouses, and analytics to turn complex business data into trusted insights. You will partner with stakeholders to define reporting requirements, build analytics-ready data products, and implement data quality and governance across critical data flows.

Qualifications

• 5+ years of experience in data engineering, analytics engineering, business intelligence, data analysis, or a related technology role.
• Experience delivering production data pipelines, data models, warehouses or lakehouses, and analytics solutions in a Microsoft cloud environment.
• Owns complex data initiatives from requirements through testing, deployment, monitoring, and support.
• Experience with enterprise data governance, data quality, security, and release management practices.
• Homebuilding, construction, real estate, finance, or operational analytics experience preferred.

Responsibilities

• Architect, build, test, deploy, and support end-to-end data solutions in Microsoft Fabric, including lakehouses, warehouses, pipelines, notebooks, dataflows, and semantic models.
• Design and maintain scalable batch and near-real-time ingestion patterns that integrate data from ERP, CRM, SaaS, APIs, files, databases, and other sources.
• Develop transformation and data preparation logic using SQL, Python, PySpark, Notebooks, Dataflows Gen2, and Fabric data pipelines.
• Implement dimensional, star-schema, and medallion-style data models creating governed, analytics-ready data products.
• Build and optimize Power BI semantic models, measures, KPIs, row-level security, and reporting datasets.
• Partner with stakeholders to define reporting requirements, analyze data, and translate findings into insights and recommendations.
• Lead data governance, data quality, and automated validation processes across data flows.
• Monitor pipeline execution, capacity usage, and performance; troubleshoot failures.
• Create source-to-target mappings, data dictionaries, lineage documentation, and runbooks.

Skills

SQL

Python

PySpark

Power BI

Fabric

Education

Bachelor's degree in Computer Science or related field

Tools

Notebooks Gen2

Fabric data pipelines

Job description

Thomas James Homes, LLC. is seeking a data engineer to design, build, and operate the enterprise data platform in Microsoft Fabric.

You will develop reliable data pipelines, lakehouses, warehouses, and analytics to turn complex business data into trusted insights. You will partner with stakeholders to define reporting requirements, build analytics-ready data products, and implement data quality and governance across critical data flows.