Data Engineer Lead

Progressive; United States; Remote; USD 148,000 - 165,000; Full time

Benefits offered by this job

401(k) match

Medical/dental/vision

Wellness programs

FSA/HSA + life

PTO & volunteering

Sick leave & disability

Parental leave

Tuition assistance

Onsite gym

Job summary

Progressive is seeking a data engineer lead on our Product Service Management team to design, build, and maintain highly available data solutions built on modern cloud architecture. You will lead data transformation, orchestration, and replication efforts, using tools like DBT, Prefect, HVR, and Snowflake, while collaborating across teams to deliver value to customers.

This is a remote position for U.S.-based work only, with opportunities for career growth through training, innovation events,

Qualifications

• Bachelor's degree in Information Technology or related field with 5+ years of experience OR 6+ years related experience in lieu of degree.
• Experience building data pipelines for collecting, transforming, and integrating data from multiple sources.
• Strong knowledge of cloud platforms and data tooling (AWS, Snowflake, data replication/orchestration).

Responsibilities

• Design, build, and maintain scalable data solutions.
• Lead data transformation, orchestration, and replication efforts.
• Collaborate with cross-functional teams to deliver data-driven value to customers.
• Support and innovate within CI/CD practices and modern cloud architectures.

Skills

Data pipelines

Python

SQL

Data lifecycle

ETL/ELT

Data replication

Education

Bachelor's Degree in IT or related field

6+ years related work experience

Tools

AWS

Snowflake

HVR

Prefect

DBT

SSIS

Job description

Progressive is dedicated to helping employees move forward and live fully in their careers.

Your journey has already begun.

As a data engineer lead on our Product Service Management team, you’ll contribute to highly available and scalable solutions that are built on cutting-edge cloud architecture. Our organization is focused on using new technologies, modern CI/CD practices, and the right tools to enhance our ability to deliver value to our customers. In this role, you'll build and maintain the data solutions. You'll be responsible for tackling complex challenges through data-driven software engineering, leveraging your expertise in data transformation, orchestration, and replication. You’ll also be encouraged to grow in your career through new challenges, innovation events, and training opportunities.

This is a remote position for U.S. based work only.

Minimum qualifications

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

Preferred Skills

• Experience with building data pipelines for collecting, transforming, and integrating data from various sources
• Experience with cloud platforms like AWS (S3, Lambda, EMR) and cloud services like Snowflake with data replication, orchestration, and transformation tools (HVR, Prefect, DBT, etc. or similar tech stack)
• Experience with programming languages such as Python, SQL and related technology stacks
• Comprehensive understanding of the data lifecycle, from ideation and ETL/ELT processes, through deployment of data products, ensuring efficient data enablement and reporting solutions
• Experience/exposure to SQL Server Integration Services

Compensation

• $148,300 - $164,800/year
• Gainshare annual cash incentive payment up to 40% 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.

We’ll consider qualified applicants with arrest and conviction records. Note that federal law may prohibit individuals with certain felony convictions from working in the insurance industry unless they have obtained the required regulatory authorization.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.