IT Senior Data Management Analyst (Erie, PA, US, 16530)

Erie Insurance Group

full-time

Required skills

AWS
Azure
GCP
Hadoop
NoSQL
SQL
Python
Tableau
Qlik
ETL
Data Lake
Data Warehousing
Metadata Management
Data Governance

About the role

Division or Field Office:	Office of the CIO
Department of Position:	Enterprise Tech Office Dept
Work from:	Corproate Office, Erie PA
Salary Range:	$86,954.00 - $138,899.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

With limited supervision, leads the data management, storage and utilization of structured and unstructured data from internal and external sources of moderate to high complexity.Responsible for performing general analytics and knowledge on statistical modeling on existing data sets in various areas of the business (e.g., Market Economics, Supply Chain, Marketing/Advertising, Financial Services, Scientific Research, etc.). Activities include: defining data requirements (may involve writing Pseudo code), data collection, processing, cleaning, analysis, data integration, interpreting the data modeling and creating the visualizations. Examines and identifies data patterns and trends to help answer business questions and improve decision making. Provides inputs for complex Data Science, Big Data Mining projects and data governance teams. Identifies areas to increase efficiency and automation of data analysis processes.

What You'll Do:

We are seeking a detail-oriented and technically skilled Data Management Analyst to join our dynamic AI Center of Excellence (CoE) within the IT department. This role will play a critical part in driving our AI initiatives by ensuring high-quality, accessible, and well-governed data. You will collaborate with data scientists, engineers, and business stakeholders to support data lifecycle management, data quality, metadata curation, and data compliance processes.

Preferred Experience & Skills:

Experience supporting AI/ML or advanced analytics projects.
Knowledge of cloud data platforms (e.g., AWS, Azure, GCP) and modern data architectures (e.g., data lakes, lakehouses).
Exposure to data privacy frameworks, compliance, security, and regulatory standards (e.g., GDPR, HIPAA) relevant to enterprise AI applications.

Why Join Us?

Be at the forefront of AI innovation within a growing IT organization.
Contribute to impactful, enterprise-scale AI initiatives that drive business value.
Collaborative and inclusive team environment with opportunities for professional growth and learning.

Duties and Responsibilities

Serves as lead within a project team. Leads large work efforts within a portfolio. Leads the creation of data requirements, data quality, code/decode process, reporting and analytical tools and technologies.
Performs moderate to high complexity tasks involving data strategy, data naming standards, best practices, and domain & enterprise models.
Elicits and analyzes business requirements from stakeholders or business analysts and translates as data requirements consumable for programmers and developers.
Creates data requirements with clear, unambiguous data mapping documentation with source, target, and transformation/translation rules for various use cases such as data migration and integration services mapping.
Collaborates with vendor partners to ensure consistency and quality of deliverables across the enterprise.
Collaborates with other analysts to mature the data analyst practice.
Reviews deliverables of other staff.

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

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, and five years’ related experience; or
Associate degree in a technical field, and seven years' related experience; or
High school diploma and nine years' related experience required.

Additional Experience

Experience in data analysis/modeling applications and programs and relational technologies required. (Examples: Qlik, Excel, SAAS, NoSQL technologies such as MarkLogic, AWS Redshift, relational technologies such as Oracle, SQL, OLAP, OLTP)
Skills & Tools: Amazon Web Services, Apache Hadoop, Automation, Business Intelligence, (Familiarity with the following as concepts: Conceptual Data Modeling, Logical Data Models ,Data Architecture, Data Governance, Dimensional Modeling, Data Warehousing), Data Lakes, Data Profiling, Data Visualization, Extract Transform Load (ETL), Machine Learning, Metadata Management, Microsoft Azure, NoSQL, Python (Programming Language), Relational Databases, Familiarity with Software Engineering, SQL (Programming Language), Qlik, Tableau (Business Intelligence Software), Troubleshooting (Problem Solving), APIs, Knowledge on Data Formats such as XML, JSON, Parquet etc., UML tools.

Physical Requirements

Ability to move over 50 lbs using lifting aide equipment; Rarely
Climbing/accessing heights; Rarely
Driving; Occasional (<20%)
Lifting/Moving 0-20 lbs; Occasional (<20%)
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

About Erie Insurance Group

Provides property, casualty, and life insurance services.

This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.