Senior Data Engineer: Semantic Layer Architect

Allstate; United States; Remote; USD 70,000 - 121,000; Full time

Job summary

Allstate is seeking a hands-on Data Engineer to design and maintain data pipelines and the semantic layer that links marketing spend to quotes, policies, and customer lifetime value. You will own the data model architecture and ensure a trusted source of truth for reporting.

Responsibilities include building scalable data frameworks, optimizing DAX measures, and collaborating with data engineering and BI teams. This role emphasizes governance, performance, and operational excellence.

Qualifications

• Strong SQL, including T-SQL, to write, review, and debug production analytical queries.
• Python to build and maintain data transformation notebooks.
• DAX, including measure authoring, performance tuning, and evaluation context.
• Experience owning a large centralized semantic model or equivalent analytical data product.

Responsibilities

• Design, develop, and maintain data pipelines and backend queries for the semantic layer.
• Own the data modeling and architecture of the semantic layer end to end.
• Author, maintain, and performance-tune the DAX measure layer.
• Implement and maintain data frameworks and architectures for data consistency and readiness.

Skills

SQL/T-SQL

Python

DAX

Semantic model

Data engineering

BI

Architectural decisions

Tools

Microsoft Fabric

Tabular Editor

Microsoft Power BI

Job description

Allstate is seeking a hands-on Data Engineer to design and maintain data pipelines and the semantic layer that links marketing spend to quotes, policies, and customer lifetime value. You will own the data model architecture and ensure a trusted source of truth for reporting.

Responsibilities include building scalable data frameworks, optimizing DAX measures, and collaborating with data engineering and BI teams. This role emphasizes governance, performance, and operational excellence.