Specialist, Data Engineer

Data Engineer – Etl Developer

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.

We're looking for a motivated Data Engineer – ETL Developer to join the NF Data Warehouse team within Digital Back Office (DBO). This role involves the delivery of data solutions and managing data integration across various Nationwide Financial products. This is a great opportunity to work on impactful data solutions that support a wide range of Nationwide Financial products, including Annuities, Life, Retirement, and Corporate Solutions.

In this role, you'll help drive data integration efforts across platforms, working with a modern Snowflake-based data warehouse. You'll be responsible for acquiring, curating, and publishing data for both analytical and operational use cases, while also helping to shape the future of our data ecosystem.

The ideal candidate will possess the following skills and experience:

• Proficient in SQL.
• Expertise in Snowflake is essential, familiarity with Oracle and SQL Server.
• Strong experience in ETL/ELT processes (Informatica/Talend).
• Solid understanding of data warehousing, data models, queries and batch processing.
• Experience working in Lean, Agile, DevOps, and Cloud hosting environments.
• Excellent collaboration and communication skills.
• Preferred experience in financial data management.

Key responsibilities include:

• Providing technical consultation on data product projects.
• Producing data building blocks, data models, and data flows.
• Applying secure software and systems engineering practices.
• Translating business data stories into technical story breakdown structures.
• Creating business user access methods to structured and unstructured data.
• Assisting the enterprise DevSecOps team and other internal organizations on CI/CD best practices.
• Implementing production processes and systems to monitor data quality.
• Developing and maintaining scalable data pipelines for both streaming and batch requirements.
• Writing and performing data unit/integration tests for data quality.
• Practicing code management and integration with engineering Git principle and practice repositories.

Education: Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred. Graduate studies in business, statistics, math, computer science or a related field are a plus.

Experience: Three to five years of relevant experience with data quality rules, data management organization/standards, practices and software development. Experience in data warehousing, statistical analysis, data models, and queries. One to three years' experience with Cloud technology and infrastructure including security and access management. Insurance/financial services industry knowledge a plus.

Knowledge, abilities and skills: Data application and practices knowledge. Moderate to advanced skills with modern programming and scripting languages (e.g., SQL, R, Python, Spark, UNIX Shell scripting, Perl, or Ruby). Good problem solving, oral and written communication skills.

Values: Regularly and consistently demonstrates the Nationwide Values.

Job Conditions: Overtime Eligibility: Exempt (Not Eligible). Working Conditions: Normal office environment.