Sr. Analytics Engineer

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

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Corporate Aliso Viejo, CA, US

3 days ago Requisition ID: 1064

Salary Range: $120,000.00 To $151,000.00 Annually

THE ROLE:Responsible for designing, building, operating, and improving the enterprise data platform in Microsoft Fabric. This role develops reliable data pipelines, lakehouse and warehouse solutions, curated data products, semantic models, and analytics that turn complex business data into trusted, actionable information. The role partners with business stakeholders, application teams, architects, and reporting teams to translate business needs into scalable data solutions, establish consistent data definitions, improve data quality, and enable self-service reporting, AI, and operational decision-making.

DAY IN THE LIFE:

• 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 internal and external 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 that create governed, analytics-ready data products for enterprise use.
• Build and optimize Power BI semantic models, measures, KPIs, row-level security, and reporting datasets that provide consistent definitions and dependable performance.
• Partner with business stakeholders to define reporting requirements, analyze data, investigate trends and anomalies, and translate findings into clear business insights and recommendations.
• Establish automated data-quality controls, reconciliation checks, exception handling, alerting, and validation processes across critical data flows.
• Monitor pipeline execution, capacity usage, query performance, refresh reliability, and platform health; troubleshoot failures and implement durable corrective actions.
• Create and maintain source-to-target mappings, data dictionaries, lineage documentation, architecture diagrams, runbooks, technical standards, and support procedures.
• Partner with application, integration, infrastructure, and vendor teams to define data contracts, resolve source-system issues, and deliver dependable integrations.
• Lead technical design reviews and proof-of-concept efforts; evaluate new Microsoft Fabric capabilities and recommend adoption based on business value, risk, cost, and maintainability.
• Mentor data analysts, engineers, and power users on data modeling, SQL, Power BI, Fabric development, data quality, and responsible self-service analytics.
• Support strategic initiatives involving Microsoft Fabric, OneLake, Power BI, Azure services, Microsoft Purview, Power Platform, Dynamics 365, Salesforce, AI solutions, and other enterprise platforms.

WHAT YOU’LL NEED:

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, Business Analytics, Engineering, or a related field, or equivalent professional experience.
• 5+ years of experience in data engineering, analytics engineering, business intelligence, data analysis, or a related technology role.
• Hands-on experience delivering production data pipelines, data models, warehouses or lakehouses, and analytics solutions in a Microsoft cloud environment.
• Experience owning complex data initiatives from requirements and architecture 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

#LI-Hybrid #LI-MB1

The compensation range for this role is influenced by a variety of factors including but not limited to skills, experience, qualifications, and geographic location. Thomas James Homes is an Equal Opportunity / Affi... All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity or any other factor protected by applicable federal, state, or local laws.