Senior Data & Analytics Specialist

Erie Insurance Group

Erie (Erie County)

On-site

USD 89,000 - 142,000

Full time

9 days ago

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits

Pension plan

401(k) with match

Paid time off

Tuition reimbursement

Job summary

Erie Insurance Group in Erie, PA is seeking a Data Analyst for the Commercial Products Data Dept. This role analyzes information needs, designs studies, manages projects, and presents key findings to business leaders to drive performance.

Responsibilities include building data warehouse models, collaborating with cross‑functional teams, and delivering ad hoc and recurring reports. A bachelor's degree with five years' experience (or equivalent) and strong SAS/SQL/Python/SPSS skills are required.

Qualifications

Bachelor's degree plus 5 years of experience in research, analysis, strategic planning, financial analysis, information systems or related field.
Associate degree and seven years of experience in research, analysis, strategic planning, financial analysis, information systems or related field.
High school diploma or GED with nine years of experience in research, analysis, strategic planning, financial analysis, information systems or related field.

Responsibilities

Creates models and data warehouse programs of moderate to high complexity ensuring business needs are met.
Partners with areas across the organization to define and implement research designs and quantitative techniques.
Supports the planning, development, modeling, implementation and reporting of all related data.
Applies knowledge of programming languages and software tools to prepare ad hoc and re-occurring reports.
Measures the effectiveness of the data and analytics strategies in driving performance improvement.

Skills

SAS

SQL

Python

SPSS

Education

Bachelor's degree

Associate degree

High school diploma

Tools

Word processing

Spreadsheets

Databases

Presentation software

Flowcharting

Job description

Division Or Field Office

Commercial Products & Serv Div

Department of Position:

Commercial Products Data Dept

Work From

Corporate Office, Erie PA

Salary Range

$88,693.00 - $141,678.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 (State) based on ERIE's geographical differences, and experience of an applicant, as well as level of role for which the successful candidate is hired. Position may be eligible for an annual bonus payment.

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 6,000 employees and over 13,000 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.

Benefits That Go Beyond The Basics

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.
Pension. We are among the 2% of Fortune 500 companies to offer a traditional pension plan. Full-time employees are vested after five years of services.
401(k) with up to 4% contribution match. The 401(k) is offered in addition to the pension.
Paid time off. 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

Please note that we are only considering US workers for this position, and we are unable to offer this position to individuals who will require current or future immigration sponsorship for employment.

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

Duties and Responsibilities

Creates models and develops data warehouse programs of moderate to high complexity ensuring business needs are met, including understanding ERIE's demographics and potential opportunities. Analyzes metrics and supports audit of source data.
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.
Supports the planning, development, modeling, implementation and reporting of all related 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.
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.
Creates files that include topics related to the industry, competitors, products, service innovations and trends. Works with supervisors to develop, communicate, and enforce standards for proper documentation and organization of electronic files, data and actuarial data deliverables.
Trains less experienced specialists within the section.
Conducts special research studies as directed.

The first 4 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.

Regular and predictable attendance is an essential job function. For certain positions at ERIE, including leadership roles, regular and predictable onsite presence may also be an essential job function based on business and operational needs.

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.

Capabilities

Self-Development
Collaborates
Cultivates Innovation
Instills Trust
Decision Quality
Values Diversity
Nimble Learning
Customer Focus
Optimizes Work Processes (IC)
Ensures Accountability
Information Management Skills
Job-Specific Knowledge
Using Tables And Graphs

Qualifications

Minimum Educational and Experience Requirements

Bachelor's degree with five years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or
Associate degree and seven years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or
High school diploma or GED with nine years of 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.

Physical Requirements