Data Analytics Engineer - Risk Insights & Automation

Allstate Private Limited; Illinois City (IL); Remote; USD 98,000 - 168,000; Full time

Job summary

Allstate is seeking a Data Analytics Engineer to help the Risk Data Team build a trusted, connected analytics ecosystem. You will transform fragmented risk data into actionable information, enabling faster decisions and proactive risk management.

You will partner across risk, controls, regulatory, product, and engineering teams to deliver analytics, reporting, and data products. Expect to leverage SQL, Power BI, Fabric, Python, and Excel to drive risk insights and governance.

Qualifications

• 3+ years of experience in data analytics, BI, risk analytics, data governance, or related field.
• Experience delivering analytics, reporting, or data product solutions from requirements through implementation.
• Experience working with risk, compliance, controls, audit, cybersecurity, or insurance data preferred.
• Experience improving data quality, reconciling data sources, or reducing manual reporting is preferred.

Responsibilities

• Lead complex risk data analytics initiatives from requirements through delivery, validation, and support.
• Translate business questions into data, analytics, and reporting requirements with stakeholders.
• Build and maintain trusted risk datasets, models, dashboards, and reusable analytics products using SQL, Power BI, Fabric, Python, and Excel.
• Integrate information from internal platforms, vendor tools, external sources, and operations for a connected risk view.
• Automate data collection, preparation, validation, reconciliation, and reporting to reduce manual effort.
• Define data definitions, metrics, and governance to ensure consistent reporting.

Skills

Data Analytics

Data Governance

Data Quality

Risk Control

Business Analysis

Cyber Security

Tools

SQL

Power BI

Microsoft Fabric

Python

Excel

Job description

Allstate is seeking a Data Analytics Engineer to help the Risk Data Team build a trusted, connected analytics ecosystem. You will transform fragmented risk data into actionable information, enabling faster decisions and proactive risk management.

You will partner across risk, controls, regulatory, product, and engineering teams to deliver analytics, reporting, and data products. Expect to leverage SQL, Power BI, Fabric, Python, and Excel to drive risk insights and governance.