IT Data Modeler

Erie Insurance Group; Erie (Erie County); On-site; USD 69,000 - 111,000; Full time

Job summary

An established industry player seeks an IT Data Modeler to enhance data management within the Commercial IT department. This role offers the chance to work on diverse projects, creating and refining data models that ensure data accuracy and security. The ideal candidate will thrive in a collaborative environment, engaging with various teams to align business and technical needs. With a commitment to employee development and a comprehensive benefits package, this position promises a fulfilling career path in a supportive workplace. If you're passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Benefits

Premier health, prescription, dental, and vision benefits

Traditional pension plan

401(k) with up to 4% contribution match

Paid time off

Tuition reimbursement program

Company-paid life insurance

Short-and long-term disability insurance

Paid volunteer hours

Charitable gift matching

Qualifications

• Independently performs low to medium complexity assignments using data analytics tools.
• Responsible for data management ensuring accuracy, completeness, and security.
• Creates conceptual, logical, and physical master data models.

Responsibilities

• Works with project teams to understand data needs for projects.
• Creates efficient data models for relational and dimensional systems.
• Collaborates with stakeholders to review and evolve data models.

Skills

Data Modeling

Data Governance

SQL

Analytical Skills

Collaboration

Agile Methodology

Education

Bachelor's degree in IT, MIS, Business or related field

Associate's degree in a technical field

High school diploma

Tools

IBM IAA

SQL Server

Oracle Database

ERwin

Visio

Excel

Job description

Join to apply for the IT Data Modeler role at Erie Insurance Group

Join to apply for the IT Data Modeler role at Erie Insurance Group

Division Or Field Office

Product & Sales Technology Division

Department of Position: Commercial Lines Tech Dept

Work From

Westport Office, Erie PA

Salary Range

$69,318.00 - $110,729.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

Independently, with moderate supervision, performs low to medium complexity assignments using various tools and techniques of data analytics including data analysis and problem solving, data mapping, data modeling, and data governance.

Responsible for the company's data management, ensuring that the data that underlies an organization is available, accurate, complete and secure. This includes the processes, people and technology that will provide effective data management. Reviews existing data models to understand current environment. Creates conceptual, logical, and physical master data models (entity-relationship diagrams). Must be able to reverse engineer the existing data structure and create the Entity Relationships. Review and evolve the data models by collaborating with Stakeholders.

Candidates with above minimum qualifications may be considered for Senior IT Data Modeler. Number of years and scope of experience will be used to determine the level.

What You'll Do

This is an opportunity for an IT Data Modeler to focus on data needs in the Commercial IT department. You will work with project teams in Commercial IT to understand what data elements will be needed for the projects, and implement any updates as necessary by creating Conceptual, Logical, and Physical data models. Having an analyst work across a couple scrum teams can be beneficial in ensuring the collection and understanding of requirements to align business needs and technical needs.

Preferred Experience & Skills

• Conceptual, Logical, and Physical data modelling experience preferred
• IBM IAA experience preferred
• Commercial Insurance experience preferred
• Business Analysis/Requirements gathering experience preferred
• Experience with SQL server and Oracle database platforms preferred
• DDL generation/maintenance knowledge preferred
• Familiarity with the following tools preferred
• Multi Model Mapper
• ERwin
• Visio
• Excel
• Enterprise Business Agility Training
  
  

What Makes You Stand Out

• Work on Agile teams
• Experience with data tools
• Experience with Jira and Miro
  
  

Duties and Responsibilities

• Creates efficient technology agnostic conceptual and logical data model. s for relational (OLTP), dimensional (OLAP) systems.
• 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 database administrators.
• Creates and maintains review and feedback channels on the data models with stakeholders, project leads, data architects, lead analysts, and other team members.
  
  

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

Capabilities

• Collaborates
• Cultivates Innovation
• Customer Focus
• Decision Quality
• Ensures Accountability
• Instills Trust
• Nimble Learning
• Optimizes Work Processes (IC)
• Self-Development
• Values Diversity
  
  

Qualifications

Minimum Educational and Experience Requirements

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

Additional Experience

• Skills: Accountability, Adaptability, Agile Methodology, Analytical Skills, Auditing, Change Management, Collaboration, Data Cleansing, Data Governance, Data Integration, Data Maintenance, Data Modeling, Data Profiling, Data Structures, Data Validation, Detail Oriented, Enterprise Resource Planning, Extract Transform Load (ETL), Influencing Skills, Informatica, Informatica Master Data Management, Microsoft SQL Servers, Presentation Skills, Process Improvement, SQL (Programming Language), Troubleshooting (Problem Solving), Workflow Management, Writing, data modeling & data administration tools (i.e., Erwin, Designer/2000, Rational Rose, Power Designer, Embarcadero, System Architect) etc.
  
  

Physical Requirements

Ability to move over 50 lbs using lifting aide equipment; Rarely

Climbing/accessing heights; Rarely

Driving; Occasional (Lifting/Moving 0-20 lbs; Occasional (

Lifting/Moving 20-50 lbs; Rarely

Manual Keying/Data Entry/inputting information/computer use; Frequent (50-80%)

Pushing/Pulling/moving objects, equipment with wheels; Rarely

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Insurance

Referrals increase your chances of interviewing at Erie Insurance Group by 2x

Get notified about new Data Modeler jobs in Erie, PA.

Graduate Assistant - Software Eng. and Data Mining

Systems Engineer Sr - Risk and Opportunity

Systems Engineer, Specialty Integration Lead

System Engineer Staff, SPACE - Clearance Required

Sr. Systems Engineer - Secret Clearance Required

Software Engineer, Staff (Level IV) - TS/SCI w Poly

Erie, PA $100,000.00-$125,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.