IT Analyst

Date: Jun 24, 2020

Division or Field Office:

Business Apps & Sprt Division

Department of Position: Personal Lines Tech Department 

Work from:

Corporate Office, 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

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


This role will be working with the personal lines Integration team in the capacity of data requirement gathering, data mapping, and data modeling between our policy administration, management, and down-stream consuming systems/applications.

  • Activities include data analysis & problem solving, data differentiation, data elements, data modeling, canonical data mapping, QA testing of transactional and reporting systems data services.

Preferred Experience & Skills include:

  • Experience in requirement gathering; handling business and technical issues while communicating with both business and technical users.
  • Experience in developing appropriate data requirements documentation in line with SDLC framework including data requirements, logical mappings, and canonical mappings.
  • Experience in developing data flows, application and ER diagrams, technical specifications, implement tools, scripts, and queries.
  • Experience and/or understanding of data transformation, data mapping from source to target database schemas, and data cleansing.
  • Experience in developing conceptual, logical models, and physical database design for online transactional processing (OLTP) and online analytical processing (OLAP) systems.
  • Strong data analysis experience in data migration projects including good understanding of NoSQL (XML document database) internals, features, and configurations.
  • Experience in interpretation of business reporting data needs.
  • Ensuring data model changes are designs are in alignment with enterprise data standards inclusive of appropriate naming best practices.
  • Solid understanding of data warehouse concepts and well versed with data profiling, data migration, and data conversions.
  • Strong working experience with agile and waterfall methodologies.
  • Experience in application / service testing.
  • Self-motivated, diligent, ability to adapt to new environments and situations quickly.

Other Tools/Skills:

  • Data modeling tools: Erwin, ER/ Studio, MS Visio
  • Database systems: ORACLE, DB2, SQL Server, XQuery, NoSQL
  • Quality Testing:  Soap UI, HP ALM
  • Data Modeling: OLTP, OLAP, Dimension models
  • ETL Tools
  • T-SQL, PL/SQL, UNIX shell
  • Other tools: MS Office (Word, Excel, Power Point)
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.


Utilizes technical guidance received from leaders and higher-level peers to address complex problems and projects. 


Collaborates across multiple teams to drive analysis management processes (i.e. business, quality, experience, system).


Ensures actions are in alignment with enterprise strategies.


Participates in the execution and implementation of solutions.


Effectively communicates with customers, team members or other stakeholders to ensure successful outcomes.

Ability To Learn And Follow Procedures
Ability to Manage Complexity
Business Acumen
Decision Making
Developing And Maintaining Relationships
Influencing Skills
Information Management Skills
Interpersonal Communication
Job-Specific Knowledge
Planning And Organizing
Problem Analysis
Service Orientation
Time Management
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 0-20 lbs; Occasional (<20%)
Lifting 20-50 lbs; Occasional (<20%)
Lifting Over 50 lbs; Rarely
Driving; Occasional (<20%)
Pushing/Pulling; Rarely
Manual Keying/Data Entry; Frequent (50-80%)
Climbing; Rarely

Nearest Major Market: Erie

Job Segment: Database, Developer, Oracle, SQL, Unix, Technology