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 (Millcreek, Erie, PA) |
| Salary Range: |
$76,115.00 - $121,586.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
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 being reposted.**
Designs, constructs, tests, and maintains data management systems of moderate complexity 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.
- This position is based in-person out of our Westport Office in Millcreek (Erie, PA)
- The hiring team will consider candidates for 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 date 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 deliver 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: AWS Glue, Informatica ETL, Python, SQL
- Data Storage: Glacier, S3, Redshift, Snowflake
- Data Processing: Athena, Snowflake, Python
- Data Analysis & Visualization: SAS, QLIK
- Familiarity with:
- 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 set processes of moderate complexity to prepare data for analysis, predictive modeling, and research.
- Develops moderately 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.
- 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.
Competencies
- Customer Focus
- Nimble Learning
- Values Diversity
- Collaborates
- Cultivates Innovation
- Decision Quality
- Ensures Accountability
- Instills Trust
- Optimizes Work Processes
- Self-Development
Qualifications
Minimum Educational and Experience Requirements
- Master’s degree in Computer Science, Mathematics, or related field plus one year related experience; or
- Bachelor’s degree in Computer Science, Mathematics, or related field plus two years’ related experience; or
- Associate’s degree in technical field, plus four years’ related experience; or
- High school diploma plus six 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