Sr Data Analyst

Overview

Position Summary:The primary job function, under general supervision, is to work with the various functional areas (UW, Claims, Marketing, Advertising) in an effort to provide data-driven analysis of our many processes. This position will require a solid background of statistical concepts and statistical tools. The employee will conduct analysis using statistical techniques in order to extract information from data, which will be of value in process efficiency and product design. Employee must have a passion for problem solving, comfort with ambiguity and the ability to think conceptually, analytically and creatively, and will be expected to manage projects and program execution of high complexity

Geo-Salary Information

An in-person interview may be required during the hiring process

State specific pay scales for this role are as follows:

$85,480 to $157,868 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA)

$77,709 to $143,516 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)

$69,938 to $129,965 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

Responsibilities

Essential Job Functions:

• Analyzes data available and identify issues and opportunities in different business areas. Understands the processes in departments (UW, Claims, Marketing, Advertising, etc.).
• Creates statistical models to generate insights on different business issues and provide suggestion on approaches to problems.
• Lead small-scope project work and ad hoc analyses.
• Works with junior analysts and provide support/ mentoring during the projects.
• Lead the discussions with colleagues regarding analysis needs.
• Reviews the results with colleagues and managers as necessary.
• Supports projects by applying general knowledge of the business area processes, including best practices.
• Provides analysis to better understand implementation options for analytical models/ procedures and work closely with other groups through implementation processes.
• Retrieves data from various sources and prepares data for analysis.
• Reviews data for accuracy and revises methods of data retrieval when necessary.
• Prepares reports, graphs and charts based on research and analyses.
• Analyzes algorithms using intermediate SAS programming and MS Excel.
• Create procedures to streamline analysis procedures.
• Provides suggestions for process improvements and/or goal changes.
• Develops and designs presentations to show findings of analyses.
• Develops spreadsheets and tools for management use.
• Serves as a contact regarding various data.
• Communicates proactively, clear and consistently with SME's and Management in the various functional areas in order to understand each job function. Through this communication, the employee will be expected to increase the breadth of his/her understanding of the processes associated with these functions, and of the various KPl's that drive business results in each area and overall.
• Mentor junior analysts in the team provide training and support.
• Creates presentations breaking down problems identified, potential solutions.
• May attend management meetings to present findings and recommendations.
• Employee should have a strong background in creating and explaining meaningful graphs and also be skilled at assembling and presenting PowerPoint presentations.
• This specific role will focus on competitive analysis for our personal lines products, including data ingestion, scrubbing and analysis of internal and external competitive data. Creating robust dashboards and reports and sharing competitive position insights with cross-functional teams. 

Qualifications

Education:

• Worker characteristics are normally acquired through the successful completion of a Bachelor's in an analytical concentration, such as math, statistics, economics, data science, engineering, etc. Master's Degree recommended.

Experience:

• At least 5-7 years’ experience in property & casualty insurance analytics, product development, competitive intelligence or equivalent combination of education and experience.

Knowledge and Skills:

• Strong experience with SQL (Redshift, Postgre Sql) and DBT required. Develop and maintain dbt models and tests to standardize data transformations and enforce data quality.
• Strong experience with Github required. Github version-control experience preferred. Manage and version analytical code using Git and GitHub, including branching, pull requests, and code reviews
• Strong experience with Python required. 
• Knowledge of statistics and general model building/ validation procedures required.
• BI & Reporting Tools required
• Experience with machine learning preferred
• Knowledge of SAS, SPSS, and/or other statistical software preferred.
• Intermediate-level skills in MS Excel and MS Access required.
• Strong data skills and ability to work with massive datasets.
• Good problem solving skills required.
• Good analytical and critical thinking required.
• Good written and verbal communication skills required.

About the Company

Why choose a career at Mercury?

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it.

Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

Learn more about us here: https://www.mercuryinsurance.com/about/careers

Perks and Benefits

We offer many great benefits, including:

• Competitive compensation
• Flexibility to work from anywhere in the United States for most positions
• Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
• Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
• Medical, dental, vision, life, and pet insurance
• 401 (k) retirement savings plan with company match
• Engaging work environment
• Promotional opportunities
• Education assistance
• Professional and personal development opportunities
• Company recognition program
• Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more

Mercury Insurance is an equal opportunity employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

Pay Range