Software Engineer (Data- AWS/Snowflake) - Erie Insurance

Division or Field Office:

Corporate Enablement Technology Division
Department of Position: Data Technology Department
Work from:
Corporate Office in Erie, Pa Salary Range:
$76,115.00-$121,586.00*

salary range is for thislevel 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

Translates and develops requirements into workable software solutions. Maintains and develops programs for use in business and IT automation. Incorporates various accepted methodologies to design software and applications at a critical level to project or release. May perform duties in one or more of the following disciplines: Open Systems, Mainframe, Application, Configuration

What You'll Do:

The Data portfolio islooking for a talented and motivated Software Engineer specializing in data engineering, ETL, and AWS cloud technologies. This role will involve the design, implementation, and optimization of data pipelines, data lakes, and data warehouse solutions. You will be responsible for working across various AWS services, ensuring the seamless extraction, transformation, and loading of data, while maintaining best practices in data management and cloud solutions.

• Develop, deploy, and maintain ETL pipelines using AWS services such as Glue, Lambda, and Step Functions
• Implement data partitioning and manage Parquet file formats for optimized data storage and retrieval.
• Design, build, and manage data lakes and data warehouses using AWS S3, Redshift, and Snowflake.
• Perform data transformations using PySpark and AWS Glue.
• Integrate various AWS services like DynamoDB, RDS, SNS, and EventBridge for building data solutions.
• Ensure high availability and performance of data solutions using Redshift Spectrum and Athena.
• Work with Kafka for real-time data streaming and processing.
• Use API Gateway for managing APIs related to data integrations.
• Collaborate with cross-functional teams to define technical requirements and provide data-driven solutions.

What Makes You Stand Out:

• 3-5 yearsof experience in software engineering and data engineering.
• Proficiency with AWS services: S3, Redshift, Lambda, Glue, Step Functions, Athena, DynamoDB, RDS, EventBridge, SNS, and API Gateway.
• Strong experience in ETL conceptsand tools, particularly AWS Glue and Informatica.
• Hands-on experience with PySparkand data partitioningusing Parquet files.
• Familiarity with Kafkafor data streaming.
• Experience with data warehouseand data lakeconcepts.
• Proficiency in SQLand working with databases such as Redshift, Snowflake, and RDS.
• Basic understanding of Dockerfor containerization and Terraformfor infrastructure as code (IaC).
• Experience using version control tools like Git.
• Strong problem-solving skills and the ability to work in an agile environment.

Preferred Qualifications:

• Experience with Snowflakefor data warehousing.
• Knowledge of Redshift Spectrumand Athenafor querying large datasets.
• Understanding of DevOpspractices and CI/CD pipelines.

Duties and Responsibilities

• Develops program logic for new, complex applications or analyzes and modifies logic in existing complex applications. Accurately delivers complicated code, configuration changes and enhancements.
• Contributes to releases with high quality code and unit tests, having challenges in complexity or deadlines. Implements and verifies a complete unit test.
• Contributes to design documents.
• Improves stability of platforms, applications, services and systems.
• Effectively communicates with customers, teammates or other stakeholders, and may function as lead or point of contact. Shares knowledge of systems and mentors or trains others.
• Develops and manages relationships with diverse groups of stakeholders at multiple levels.

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

Competencies

• Self-Development
• Collaborates
• Cultivates Innovation
• Instills Trust
• Decision Quality
• Values Diversity
• Nimble Learning
• Customer Focus
• Optimizes Work Processes
• Ensures Accountability
• Coding And Converting
• Information Management Skills
• Job-Specific Knowledge
• Proofing Text And Numbers
• Using Tables And Graphs

Qualifications

• Bachelor's degree in IT, MIS, Business or related field, plus five years' related experience, or;
• Associate's degree in a technical field, plus seven years' related experience, or;
• High School Diploma plus nine years' related experience

Physical Requirements

• 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
• Driving; Occasional (<20>
• Pushing/Pulling/moving objects, equipment with wheels; Rarely
• Manual Keying/Data Entry/inputting information/computer use; Frequent (50-80%)
• Climbing/accessing heights; Rarely

Nearest Major Market: Erie