IT Data Modeler

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

Job summary

An established industry player is seeking an IT Data Modeler to join their dynamic team in Erie. This role involves performing data analytics tasks, including data mapping and modeling, while ensuring data accuracy and governance. Collaborating with project teams, you'll create data models that align with business needs and contribute to innovative solutions in the Commercial IT department. With a commitment to employee development and a robust benefits package, this position offers a chance to grow in a supportive environment. If you're passionate about data and eager to make an impact, this opportunity is perfect for you.

Benefits

Premier health benefits

Low medical premiums

Traditional pension plan

401(k) with match

Paid time off

Career development opportunities

Company-paid life insurance

Disability coverage

Paid volunteer hours

Charitable gift matching

Qualifications

• Experience with conceptual, logical, and physical data modeling.
• Strong SQL skills and familiarity with data governance principles.
• Ability to work collaboratively in Agile teams.

Responsibilities

• Create efficient data models for relational and dimensional systems.
• Define data attributes based on business requirements.
• Collaborate with stakeholders to maintain data models.

Skills

Data Modeling

SQL

Data Governance

Business Analysis

Problem Solving

Analytical Skills

Agile Methodologies

Collaboration

Education

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

Associate's in a technical field

High school diploma

Tools

SQL Server

Oracle Database

ERwin

Visio

Excel

Multi Model Mapper

Jira

Miro

Job description

IT Data Modeler (Finance)

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*

*This range is for this level and may vary based on the actual level of role hired for. It is a national range; the actual salary depends on factors such as scope, complexity, skills, education, training, credentials, location, and experience. Position may be eligible for an annual bonus.

At Erie Insurance, you're part of a Fortune 500 company and a diverse, inclusive team of over 6,000 employees and 13,000 independent agencies. Our employees work at the Home Office in Erie, PA, and in field offices across 12 states and D.C.

Benefits That Go Beyond The Basics

We offer an exceptional benefits package, including:

• Premier health, prescription, dental, and vision benefits for you and your dependents, starting from day one.
• Low contributions to medical premiums, with up to 97% paid by us.
• Traditional pension plan, vested after five years of service.
• 401(k) with up to 4% match, in addition to pension.
• Paid time off including vacation, personal, sick, bereavement, and parental leave.
• Career development opportunities, including tuition reimbursement for higher education and industry designations.

Additional benefits include company-paid life insurance, disability coverage, orthodontics, adoption assistance, fertility coverage, well-being programs, paid volunteer hours, and charitable gift matching.

Position Summary

Independently, with moderate supervision, performs low to medium complexity data analytics tasks, including data analysis, problem solving, data mapping, data modeling, and data governance.

Responsible for data management ensuring accuracy, completeness, and security. Reviews existing data models, creates conceptual, logical, and physical master data models, and collaborates with stakeholders to review and evolve data models.

What You'll Do

This role focuses on data needs in the Commercial IT department. You will collaborate with project teams to understand data requirements, create data models, and ensure alignment with business and technical needs across Scrum teams.

Preferred Experience & Skills

• Conceptual, Logical, and Physical data modeling experience
• IBM IAA experience
• Commercial Insurance experience
• Business Analysis and Requirements gathering
• SQL Server and Oracle database experience
• DDL generation and maintenance
• Tools familiarity: Multi Model Mapper, ERwin, Visio, Excel, Enterprise Business Agility Training

What Makes You Stand Out

• Experience working on Agile teams
• Data tools expertise
• Jira and Miro experience

Duties and Responsibilities

• Create efficient, technology-agnostic conceptual and logical data models for relational and dimensional systems.
• Define data attributes and definitions based on business requirements or metadata.
• Develop physical data models optimized for technologies like NoSQL and RDBMS in collaboration with database engineers.
• Maintain review channels with stakeholders and team members for data models.

These duties are essential functions for the role, with additional duties performed as needed.

Employees must follow other instructions and perform duties as assigned by their supervisor.

Capabilities

• Collaboration, Innovation, Customer Focus, Decision Quality, Accountability, Trust, Learning, Process Optimization, Self-Development, Diversity Valuation

Qualifications

Minimum Educational and Experience Requirements

• Bachelor's in IT, MIS, Business, or related field + 2 years' experience
• Associate's in a technical field + 4 years' experience
• High school diploma + 6 years' experience

Additional Skills

• Accountability, Adaptability, Agile, Analytical Skills, Data Governance, Data Modeling, SQL, Troubleshooting, and relevant data tools expertise

Physical Requirements

• Ability to lift over 50 lbs rarely, access heights rarely, drive occasionally, lift 0-20 lbs frequently, lift 20-50 lbs rarely, perform data entry frequently, and move objects rarely.

Nearest Major Market: Erie