Property Claims - Infrastructure, Data, and Automation Engineer Senior Consultant - Remote

Allstate • USA - VA (Remote), VA

2d • $75,100 - $130,200 • Remote

About The Position

We are seeking an Infrastructure, Data, and Automation Engineer to play a key technical role in advancing Property Claims’ cloud-first data initiatives and automation strategy across Microsoft Fabric, Azure, AWS and on-premises Linux environments. This role will design, build, and maintain scalable, secure infrastructure and automation solutions that enable real-time decisioning, operational reporting, advanced analytics, and vendor integrations across the Property line of business.

Requirements

• Ad Hoc Analysis
• Advanced Analytics
• Business Influence
• Cloud Engineering
• Critical Thinking
• Data Analysis
• Data Build Tool
• Data Engineering
• Python (Programming Language)
• Structured Query Language (SQL)

Nice To Haves

• Strong Python skills, particularly within data engineering, ETL, and automation use cases.
• Experience with Microsoft SQL Server, including query development and data modeling.
• Experience working with Oracle databases.
• Familiarity with Microsoft Azure services such as Event Hub and ADLS storage.
• Experience with Terraform or other Infrastructure-as-Code tooling.
• Working knowledge of Microsoft Fabric.
• Experience designing, building, or supporting ETL/ELT pipelines.
• Experience supporting external vendor integrations.
• SFTP integration and secure file-transfer patterns.
• API-based vendor or system integrations.
• Hybrid cloud and on-premises engineering.
• Cross-platform data movement across cloud storage, databases, and analytics platforms.

Responsibilities

• Design, provision, and maintain Azure resources including ADLS Gen2, Event Hub, Function Apps, networking components, and Azure SQL Managed Instance.
• Develop and manage Infrastructure-as-Code using Terraform and Env0.
• Support GitHub-based CI/CD integration for infrastructure and application delivery.
• Build and maintain solutions across Microsoft Fabric Lakehouse, OneLake, Pipelines, and Real-Time Analytics.
• Enable secure vendor integrations through SFTP and API-based patterns.
• Support Linux-based engineering environments and operational workloads.
• Develop Python-based ETL processes and automation solutions.
• Manage and support Airflow orchestration for data pipeline execution.
• Integrate with Oracle, SQL Server, Snowflake, AWS S3, ADLS, and OneLake platforms.
• Support secure SFTP and PGP-encrypted data exchanges.
• Deliver real-time operational insights and automated reporting capabilities.
• Support predictive modeling and advanced analytics initiatives.
• Contribute to data platform modernization across cloud and on-premises environments.
• Partner with internal teams and external vendors to deliver end-to-end engineering solutions.

Benefits

• Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
• Monthly connectivity reimbursement for remote employees.
• Paid holidays
• Health insurance
• Dental insurance
• Vision insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed