Data Engineer: ETL Pipelines, Snowflake & AWS

NBMBAA; United States; Hybrid; USD 118,000 - 222,000; Full time

Benefits offered by this job

medical/dental/vision

life insurance

short and long term disability

paid time off

nine paid holidays

8 hours of Lifetime paid time off

8 hours of Unity Day paid time off

401(k) with company match

pension plan

business casual attire

Job summary

Nationwide seeks a Software Engineer/Consultant, Data Engineer to design, develop, test, and implement scalable ETL/ELT pipelines, centralizing diverse, high-volume datasets into cloud data warehouses and data marts. You will leverage Snowflake and AWS to store, process, and optimize large-scale analytical computations and data assets.

The role involves data modeling (Star/Snowflake), data quality analysis, and building automated workflows with CI/CD pipelines; POCs on new cloud tools help drive

Qualifications

• Master’s degree in Computer Science with 3+ years of data engineering experience.
• Experience designing scalable ETL/ELT pipelines.
• Proficiency with Snowflake and AWS for data warehousing.

Responsibilities

• Design, develop, test, and implement scalable ETL/ELT pipelines.
• Build and optimize data warehouses and data marts in Snowflake/AWS.
• Create CI/CD pipelines and automation workflows.
• Perform data profiling, quality checks, and data modeling (Star/Snowflake).
• Evaluate new data tools and cloud technologies via POCs.

Skills

ETL/ELT pipelines

Snowflake

AWS

CI/CD

Data modeling

Data quality

Education

Master's degree in Computer Science

Tools

CI/CD tooling

Automation frameworks

Job description

Nationwide seeks a Software Engineer/Consultant, Data Engineer to design, develop, test, and implement scalable ETL/ELT pipelines, centralizing diverse, high-volume datasets into cloud data warehouses and data marts. You will leverage Snowflake and AWS to store, process, and optimize large-scale analytical computations and data assets.

The role involves data modeling (Star/Snowflake), data quality analysis, and building automated workflows with CI/CD pipelines; POCs on new cloud tools help drive