Consultant, Data Engineer
About The Position
Nationwide is seeking a Consultant, Data Engineer to design, develop, test, and implement scalable ETL/ELT data integration pipelines. The role acquires and centralizes diverse, high-volume data from multiple source systems into cloud data warehouses and data marts, using Snowflake and AWS to store, process, and optimize large-scale analytical computations and complex data assets. The position performs logical and physical dimensional data modeling, data profiling, and data quality analysis to architect target database schemas, including Star and Snowflake schemas, and to define data load strategies. It also develops automated workflows, system alerts, and scripting solutions; architects and implements CI/CD pipelines using enterprise automation software and orchestration frameworks; and conducts proofs of concept for emerging data tools, frameworks, and cloud technologies to assess feasibility and support platform modernization. The role is expected to regularly and consistently demonstrate Nationwide Values. The work environment is hybrid in a normal office setting, and the position is exempt from overtime eligibility.
Requirements
- Master’s degree in Computer Science.
- Three years of experience performing the listed duties.
Responsibilities
- Design, develop, test, and implement scalable ETL/ELT data integration pipelines.
- Acquire and centralize diverse, high-volume datasets from multiple source systems into cloud data warehouses and data marts.
- Use Snowflake and AWS to store, process, and optimize large-scale analytical computations and complex data assets.
- Perform logical and physical dimensional data modeling, data profiling, and data quality analysis.
- Architect target database schemas, including Star and Snowflake schemas, and define data load strategies.
- Develop automated workflows, system alerts, and scripting solutions.
- Architect and implement CI/CD pipelines using enterprise automation software and orchestration frameworks.
- Conduct proofs of concept on emerging data tools, frameworks, and cloud technologies to assess feasibility and drive platform modernization.
- Regularly and consistently demonstrate Nationwide Values.
Benefits
- Medical, dental, and vision coverage
- Life insurance
- Short- and long-term disability coverage
- Paid time off, including a minimum of 18 days per full calendar year for newly hired associates, prorated quarterly based on hire date
- Nine paid holidays
- Eight hours of Lifetime paid time off
- Eight hours of Unity Day paid time off
- 401(k) with company match
- Company-paid pension plan
- Business casual attire
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
