Position Summary

**This position is being reposted.**

Designs, constructs, tests, and maintains complex data management systems used for reporting, analysis, and research. Supports ERIE's software developers, database architects, analysts, and data scientists on data initiatives and ensures optimal data delivery consistently throughout ongoing projects.

• Please Note: We are only considering US workers for this position. We are unable to offer this position to individuals who will require current or future immigration sponsorship for employment.
• This position is based in-person out of our Westport Office in Erie, PA (Millcreek)
• The hiring team will consider candidates for Associate Data Engineer, Data Engineer, or Senior Data Engineer. Level of position offered will be based upon the depth and breadth of selected candidate's experience and qualifications.
  • 3-4 years of professional experience in the items below highly preferred

What You'll Do:

• Design, develop, and optimize data ingestion, pipelines, and databases following best practices
• Ensure that data is accessible, reliable and optimized for stakeholder analysis and reporting
• Integrate internal and external data sources to centralize repositories
• Design repeatable processes that will cleanse and transform data into useful insights to generate positive business outcomes
• Work on agile delivery teams that release production ready data products for Commercial Lines Product team

What Makes You Stand Out:

• Experience working with property and casualty insurance information
• Experience with the following tools:
  • Ingestion: Python, SQL
  • Data Analysis & Visualization: SAS, QLIK
• Familiarity with:
  • Data processing: Athena, Redshift, Snowflake
  • Data orchestration
  • Star schema
  • Security, Privacy, and regulations
  • Code repositories in Github
  • Data governance including measured data quality, critical data elements, business glossaries, data lineage, etc.
  • Working within an agile framework using JIRA

Duties and Responsibilities

• Identifies, designs, and implements internal process improvements including automating manual data acquisition and optimizing data delivery.
• Integrates new data management technologies into existing data structures.
• Develops complex set processes to prepare data for analysis, predictive modeling, and research.
• Develops complex programs to extract and manipulate analytical and research data. Includes data from both internal and external sources.
• Creates tools for data team members that assist them in research and analysis.
• Works with data and analytics experts to strive for greater functionality in our data systems.
• Collaborates closely with business and IT partners to ensure data management technologies are designed and implemented as intended.
• Assists in training and development of less experienced staff, including those new to role. Serves as a resource to other section Employees and within the data community.
• Completes special projects as required.

The first 4 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

Qualifications

Minimum Educational and Experience Requirements

• Master's degree in Computer Science, Mathematics, or related field plus three years' related experience; or
• Bachelor's degree in Computer Science, Mathematics, or related field plus four years' related experience; or
• Associate's degree in technical field, plus six years' related experience; or
• High school diploma plus eight years' related experience, required.

Physical Requirements