✦ Luna Orbit — Data & Analytics

Data Analyst Lead

at Progressive

📍 Remote, US Remote 💰 $98K – $131K USD / year Posted April 07, 2026
Salary $98K – $131K USD / year
Type Not Specified
Experience lead
Exp. Years Eight+ years
Education Bachelor's degree or higher in a quantitative field
Category Data & Analytics

Lead data analyst for the Claims Triage and Automation program, transforming large datasets into a curated analytics layer and guiding data modeling and reporting.

  • Turn complex, high-volume data into business-ready datasets
  • Design data models and transformation pipelines
  • Build curated analytics layer as single source of truth
  • Document datasets, metrics, and business logic
  • Guide collaborators on data usage and insights

Hands-on analytics engineering with Snowflake, dbt, and BI tooling; focus on data modeling, ETL/ELT, and data governance.

An experienced data analyst lead with 8+ years in analytics, strong SQL and Python skills, experience with Snowflake and dbt, and a track record of delivering analytics in an insurance/claims context.

Eight+ years of analytical work experienceStrong SQL expertise (complex joinswindow functionsperformance optimization)Prior Python experienceExperience building data transformations in a warehouse environment (dbtETL/ELTSnowflake)Experience with Snowflake or similar cloud data platformAbility to learn dbt if not familiarExperience with BI tools (Power BITableau)
Experience with largeunstructuredor third-party datasetsAbility to bring structure to ambiguityExperience with BI tools for data visualization
SnowflakedbtPower BITableau
Eight+ years analyticsSQLPythondbtSnowflakeETL/ELTdata modelingstored proceduresPower BITableau
SQLPythondbtSnowflakeETLELTData modelingStored proceduresPower BITableauBI toolsAnalytics engineeringdata warehouse
Analytical thinkingCommunicationProblem-solvingCollaboration
Industry Insurance
Job Function Lead analytics engineering and data transformation initiatives to enable data-driven decisions in Claims Control
Role Subtype Data Analyst Lead
Tech Domains Snowflake, dbt, Power BI, Tableau, SQL / PostgreSQL
data analyst leadprogressiveremotesnowflakedbtetleltpythonsqlpower bitableauanalytics engineeringdata warehousedata modelingbi toolsSnowflakeSQLPythonETLELTPower BITableauData WarehouseData Modeling

8+ years analytics experience, Strong SQL expertise, Experience with Snowflake/dbt

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile