Sr Data Analyst

Mercury Insurance Services, LLC

49d • Remote

About The Position

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

Requirements

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

Nice To Haves

• Experience with machine learning preferred
• Knowledge of SAS, SPSS, and/or other statistical software preferred.

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees