Senior Data Engineer, Semantic Layer Architect

Allstate Insurance; Illinois; On-site; USD 70,000 - 121,000; Full time

Job summary

Allstate Insurance in the United States seeks a data platform engineer to own and build the semantic layer on Microsoft Fabric, connecting marketing spend to quotes, policies, and lifetime value. You will design and maintain data pipelines, models, and architecture, while mentoring apprentices and collaborating with BI and data engineering teams to ensure accurate, trusted metrics.

This hands-on role requires strong SQL, Python, and DAX skills, plus experience with centralized semantic models

Qualifications

• Strong SQL, including T-SQL to write, review, and debug production analytical queries.
• Python, sufficient to build and maintain data transformation notebooks.
• DAX, including measure authoring, performance tuning, and evaluation context.
• Demonstrated experience owning a large centralized semantic model or semantic layer.
• Experience working with data engineering and BI partners on shared infrastructure.
• Ability to make and defend architectural decisions independently.

Responsibilities

• Design, develop, and maintain the data pipelines and backend queries that populate the semantic layer, maintaining separation between raw, clean, and reporting layers so business logic lives where it belongs and not in the reporting layer.
• Own the data modelling and architecture of the semantic layer end to end: structure, relationships, storage mode, and refresh behaviour, including the architectural decisions behind each.
• Author, maintain, and performance‑tune the DAX measure layer, including the measure patterns downstream report builders depend on.
• Implement and maintain data frameworks and architectures that keep the platform's data consistent, accurate, and ready for use.
• Produce and maintain model documentation as a first‑class deliverable, since the semantic layer serves report builders, analysts, and stakeholders who did not build it.
• Combine, optimise, and manage multiple upstream data sources, partnering with the business intelligence and data engineering teams on source changes, deployment practices, and promotion of work from development into production.
• Serve as the technical point of contact when downstream consumers report the model is wrong, and own the investigation through to root cause and fix.
• Perform on‑demand analysis of complex data to identify strategic opportunities and efficiencies and to keep key business metrics accurate and trustworthy.
• Mentor apprentice team members working on model quality assurance and report migration, and review their work.
• Contribute to the department's applied AI efforts, including agent‑based access to model documentation and semantic models.

Skills

SQL

Python

DAX

Semantic model

Data modeling

Data pipelines

Semantic layer

Tools

Microsoft Fabric

Power BI

Tabular Editor

Job description

Allstate Insurance in the United States seeks a data platform engineer to own and build the semantic layer on Microsoft Fabric, connecting marketing spend to quotes, policies, and lifetime value. You will design and maintain data pipelines, models, and architecture, while mentoring apprentices and collaborating with BI and data engineering teams to ensure accurate, trusted metrics.

This hands-on role requires strong SQL, Python, and DAX skills, plus experience with centralized semantic models