Flag job

Report

Specialist, Data Engineer (Annuity Data Platform)

Salary

$93.5k - $139.5k

Min Experience

3 years

Location

Columbus OH, Des Moines IA, Scottsdale AZ, remote

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

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. Role can be filled in Columbus, Ohio, Des Moines, Iowa, Scottsdale, Arizona and current remote associates will also be considered. This role would work a hybrid schedule coming into the office 2 days per week (Wednesdays & Thursdays). This role is to work on the Annuity Data Platform build out as part of the Annuity Modernization Program. Key Responsibilities: Design, develop, and maintain ETL pipelines using Talend for large-scale data integration projects. Optimize complex SQL queries to extract, transform, and load data across various RDBMS platforms (e.g., Oracle, SQL Server, PostgreSQL, Snowflake). Collaborate with data architects and analysts to translate business requirements into scalable data solutions. Implement and monitor job schedules, handling job failures with appropriate recovery strategies. Participate in peer code reviews to ensure adherence to development best practices and coding standards. Required Technical Skills: Hands-on experience with ETL tools such as Talend (Open Studio/Cloud). Strong proficiency in SQL, including stored procedures, indexing, and query optimization. Experience with relational database platforms such as Oracle, SQL Server, PostgreSQL, and Snowflake. Exposure to job orchestration/scheduling tools like Control-M, Apache Airflow, or equivalent. Experience working in cloud environments (e.g., AWS, Azure). Experience with app containerization using Kubernetes. Familiarity with data modeling concepts, both logical and physical. Preferred Skills: Familiarity with data warehousing concepts and dimensional modeling. Knowledge of Python or Shell scripting for automation and auxiliary data tasks. Applying GenAI tools for rapid development and/or analysis. Compensation Grade: F5

About the company

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.

Skills

talend
sql
oracle
sql server
postgresql
snowflake
control-m
apache airflow
aws
azure
kubernetes
data modeling