Snowflake Engineer (Python / Snowpark)

Nationwide•Columbus, OH

5d•$118,000 - $178,000•Hybrid

About The Position

Join Nationwide’s Finance & Investments Technology BSA, which delivers technology solutions supporting finance and investment operations. The Snowflake Engineer will help shape enterprise-wide engineering standards, build reusable capabilities used by multiple teams, and work with cloud and data technologies in partnership with architecture, security, governance, and product leaders. The role focuses on designing and implementing enterprise-scale Snowflake data warehousing and cloud integration strategies; establishing standards for ingestion, transformation, orchestration, and performance tuning; and building scalable ELT pipelines with Snowflake features such as Snowpipe, Streams, Tasks, and Snowpark. The engineer will also use data modeling approaches and dbt, optimize query performance and compute costs, and integrate orchestration tools such as Apache Airflow or Prefect. As a Data Engineer, the role also involves acquiring, curating, and publishing ready-to-use data for analytical and operational uses across business users, data scientists, and Technology. Work spans the software development lifecycle, including requirements translation, design, development, testing, deployment, and production maintenance. The role supports real-time and batch data processes and may involve structured, unstructured, and other data technologies. The position follows a hybrid schedule, requiring in-office presence in Nationwide’s Columbus, Ohio office two days per week. Candidates must live within commuting distance. This role does not qualify for employer-sponsored work authorization, and Nationwide does not participate in the STEM OPT Extension program.

Requirements

Certified Snowflake Engineer focused specifically on Snowflake architecture and implementation.
Advanced SQL and Python skills, including PySpark or Snowpark.
Experience with modern transformation tooling such as dbt.
Deep knowledge of Snowflake RBAC, zero-copy cloning, time travel, and performance tuning.
Six to ten years of relevant experience with data quality rules and data management organization, standards, and practices.
Solid software development experience on large and/or concurrent projects.
Experience in data warehousing, statistical analysis, data models, and queries.
Advanced skills with modern programming and scripting languages such as SQL, R, Python, Spark, UNIX Shell scripting, Perl, or Ruby.
Strong problem-solving, verbal communication, and written communication skills.
Ability to influence, build relationships, negotiate, and present to senior leaders.
Candidates must be based within commuting distance of Columbus, Ohio.
Must not require employer-sponsored work authorization; the role is not eligible for STEM OPT Extension.

Nice To Haves

Undergraduate studies in computer science, management information systems, business, statistics, math, a related field, or comparable experience and education.
Graduate studies in business, statistics, math, computer science, or a related field.
Certifications are encouraged but not required.
One to three years of experience developing compelling stories and distinctive visualizations.
Insurance or financial services industry knowledge.
Experience with cloud technologies such as Azure and AWS, including Redshift, S3, and EC2.
Experience with CI/CD practices and tools such as JIRA, Jenkins, and Confluence.
Experience with orchestration tools such as Apache Airflow or Prefect.

Responsibilities

Lead the design of enterprise-scale data warehousing and cloud integration strategies on Snowflake.
Establish standards for data ingestion, transformation, orchestration, and continuous performance tuning.
Build scalable ELT pipelines using Snowflake features such as Snowpipe, Streams, Tasks, and Snowpark.
Implement data modeling frameworks, including dimensional, Data Vault, or hybrid schemas, using tools such as dbt.
Optimize query performance and manage warehouse compute costs through clustering, caching, and sizing.
Integrate orchestration tools such as Apache Airflow or Prefect to manage dependency graphs and scheduling.
Analyze data product requirements and business processes to lead the design, development, and implementation of data products.
Produce data building blocks, models, and flows for dimensional data, reporting, data feeds, dashboards, and data science research.
Translate business data stories into technical work breakdowns and estimates.
Apply secure software and systems engineering practices throughout delivery.
Create business-user access methods for structured and unstructured data, including data mapping, transformation, NLP, AI, statistical computations, and content validation.
Build data cleansing, imputation, standardization, profiling, source-change monitoring, extraction, ingestion, and curation routines.
Facilitate medium- to large-scale data engineering using cloud technologies such as Azure and AWS, including Redshift, S3, and EC2.
Collaborate with enterprise DevSecOps and other organizations on CI/CD practices and tools such as JIRA, Jenkins, and Confluence.
Implement production monitoring for data quality and the accuracy and availability of production data.
Develop and maintain scalable streaming and batch data pipelines and API integrations.
Write and perform data unit and integration tests; create test data, validation scripts, automated testing programs, and reusable test data.
Practice code management and integration using Git principles and repositories.
Participate as an expert, leader, and learner in data analysis, architecture, application design, coding, and testing.
Lead design decisions for complex data pipelines, integration patterns, and reusable engineering components.
Perform other responsibilities as assigned.

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