(Project Staff) Consultant, Data Engineer


Job Overview

As a team member in the Finance and Internal Audit department at Nationwide, the opportunities are endless! You can grow and learn in diverse areas across many disciplines such as Advanced Analytics, Investments, Actuarial, Accounting, Risk Management, Critical Business Advisor and so much more. Let Nationwide help create your career journey!As a Lead Data Engineer in the Property & Casualty data analytics team at Nationwide, you will be working with product manager and product owners to design, implement and scale data pipelines that transform data into actionable information and enables decision making. This role will be focused on supporting E&S (Excess & Surplus ) Specialty line of business in partnership with advanced analytics team to design and build data pipelines based on business requirements.Ideal candidates will have the following skills:* Experience programming in Python, Spark SQL, Dataframes and PySpark* Experience with Spark architecture, big data concepts and building data lakes* Experience with AWS S3, Glue, Kinesis or Kafka, EMR and familiar with Parquet and delta formats* Experience with Databricks and Delta Lake* Automate code deployment and promotion* Diagnose and resolve technical issues or defects* Design experience using best practices in building a data pipeline* Experience in scrum team and working from business stories to task out and estimate work effort* Experience leading a team of data engineers and provide mentorship* Strong communication skills both verbal and written* P&C Insurance and claims industry experienceCompensation Grade: G0Job Description SummaryJOB SUMMARY: A staff resource assigned to perform a specific activity in support of an approved corporate program or project for a limited period of time. The hiring manager will create job expectations for each project position.Job DescriptionRELATIONSHIP: Reporting relationships will be determined based on the needs of the assigned project.AN EXPLANATION OF PROJECT STAFFING:STAFFING: A “project basis staffing” is a job temporarily assigned in order to perform a specific activity in support of an approved corporate project. The assignment is typically two years or less. The limited life of this assignment distinguishes a “project” position from most other positions. Project staffing allows management a greater level of flexibility in selecting an incumbent with the needed level of expertise. Because of the truly temporary status of the project job, the need for specific skills, and a fair administration of compensation for project personnel, the project jobs are to be staffed on a lateral basis (i.e. the incumbent remains on the same pay band he/she held before project participation).LENGTH OF ASSIGNMENT: The assignment is typically two years or less. However there are two types of project staffing assignments. A short-term assignment would normally be four months or less and would not involve a permanent transfer. Salary would be administered as normal, and the previous position would typically be held open. A long term project assignment would be longer than four months, could involve relocation, and the employee’s previous position would be re-staffed or eliminated. Qualified associates will typically be provided 60 calendar days to search for a new position. For clarification, contact your local HR representative.SALARY ADMINISTRATION: Individuals hired would typically receive a pro-rated merit increase. During the project, merit salary adjustments pursuant to the salary administration guidelines will be based on the employee’s pay band at the time of placement on the project job. Performance evaluations will be conducted as they would on any job as appropriate.END OF PROJECT: Prior to the end of the project, Human Resources will be notified by the Project Executive regarding the project completion date. Human Resources will assist the project job holder for a period of sixty calendar days, if qualified, in his/her search for a position . The success of the associate in securing a position is contingent upon prior related work experience, satisfactory performance on the project and the availability of open positions matching the associates? skills and experience. The associate is expected to compete for positions with other Nationwide associates and/or external applicants. There is no guarantee that the associate leaving the project will secure another position.JOB REQUIREMENTS:Vary based on project needs. Please refer to the On-Line Requisition System for a summary skills listing; the Project Executive can provide a detailed listing.Values: Regularly and consistently demonstrates the Nationwide Values and Guiding Behaviors.JOB CONDITIONS:Overtime Eligibility: Not Eligible (Exempt).Working Conditions: Normal office environment.ADA: The above statements cover what are generally believed to be principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties.Credit Check: AS APPLICABLE TO THE SPECIFIC PROJECT – Due to the fiduciary accountabilities within this job, a valid credit check and/or background check will be required as part of the selection process.

View More
Job Detail
Shortlist Never pay anyone for job application test or interview.