Sr. Analytics Engineer

Thomas James Homes•Aliso Viejo, CA

2d•Hybrid

About The Position

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.

Requirements

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.

Nice To Haves

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