Consultant, Data Engineer
About The Position
The Consultant, Data Engineer will design, develop, test, and implement scalable ETL/ELT data integration pipelines to acquire and centralize diverse, high-volume datasets from multiple source systems into cloud data warehouses and data marts. The role uses 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 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 proof-of-concept evaluations of emerging data tools, frameworks, and cloud technologies to assess feasibility and support platform modernization. The role regularly and consistently demonstrates Nationwide Values. The work environment is hybrid in a normal office environment. The position is exempt and not eligible for overtime.
Requirements
- Master’s degree in Computer Science.
- Three years of experience performing the duties listed in the job description.
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 proof-of-concept evaluations of emerging data tools, frameworks, and cloud technologies to assess feasibility and support 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, with newly hired associates receiving a minimum of 18 days per full calendar year, 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
