Allstate

Allstate

Senior Data Engineer (Microsoft Fabric / Financial Data)

US - Remote · Senior

No sponsorship$100k-$171kDetected 30 days ago
PythonData StructuresSQLBigQuerySnowflakeRedshiftDatabricksAzureDevOpsData EngineeringData VisualizationFinancial AnalysisAccountingFP&ACommunicationProblem SolvingMentoringFinancial ReportingActuarial ScienceProperty & Casualty

Stay score

odds of building a lasting career here

50Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role65
Entry-level history0
PERM / green-card track0
Lottery odds (Level III)83
Fits your clock70

Sponsors, but it's cap-subject — you still face the weighted lottery (~45% per draw at Level III). Good if you win; have a cap-exempt backup on your list.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • 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.
  • Provide technical guidance, coaching, and knowledge-sharing to peers and less experienced developers.

Responsibilities

  • 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.
  • Review code, design, and testing work to support quality, maintainability, and development best practices.
  • Support production issues, investigate root causes, and implement sustainable solutions that reduce future risk.

Requirements

  • Equivalent experience with Azure Synapse Analytics, Databricks, Snowflake, Azure Data Factory, Redshift, BigQuery, or similar cloud data platforms will also be considered.
  • Strong understanding of ETL/ELT development, data quality controls, reconciliation processes, and data governance concepts.
  • Experience with Microsoft Fabric Data Factory, Lakehouse, Warehouse, Power BI, or related Microsoft analytics capabilities.
  • 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.
  • Strong communication skills with the ability to explain technical concepts to both technical and non-technical audiences.
  • The candidate(s) offered this position will be required to submit to a background investigation.
  • When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating.
  • Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.

Nice to have

  • 1-2 years of hands-on Microsoft Fabric experience preferred, including data engineering, data transformation, data warehousing, or analytics capabilities. (Or Equivalent)

Skills

  • Compensation
  • One that takes your skills and pushes them to the next level.
  • Allstate generally does not sponsor individuals for employment-based visas for this position.
  • For jobs in San Francisco, please click " here " for information regarding the San Francisco Fair Chance Ordinance.
  • For jobs in Los Angeles, please click " here " for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.
  • To view the "EEO Know Your Rights" poster click " here ".

Compensation

  • Compensation offered for this role is 100,000.00 - 170,500.00 annually and is based on experience and qualifications.
  • This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

Benefits

  • This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.
  • Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.

Company info

  • Joining our team means being part of something bigger - a winning team making a meaningful impact.

Visa & Work Authorization

  • Allstate generally does not sponsor individuals for employment-based visas for this position
Apply directly at Allstate →Create a free account for alerts like thisView Allstate immigration profile

This listing is sourced directly from Allstate's careers page and normalized into a canonical job model.