Data & Analytics Specialist II

Role Overview

• Assesses information needs, designs studies, manages projects, analyzes results and presents key findings in support of business leaders.
• Manages data and analytics projects of moderate complexity and impact to the business.
• Models and develops data warehouse programs of moderate complexity ensuring business needs are met, including understanding ERIE's demographics and potential opportunities.
• Analyzes metrics and supports audit of source data.
• Applies knowledge of programming languages and software tools to prepare ad hoc and re-occurring reports.
• Analyzes the financial implications of business decisions and identifies approaches to resolve business problems.
• Monitors and reports on progress and results as requested.
• Supports the planning, development, modeling, implementation and reporting of all related data.
• Works with leaders and subject matter experts to identify short
• and long-term data and analytics goals related to business objectives.
• Measures the effectiveness of the data and analytics strategies in driving performance improvement.
• Analyzes current landscape and trends to assist in planning.
• Recommends changes to business strategies and tactics as appropriate.
• Partners with areas across the organization to define and implement research designs and quantitative techniques using high-level analytical tools.
• Serves as a liaison to internal and external suppliers of data and insights.
• Creates files that include topics related to the industry, competitors, products, service innovations and trends.
• Works with specialists to develop, communicate and enforce standards for proper documentation and organization of electronic files, data and deliverables.
• Trains less experienced specialists within the section.
• Conducts special research studies as directed.

Requirements

• Bachelor's degree with two years’ experience in research, analysis, strategic planning, financial analysis, information systems or related field; or Associate degree and four years’ experience in research, analysis, strategic planning, financial analysis, information systems or related field; or High school diploma or GED with six years’ experience in research, analysis, strategic planning, financial analysis, information systems or related field.
• Additional Experience Insurance industry experience preferred.
• An understanding of analysis and research required.
• Experience with dataset, programming, querying and reporting design required.
• Advanced knowledge of SAS, SQL, SPSS, Python, R, or other related data analysis programs required.
• Experience developing, maintaining, and monitoring enterprise data governance policies and standards preferred.
• Knowledge of statistical and financial analysis and quantitative techniques preferred.
• Project management experience preferred.
• Proficiency with word processing, spreadsheet, database, presentation and flow-charting software required.
• Proficiency with research-specific, statistical report writing software preferred.

Tech Stack

• Python
• SQL

Benefits

• Premier health, prescription, dental, and vision benefits for you and your dependents.
• Low contributions to medical and prescription premiums.
• Pension.
• 401(k) with up to 4% contribution match.
• Paid time off.
• Career development.
• Additional benefits that include company-paid basic life insurance; short-and long-term disability insurance; orthodontic coverage for children and adults; adoption assistance; fertility and infertility coverage; well-being programs; paid volunteer hours for service to your community; and dollar-for-dollar matching of your charitable gifts each year.