IT Analyst (Data)

Date: Mar 28, 2024

Location: Erie, PA, US, 16530

Company: Erie Insurance

Division or Field Office:

Product & Sales Technology Division

Department of Position: Commercial Lines Tech Dept 

Work from:

Millcreek (Westport)
Salary Range:

$67,958.00 - $108,556.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. 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 one of only 13 Fortune 500 companies to offer a traditional pension plan. Full-time employees are vested after five years of service.
  • 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

Coordinates transitions to new vendors, new business or technical processes, new technology or significant changes to current technology. Implements changes that will affect business or technical processes with a moderate to high impact for stakeholders and will present challenges in complexity or deadlines. May perform duties in one or more of the following disciplines: Business Data Business Intelligence Security Quality User Experience Production Control


What You Will Do:

This is an opportunity for an IT Analyst (Data) and will focus on the delivery of Commercial Lines initiatives. The primary assignment is for Workers Compensation projects but may also support data analysis needs for other projects in the department. 

  • Serves as a data modeler within a project team; performs complex modeling efforts within a portfolio; creating data models utilizing various data modeling languages, data model types, data model best practices, data model use cases and technologies.
  • Proficient in reverse/forward engineering data models; performs inter-portfolio data model reviews.
  • Develops and enforces data naming standards and best practices by aligning with Enterprise Data Architects.
  • Creates efficient technology agnostic conceptual & logical data models i.e. relational (OLTP), dimensional (OLAP).
  • Creates data attributes & definitions by eliciting business requirements or leveraging existing definitions from metadata tools such as Information Governance Catalog (IGC).
  • Creates efficient physical data models optimal for technologies such as NoSQL and relational databases (RDBMS) in association with database engineers and administrators.
  • Collaborates with Lead and Principal data analysts to ensure consistency on the data modeling best practices.
  • Reviews professional data modeler deliverables


Preferred Experience and Skills:

  • Code/decode analysis and development
  • Logical data modeling
  • Data requirements elicitation
  • Canonical mapping analysis


What Makes You Stand Out:

  • Prior experience in data analysis
  • Prior experience with the Agile methodology

Duties and Responsibilities

  • Analyzes business or technical processes with a moderate to high impact for stakeholders.
  • Conducts research, generates comparisons, draws conclusions, makes recommendations and validates solutions to effect transitional changes.
  • Ensures actions are in alignment with enterprise strategies.
  • Collaborates across multiple teams to drive analysis management processes (i.e. business, quality, experience, system).
  • Utilizes technical guidance received from leaders and higher-level peers to address complex problems and projects. 
  • Effectively communicates with customers, team members or other stakeholders to ensure successful outcomes.
  • Participates in the execution and implementation of solutions.


The first six 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 clear.



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


Minimum Educational Requirements and Experience Equivalencies:

  • Bachelor's degree in IT, MIS, Business or related field, plus two years' related experience; or
  • Associate's degree in a technical field, plus four years' related experience; or
  • High school diploma plus six years' related experience.

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; Rarely
  • Driving; Occasional (<20%)
  • Pushing/Pulling/moving objects, equipment with wheels; Rarely
  • Manual Keying/Data Entry/inputting information/computer use; Frequent (50-80%)
  • Climbing/accessing heights; Rarely

Nearest Major Market: Erie