Progressive Insurance
is hiring
Data Analyst
About Our Company
Reality check: Most people don’t grow up dreaming about a job in insurance. We certainly didn’t, but then we got here and realized Progressive is different—in a good way. We strive to create a fun and flexible work environment for everyone where employees are encouraged to risk, learn, and grow. With our progressive culture, work-life balance, and one of the largest contemporary art collections in the country, there’s a reason we’ve been named one of the best places to work.
For more than 80 years, Progressive has offered a wide range of insurance choices to customers, including Auto, Home, Renters, Commercial Auto, Small Business, Motorcycle, Boat policies, and more. Progressive is the third largest auto insurer in the country—a combined effort of every single Progressive person. We’re a diverse group of more than 50,000 talented employees—from all walks of life, all fields of business, and all 50 states. With hundreds of career paths including Claims, Customer Care, Sales, Marketing, Legal, IT, Data Analysis and with Level20, our new business incubator, there may be an opportunity for you. Everyone here plays a role in our success as we continue to find new and better ways to move the insurance industry forward and be there for our customers during every stage of their lives.
Job Description & Responsibilities
As a data analyst mid or senior in the Corporate Strategy Control group, you’ll orchestrate financial and operational analytics from the ground up, focusing on building and developing database, analytical, and reporting capabilities. You’ll create and coordinate the reporting strategy and repository, craft reports that allow for the analysis and reconciliation of data against budget and forecasts, and act as a thought partner to challenge and inform financial projections and our view of financial and operational success. Collaborating with the Strategy Controller and closely working alongside the team at Level20, our innovative business incubator, you’ll contribute to data-driven decision-making and operational excellence.
This is a hybrid role that will require in-office work based on business needs (roughly one day per week) at Level20 (800 W St Clair Ave, Suite 200, Cleveland, OH 44113), where free parking is available. There will also be occasional in-office time required at Progressive Corporate Headquarters (300 N. Commons Blvd., Mayfield Village, OH 44143).
Requirements
Must-have Qualifications
- Bachelor's degree or higher in a quantitative field of study and a minimum of one year of analytical work experience
- Instead of a quantitative degree, a bachelor's degree or higher and a minimum of three years of analytical work experience
- Instead of a degree, a minimum of four years of analytical work experience
- This position requires online pre-employment testing for external candidates
Preferred Skills
- Advanced skills in designing, developing, and implementing dashboards and front-end visualizations using Power BI and/or Tableau.
- Intermediate to high proficiency in programming languages, specifically SQL.
- Experience querying data warehouses, specifically Snowflake.
- Ability to translate complex technical information from multiple sources into simple, engaging visuals for a less-technical audience.
- Full understanding of MS Office, with intermediate to advanced expertise in Excel, including VLOOKUP, pivot tables, charts, graphing, and macros.
What we offer
Compensation
- $63,800-$102,800/year
- Gainshare bonus up to 24-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 2024 Top Workplace for: Innovation, Purposes & Values, Work-Life Flexibility, Compensation & Benefits, and Leadership.