Remote Data Engineer - Risk Data Pipelines

Allstate Northern Ireland Limited; Illinois; Remote; USD 100,000 - 171,000; Full time

Job summary

Allstate is seeking a Data Engineer (Remote, US) to help build the trusted data foundation that enables faster risk decisions and measurable improvements in control effectiveness. You will design and maintain batch and streaming data pipelines, ingest data from multiple sources, and deliver analytics-ready datasets for dashboards and AI capabilities.

You will collaborate with analytics, product, risk, governance teams and operate in an Agile environment, leveraging cloud-native technologies and

Qualifications

• 4+ years of experience as a Data Engineer or in a similar role building and supporting production-grade data pipelines and data products.
• Hands-on experience with Apache Spark for large-scale data processing and transformation.
• Strong proficiency in Python, SQL, and modern data engineering best practices.
• Experience developing ETL/ELT solutions within cloud-based data lake, lakehouse, or analytics platforms.
• Experience designing and optimizing analytical data models that support reporting, dashboards, operational insights, and advanced analytics.
• Strong understanding of data quality, validation, monitoring, reconciliation, and production support processes.
• Experience with CI/CD pipelines, version control, automated testing, and infrastructure-as-code concepts.

Responsibilities

• Design, build, and maintain trusted risk data products and scalable batch and streaming data pipelines using cloud-native technologies.
• Integrate data from risk platforms, control systems, vendor tools, operational applications, and external sources into governed, analytics-ready datasets.
• Develop and optimize ETL/ELT workflows that automate data ingestion, transformation, validation, reconciliation, and delivery.
• Build and manage data processing workloads within modern data lake and lakehouse environments, including Microsoft Fabric and OneLake.
• Implement data quality, monitoring, lineage, and reconciliation processes to ensure data reliability, consistency, and accuracy.
• Create curated datasets and analytical outputs that support operational reporting, leadership dashboards, trend analysis, risk identification, and decision-making.
• Optimize data architectures, schemas, and processing patterns for scalability, performance, resilience, and cost efficiency.
• Develop reusable frameworks, engineering standards, CI/CD pipelines, automated testing, and operational monitoring to improve productivity and maintainability.
• Partner with analytics, product, risk, governance, security, and compliance stakeholders to establish data definitions, metrics, quality standards, and secure data access.
• Participate in Agile delivery activities including sprint planning, backlog refinement, design reviews, and continuous improvement initiatives.

Skills

Apache Spark

Python

SQL

ETL/ELT

Data Pipelines

CI/CD

Tools

Microsoft Fabric

OneLake

Job description

Allstate is seeking a Data Engineer (Remote, US) to help build the trusted data foundation that enables faster risk decisions and measurable improvements in control effectiveness. You will design and maintain batch and streaming data pipelines, ingest data from multiple sources, and deliver analytics-ready datasets for dashboards and AI capabilities.

You will collaborate with analytics, product, risk, governance teams and operate in an Agile environment, leveraging cloud-native technologies and