Sr Analyst, Data Engineer

If you’re passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results, then Nationwide’s Information Technology team could be the place for you! At Nationwide®, “on your side” goes beyond just words. Our customers are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care.

This role does not qualify for employer-sponsored work authorization.  Nationwide does not participate in the Stem OPT Extension program.

This is a junior level data engineer role.

This role will work a hybrid schedule coming into the Columbus, Ohio, Des Moines, Iowa or Scottsdale, Arizona office 2 days per week on Wednesdays and Thursdays.

This role will report to the Manager, Data Leader as part of P&C ADS Data organization.

Team is looking for a junior data engineer that will mature our data pipelines supporting the operational and analytical data needs of P&C Telematics Program. This role is part of a high performing team that is constantly evolving to meet the needs of the P&C ADS Data organization. Candidates should be comfortable with ambiguity and rapidly changing directives. Candidates should possess strong relationship building skills and be able to demonstrate strong delivery through partnerships. Ideal candidate should be:

• Lifelong Learner.

• Passionate about technology and making Nationwide a data driven company.

• Able to learn on the fly and fill knowledge gaps on demand.

• Ability to code while teaching others.

• Derives joy from tackling complex problems and working through solution tradeoffs.

• Able to debug problems to their root cause, especially when the path leads through multiple systems or environments.

• Able to work with streaming datasets at scale.

• Learning how to make the data more valuable for models and customers.

• Desired experience in: AWS, Spark, Databricks, Unity Catalog, UAC, Splunk, Kafka, Kinesis, SQL, Python, Pyspark.

• Familiarity with Rancher, Docker, Harbor, Kubernetes is a plus.

• Familiarity with Scala is a plus.

• Familiarity with Snowflake, Terradata, HBase, Dynamo DB is a plus.

Job Description Summary

Nationwide’s industry leading workforce is passionate about creating data solutions that are secure, reliable and efficient in support of our mission to provide extraordinary care. Nationwide embraces an agile work environment and collaborative culture through the understanding of business processes, relationship entities and requirements using data analysis, quality, visualization, governance, engineering, robotic process automation, and machine learning to produce targeted data solutions. If you have the drive and desire to be part of a future forward data enabled culture, we want to hear from you.

As a Data Engineer you’ll be responsible for acquiring, curating, and publishing data for analytical or operational uses. Data should be in a ready-to-use form that creates a single version of the truth across all data consumers, including business users, data scientists, and Technology. Ready-to-use data can be for both real time and batch data processes and may include unstructured data. Successful data engineers have the skills typically required for the full lifecycle software engineering development from translating requirements into design, development, testing, deployment, and production maintenance tasks. You’ll have the opportunity to work with various technologies from big data, relational and SQL databases, unstructured data technology, and programming languages.

Job Description

Key Responsibilities: 

• Provides technical consultation on data product projects by analyzing end to end data product requirements and existing business processes to assist in the design, development and implementation of data products.

• Translates business data stories into a technical story breakdown structure and work estimate so value and fit for a schedule or sprint is determined.

• Applies secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.

• Develops and maintains scaleable data pipelines for both streaming and batch requirements.

• Assists in building out new API inte