IT Senior Data Management Analyst

Erie Insurance•Erie, PA

33d•Onsite

About The Position

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. This role will play a critical part in driving 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.

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.
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, 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.

Nice To Haves

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.

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.

Benefits

Premier health, prescription, dental, and vision benefits for you and your dependents.
Low contributions to medical and prescription premiums.
Pension.
401(k) with up to 4% contribution match.
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.
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.
Dollar-for-dollar matching of your charitable gifts each year.