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.