Data & Analytics Specialist II

Date: Jul 7, 2020

Division or Field Office:

Customer Service Division

Department of Position: Center of Excellence Dept 

Work from:

Corporate Office in Erie, PA


At Erie Insurance, you’re not just part of a Fortune 500 company; you’re also a valued member of a diverse and inclusive team that includes more than 5,000 employees and over 2,200 independent agencies.  Our Employees work in the Home Office complex located in Erie, PA, and in our Field Offices that span 12 states and the District of Columbia.  To attract and retain the best talent, we reward our team members with competitive salaries and a very generous benefits package.


Position Summary

Erie Insurance is continuing to hire and is utilizing virtual interviews to ensure the well-being of our candidates and employees. Please note there may be delays in our hiring process.


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.

There are two positons available.


The Hiring Manager will consider candidates for the levels of Data & Analytics Specialist I, II and/or Sr. for both openings; level of position offered will be based upon the depth and breadth of selected candidates experience and qualifications.

Duties and Responsibilities

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.


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.


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.


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.

Ability To Learn And Follow Procedures
Ability To Maintain Composure
Ability to Manage Complexity
Decision Making
Developing And Maintaining Relationships
Influencing Skills
Information Management Skills
Interpersonal Communication
Job-Specific Knowledge
Planning And Organizing
Presentation Skills
Problem Analysis
Service Orientation
Time Management

The minimum education and experience requirements are as follows:


Bachelor's degree with three years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or


Associate degree and five years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or


High school diploma or GED with seven years of experience in research, analysis, strategic planning, financial analysis, information systems or related field.


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.

Physical Requirements
Lifting 0-20 lbs; Occasional (<20%)
Lifting 20-50 lbs; Occasional (<20%)
Lifting Over 50 lbs; Occasional (<20%)
Driving; Rarely
Pushing/Pulling; Occasional (<20%)
Manual Keying/Data Entry; Often (20-50%)
Climbing; Rarely

Nearest Major Market: Erie

Job Segment: Database, Information Systems, Developer, SQL, Project Manager, Technology