Risk Data Analytics Engineer: Drive Risk Insights

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

Benefits offered by this job

Connectivity reimbursement

Tech setup provided (laptop, monitors,

monitors, headset, keyboard, mouse

Job summary

Allstate is seeking a Data Analytics Engineer to build a trusted risk data ecosystem and deliver analytics, reports, and data products. You will collaborate with risk, controls, product, engineering, and leadership to drive faster, more reliable risk decisions and proactive management.

You will develop complex analytics, ensure data quality, and automate reporting processes, leveraging SQL, Power BI, Fabric, Python, and Excel to surface actionable insights for risk action.

Qualifications

• 3+ years of experience in data analytics, BI, risk analytics, or related fields.
• Experience delivering analytics or data product solutions from requirements through implementation.
• Experience with risk, compliance, controls, audit, or related complex data preferred.
• Experience improving data quality, reconciling sources, and reducing manual reporting preferred.

Responsibilities

• Lead complex risk data analytics initiatives from requirements through delivery and support.
• Translate business questions into data, analytics, and reporting requirements.
• Build and maintain trusted risk datasets, semantic models, dashboards, and reusable analytics products using SQL, Power BI, Fabric, Python, and Excel.
• Integrate data from internal platforms, vendor tools, external sources, and operational systems.
• Automate data collection, preparation, validation, reconciliation, and reporting processes.
• Define and apply common risk metrics, data definitions, and quality standards.
• Produce analytics that identify trends, weaknesses, risks, and performance gaps.
• Support governed analytics-ready data products for leadership reporting and AI capabilities.
• Establish best practices for data sourcing, transformation, governance, and reporting adoption.
• Coach analysts and enable stakeholders with templates, training, and guidance.

Skills

Business Analysis

Business Case Analyses

Business Model Development

Cyber Security

Data Analysis

Data Analytics

Data Governance

Data Quality

Risk Control

Tools

SQL

Power BI

Microsoft Fabric

Python

Excel

Job description

Allstate is seeking a Data Analytics Engineer to build a trusted risk data ecosystem and deliver analytics, reports, and data products. You will collaborate with risk, controls, product, engineering, and leadership to drive faster, more reliable risk decisions and proactive management.

You will develop complex analytics, ensure data quality, and automate reporting processes, leveraging SQL, Power BI, Fabric, Python, and Excel to surface actionable insights for risk action.