Build data pipelines in Microsoft Fabric ingesting data from:

External files (CSV, XML, Excel, vendor feeds)

SQL Server databases

SharePoint and other enterprise sources

Implement Bronze (raw), Silver and Gold (business-ready) layers in Fabric Lakehouse

Design patterns and develop ETL/ELT processes

Create semantic models for agentic frameworks and reporting

Participate in Fabric environment management including workspaces, capacities, access, and

promotion across environments

Apply data governance, quality, and security standards

Collaborate with enterprise engineering and Investments business and technology teams

What You Bring:

3+ years of experience in building implementing data engineering solutions

Hands-on experience with Microsoft Fabric, including:

Lakehouse, OneLake, Pipelines, Notebooks, DataFlow Gen2, Power Query

Workspace, capacity, and environment management

Strong SQL (T-SQL/Spark SQL)

Strong PySpark/Python skills including experience using Dataframes

Experience building Data Models. Experience with Semantic models preferred.

Experience working with SQL Server and file-based data sources

Strong collaboration and communication skills

Nice to Have:

Financial services or investment data experience

Experience developing Power BI reports and Data Agents

Why Allstate Investments

Build a modern analytics platform from the ground up

Work with enterprise-scale investment data

data engineer (microsoft fabric)