> Markdown version of [/jobs/ext/2573272-data-engineer-microsoft-fabric-financial-data](https://www.wearedevelopers.com/jobs/ext/2573272-data-engineer-microsoft-fabric-financial-data). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer (Microsoft Fabric / Financial Data) - **Company:** Allstate Corporation - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $100,000.0 - $171,000.0 - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Microsoft Azure, Business Intelligence Development, BigQuery, Code Review, Data Validation, Data Control, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Structures, Data Systems, Data Warehousing, DevOps, Python (Programming Language), Power BI, Cloud Services, Software Engineering, SQL Databases, Enterprise Data Management, Azure Data Factory, Delivery Pipeline, Snowflake, Microsoft Fabric, Pyspark, Data Analytics, Tools for Reporting, Azure Synapse Analytics, Software Version Control, Data Pipelines, Amazon Redshift, Databricks - **Published:** August 5, 2026 - **Apply:** https://allstate.wd5.myworkdayjobs.com/allstate_careers/job/US---Remote/Senior-Data-Engineer--Microsoft-Fabric---Financial-Data-_R33250-1 ## About the Role * 5 years or more of experience in data engineering, analytics engineering, application development, business intelligence development, or a related technical field. (Or Equivalent) * 1-2 years of hands-on Microsoft Fabric experience preferred, including data engineering, data transformation, data warehousing, or analytics capabilities. (Or Equivalent) * Equivalent experience with Azure Synapse Analytics, Databricks, Snowflake, Azure Data Factory, Redshift, BigQuery, or similar cloud data platforms will also be considered. * Strong experience developing complex data transformation processes using SQL, Python, and/or PySpark. * Experience designing, building, and supporting enterprise data pipelines, data models, data structures, and reporting datasets. * Experience working with financial, claims, premium, accounting, operational, or other complex business data. * Strong understanding of ETL/ELT development, data quality controls, reconciliation processes, and data governance concepts. * Experience partnering directly with business stakeholders to gather requirements, clarify priorities, and deliver technical solutions. * Strong analytical, troubleshooting, and problem-solving skills. * Ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment. * Strong communication skills with the ability to explain technical concepts to both technical and non-technical audiences., * Experience with Microsoft Fabric Data Factory, Lakehouse, Warehouse, Power BI, or related Microsoft analytics capabilities. * Experience within property and casualty insurance, financial services, or another highly regulated industry. * Knowledge of reserving, claims, premium, financial reporting, accounting, or operational reporting processes. * Experience automating reconciliations, exception reporting, data validation, and data quality monitoring. * Experience with dashboards, automated reports, or analytics solutions using Power BI or similar reporting tools. * Experience with Azure cloud services, DevOps practices, version control, or deployment pipelines. * Experience leading technical initiatives or mentoring junior developers., * 5 or more years of experience (Preferred), Azure Data Factory, Business Intelligence (BI), Data Engineering, Data Governance, Data Pipelines, Data Quality, Data Solutions, Data Structures, Data Transformation, Data Validation, Data Warehousing (DW), Enterprise Data, Extract Transform Load (ETL), Process Improvements, Python (Programming Language), Relational Data Modeling, Reporting, Structured Query Language (SQL), Technical Requirements ## Description We are seeking a Senior Data Engineering (Microsoft Fabric /Financial Data) to design, develop, and support critical financial and operational data solutions that support reserving, claims, and enterprise decision-making. This role combines hands-on technical development with strong business partnership to ensure data is accurate, scalable, and aligned with financial reporting requirements. The ideal candidate will have experience building and maintaining complex data solutions using SQL, Python, PySpark, Microsoft Fabric, or similar cloud data platforms. This individual will help automate reconciliations, improve data quality controls, reduce manual processes, and deliver reporting and analytics solutions that strengthen operational effectiveness and reduce business risk. The Allstate internal job title for this role is Software Engineer Lead Cons., * Design, develop, test, deploy, and support enterprise data solutions used for financial reporting, reserving, and claims. * Own and maintain critical data structures, transformation logic, business rules, bucketing logic, and controls within claims data. * Develop and maintain data pipelines, transformation processes, and reporting datasets using SQL, Python, PySpark, Microsoft Fabric, or similar cloud data platforms. * Partner with Actuarial Reserving, Accounting Operations, Product, Claims, Financial Planning and Analysis, and other business teams to understand requirements and translate them into scalable technical solutions. * Lead and participate in end-user testing to confirm changes are implemented correctly and downstream reporting impacts are understood before production release. * Automate reconciliations, exception monitoring, data quality checks, and control processes to improve consistency, scalability, and accuracy. * Analyze complex business and data challenges and recommend solutions that improve reporting, decision-making, and operational efficiency. * Review code, design, and testing work to support quality, maintainability, and development best practices. * Provide technical guidance, coaching, and knowledge-sharing to peers and less experienced developers. * Support production issues, investigate root causes, and implement sustainable solutions that reduce future risk. * Identify opportunities to modernize tools, improve data governance, and introduce more efficient development practices. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)