Join Forbes' 2024 Best Employer for Diversity!

As abusiness intelligence developer lead on the Performance Measurement and Analysis team, you'll collaborate with Analysts in converting recurring SAS workloads into well-designed DBT models. This team is crucial to Progressive's data-driven decision-making for a ~$1.9 billion arm of the company. Leveraging DBT as the orchestration engine, they also build and manage the PMA database in Snowflake, a Data Mart that captures interactions between customers, employees, and business processes. As the BI developer lead, you'll work with internal analysts to understand their requirements, collaborate with peers, present unique findings to leadership, and implement solutions.

This is a remote position for US based work only.

Must-have qualifications

• A minimum of 7 years related work experience with working knowledge of designing/developing, programming and supporting software programs/applications.
• Bachelor's degree or higher in in an Information Technology or Business discipline or related field of study (e.g., Computer Science, MIS, Business Management) and a minimum of 4 years designing/developing, programming and supporting software programs/applications.

Preferred skills

• Expert-level knowledge of SQL with a strong ability to create SQL ETL processes.
• Prior use of DBT to build, test, and maintain transformation workflows.
• Experience with SAS or a demonstrated ability to quickly learn new programming languages.
• Ability to work collaboratively with cross-functional teams and translate complex technical information for diverse audiences.
• Experience with Snowflake and cloud infrastructure platforms such as AWS, as well as use of Python for data manipulation and pipeline tasks.
• Ability to mentor and coach team members, fostering a collaborative and growth-oriented environment.

Compensation

• $114,000 - $143,000/year depending on position level and experience
• 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 2024 Top Workplace for: Innovation, Purposes & Values, Work-Life Flexibility, Compensation & Benefits, and Leadership.

Equal Opportunity Employer

Sponsorship for work authorization for foreign national candidates is available for this position. Individuals in F-1 visa status who will need sponsorship now or in the future are not eligible for hire for this position.

For ideas about how you might be able to protect yourself from job scams, visit our scam-awareness page at

#LI-Remote

#LI-CL1