Report

Senior Data Engineer (Erie, PA, US, 16506)

Salary

$97k - $155k

Min Experience

3 years

Location

Erie, Pennsylvania, United States

JobType

full-time

About the job

Info This job is sourced from a job board

Overview

About the role

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.

Division or Field Office:	Commercial Products & Services Division
Department of Position:	Commercial Products Data Dept
Work from:	Westport Office in Erie, PA (Millcreek)
Salary Range:	$97,388.00 - $155,567.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

**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

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

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

Climbing/accessing heights; Rarely
Driving; Occasional (<20%)
Lifting/Moving 0-20 lbs; Occasional (<20%)
Lifting/Moving 20-50 lbs; Occasional (<20%)
Ability to move over 50 lbs using lifting aide equipment; Rarely
Manual Keying/Data Entry/inputting information/computer use; Frequent (50-80%)
Pushing/Pulling/moving objects, equipment with wheels; Rarely

About the company

Erie Insurance Group, based in Erie, Pennsylvania, is a property and casualty insurance company offering auto, home, business and life insurance through a network of independent insurance agents. , Erie Insurance Group is ranked 347th on the 2021 Fortune 500 list of largest American corporations, based on total revenue for the 2020 fiscal year.

Skills

Python

SQL

SAS

QLIK

Athena

Redshift

Snowflake

GitHub

Jira