Intermediate Data Engineer

Progressive Insurance; United States; Remote; USD 98,000 - 109,000; Full time

Benefits offered by this job

401(k) match

Medical, dental & vision

Wellness programs

Paid time off

Parental leave

Tuition assistance

Onsite gym

Job summary

Progressive Insurance is seeking an intermediate data engineer to join the IT Data Management Team. You’ll work with data engineers, BI developers, and data analysts to optimize data, expand pipelines, and automate orchestration, enabling faster insights and governance across disparate data sources.

The position is remote for US-based work, with a focus on scalable data ingestion and transformation, industry trend research, and strategic technical recommendations.

Qualifications

• Bachelor’s Degree or higher in an Information Technology discipline or related field of study and minimum of one year of work experience designing, programming, and supporting software programs or applications.
• In lieu of degree, minimum of two years related work experience designing, programming, and supporting software programs or applications may be accepted.

Responsibilities

• Design, code, test and optimize data pipelines to support data-driven insights.
• Automate data orchestration and reduce manual data preparation to speed time-to-insights.
• Centralize disparate data sources to strengthen data governance and eliminate data silos.
• Manage data ingestion and transformation jobs as data volumes grow.
• Research industry trends and implement new techniques to advance data strategy.

Skills

Python

R

SQL

Snowflake

SSIS

Prefect

DBT

Airflow

Power Automate/Power Apps

Orchestration tools

Education

Bachelor's degree in IT or related field

Tools

Jenkins/Azure DevOps

Unix shell scripting

AWS S3

Job description

As an intermediate data engineer on the new IT Data Management Team in IT Control, you’ll work with our Data Engineer Lead, Data Engineer, BI Developer and IT Control Data Analysts team to optimize our data and expand our data pipeline infrastructure. You’ll help drive faster time-to-insights by automating data orchestration and reducing manual data preparation. You’ll use your expertise to help analysts access and analyze data more quickly while eliminating data silos, unlocking data and strengthening data governance through the centralization of disparate data sources. You’ll help position IT data for scalable growth by managing data ingestion and transformation jobs as data complexity and volumes increase. You’ll research industry trends and Progressive enterprise-wide data and architecture capabilities, implement new techniques as needed, and provide technical recommendations to help advance our data strategy.

This is a remote position for US based work only.

Minimum Qualifications

• Bachelor’s Degree or higher in an Information Technology discipline or related field of study and minimum of one year of work experience designing, programming, and supporting software programs or applications.
• In lieu of degree, minimum of two years related work experience designing, programming, and supporting software programs or applications may be accepted.

Preferred Skills

• Experience with Python, R, SQL, Snowflake, SSIS, Prefect, DBT, Airflow, Power Automate/Power Apps, or similar programming and orchestration tools.
• Experience with data pipelines, ETL processes, data warehouse infrastructure, and structured/unstructured data.
• Familiarity with cloud services, AWS S3 concepts, external APIs, and high-volume/large dataset manipulation.
• Experience with CI/CD automation, such as Jenkins or Azure DevOps, and Unix/Shell scripting.
• Strong presentation, written and verbal communication, and influencing skills.

Compensation

• $97,650 – $108.500/year
• Gainshare annual cash incentive payment up to 30% of your eligible earnings based on company performance

Benefits

• 401(k) with dollar-for-dollar company match up to 6%
• Medical, dental & vision, including free preventative care
• Wellness & mental health programs
• Health care flexible spending accounts, health savings accounts, & life insurance
• Paid time off, including volunteer time off
• Paid & unpaid sick leave where applicable, as well as short & long-term disability
• Parental & family leave; military leave & pay
• Diverse, inclusive & welcoming culture with Employee Resource Groups
• Career development & tuition assistance
• Onsite gym & healthcare at large locations

Energage recognizes Progressive as a 2026 Top Workplace for: Innovation, Purposes & Values, Work-Life Flexibility, Compensation & Benefits, and Leadership.

Equal Opportunity Employer

Applicants must be authorized to work for any employer in the U.S. without the need or potential need, of current or future sponsorship for employment. Progressive does not hire candidates with (e.g., F-1 CPT, OPT, or STEM OPT, H-1B, O-1, E-3, TN) statuses for this role.