Sr. Analytics Engineer

Thomas James Homes; Aliso Viejo (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Thomas James Homes seeks a senior data platform engineer to design, build, operate, and continuously improve the enterprise data platform in Microsoft Fabric, delivering lakehouses, warehouses, pipelines, and analytics that turn complex business data into trusted insights.

You will partner with business, application, and reporting teams to translate needs into scalable data solutions, enforce data governance, and enable self‑service reporting, AI, and operational decisions across the

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, or 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.
• 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 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 for analytics-ready data products.
• Build and optimize Power BI semantic models, measures, KPIs, and row-level security.
• Partner with business stakeholders to define reporting requirements and translate findings into insights.
• Establish automated data-quality controls, reconciliation checks, exception handling, alerting, and validation processes.
• Monitor pipeline execution, capacity usage, query performance, refresh reliability, and platform health.
• Create and maintain source-to-target mappings, data dictionaries, lineage documentation, and runbooks.
• Lead design reviews and evaluate new Fabric capabilities.
• Mentor data analysts, engineers, and power users on data modeling, SQL, Power BI, and Fabric development

Skills

Data modeling

SQL

Power BI

Python

PySpark

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Fabric

Power Platform

Azure

Purview

OneLake

Dynamics 365

Salesforce

Job description

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.
• Homebuilding, construction, real estate, finance, or operational analytics experience preferred

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 / Aff… 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.