Data Engineer Lead

Progressive is hiring a Data Engineer Lead for its Product Service Management team. The role builds and maintains data solutions and tackles complex challenges through data-driven software engineering, with a focus on data transformation, orchestration, and replication.

Responsibilities:

• 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
• 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

Requirements:

• 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
• 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
• 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