Sr. Analytics Engineer

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

Job summary

Thomas James Homes is seeking a senior data engineer to design and operate an enterprise data platform using Microsoft Fabric. You will build lakehouses, warehouses, pipelines, and semantic models, enabling self-service analytics and AI-driven decision making.

The role collaborates with stakeholders to define data contracts, ensure data quality, and deliver analytics-ready data products, with strong emphasis on governance and scalable architecture in a hybrid work environment.

Qualifications

• Bachelor's degree or equivalent professional experience in a related field.
• 5+ years of experience in data engineering, analytics engineering, BI, or related tech role.
• Hands-on experience delivering production data pipelines, data models, warehouses or lakehouses in a cloud environment.

Responsibilities

• Architect, build, test, deploy, and support end-to-end data solutions in Microsoft Fabric (lakehouses, warehouses, pipelines, notebooks).
• Design scalable batch and real-time ingestion from ERP, CRM, SaaS, APIs, and files.
• Develop data transformation logic using SQL, Python, PySpark, Notebooks, Dataflows Gen2, and Fabric pipelines.

Skills

SQL

Python

PySpark

Data Modeling

Power BI

Fabric

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field

Tools

Notebooks Gen2

Dataflows Gen2

Microsoft Fabric

Azure

Job description

Full Time Corporate Aliso Viejo, CA, US

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