Data & Analytics Specialist I/II/Sr

Date: Sep 15, 2023

Location: Erie, PA, US, 16530

Company: Erie Insurance

Division or Field Office:

Commercial Lines Products Division

Department of Position: Data & Analytics 

Work from:

Corporate Office in Erie, Pa
Salary Range:

$53,114.00 - $133,504.00 

*salary range is for this level and may vary based on actual level of role hired for

*This range represents a national range and the actual salary will depend on several factors including the scope and complexity of the role and the skills, education, training, credentials, location, and experience of an applicant, as well as level of role for which the successful candidate is hired.


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. 

We strive to be Above all in Service® to our customers—and to our employees. That’s why Erie Insurance offers you an exceptional benefits package, including:

•          Premier health, prescription, dental, and vision benefits for you and your dependents. Coverage begins your first day of work.

•          Low contributions to medical and prescription premiums. We currently pay up to 97% of employees’ monthly premium costs.

•          A pension. We are one of only 13 Fortune 500 companies to offer a traditional pension plan. Full-time employees are vested after five years of service.

•          A 401(k) with up to 4% contribution match. The 401(k) is offered in addition to the pension.

•          Paid vacation, personal days, sick days, bereavement days and parental leave.

•          Career development, including a tuition reimbursement program for higher education and industry designations.

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


Position Summary

Assesses basic information needs, designs studies, analyzes results and delivers key findings in support of business leaders. Plans and manages data and analytics projects of low to moderate complexity and impact to the business.


  • The Hiring Manager will consider candidates for Data & Analytics Specialist I, II or Sr.  Level of position offered will be based upon the depth and breadth of selected candidate’s experience and qualifications.
  • This is an in office position in Erie, Pa with the possibilty of hybrid flexiblity. 


  • We are looking for a diverse pool of candidates with the skillsets below:
    • Problem solving skills
    • Verbal and written communication skills
    • Accuracy and attention to detail
    • Strong mathematical skills
    • Adept at writing quieries, creating reports and making presentations
    • Knowledge of data visualizations software (Tableau, QLIK)
    • Knowledge of coding lanuages (SQL, R, SAS or Python)


  • If you have skills in one or more of the above areas, we would love the opportunity to get to know you, speak with you, and potentially set up an initial exploratory interview. 


Duties and Responsibilities

  • Supports modeling and developing data warehouse programs of low to moderate complexity ensuring business needs are met. Analyzes metrics and supports audit of source data.
  • Supports the planning, development, modeling, implementation and reporting of all related data.
  • Assists in identifying 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.
  • Assists in preparing ad-hoc and recurring reports using appropriate programming languages and software tools. Analyzes 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.
  • 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.
  • Conducts special research studies as directed.


The first two duties listed are the functions identified as essential to the job. Essential functions are those job duties that must be performed in order for the job to be accomplished.

This position description in no way states or implies that these are the only duties to be performed by the incumbent. Employees are required to follow any other job-related instruction and to perform any other duties as requested by their supervisor, or as become evident.


Values Diversity
Nimble Learning
Customer Focus
Cultivates Innovation
Information Management Skills
Instills Trust
Optimizes Work Processes
Job-Specific Knowledge
Ensures Accountability
Decision Quality


The minimum education and experience requirements are as follows:


Bachelor's degree in Mathematics or related field; or


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


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


or High school diploma or GED with five 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. Basic understanding of dataset, programming, querying and reporting design required. Basic understanding of programming with SAS, SQL, SPSS, Python, R, or other related data analysis programs preferred. Understanding of 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/Moving 0-20 lbs; Occasional (<20%)
Lifting/Moving 20-50 lbs; Occasional (<20%)
Ability to move over 50 lbs using lifting aide equipment; Occasional (<20%)
Driving; Rarely
Pushing/Pulling/moving objects, equipment with wheels; Occasional (<20%)
Manual Keying/Data Entry/inputting information/computer use; Often (20-50%)
Climbing/accessing heights; Rarely

Nearest Major Market: Erie