Consultant, Data Engineer | Snowflake Data Engineer (Python / Snowpark)

If you’re passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide’s 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. Work Arrangement: This role follows a hybrid schedule and requires in-office presence in our Columbus OH office location two days per week. Candidates must be based within a commutable distance to Columbus, Ohio. Work Authorization: This role does not qualify for employer-sponsored work authorization. Nationwide does not participate in the STEM OPT Extension program. Snowflake Data Engineer (Python / Snowpark)  Join the Finance & Investments Technology BSA, a team focused on delivering innovative technology solutions that support Nationwide's finance and investment operations. This role offers the opportunity to influence enterprise-wide engineering standards, build reusable capabilities leveraged across multiple teams, and work with modern cloud and data technologies while partnering with architecture, security, governance, and product leaders.

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 leveraging native Snowflake features like Snowpipe, Streams, Tasks, and Snowpark. Implement data modeling frameworks (Dimensional, Data Vault, or hybrid schemas) using tools like dbt (data build tool). Optimize query performance and manage warehouse compute costs through effective clustering, caching, and sizing. Integrate orchestration tools (such as Apache Airflow or Prefect) to manage complex dependency graphs and scheduling. Databricks, Apache Spark, PySpark, Apache Iceberg, Unity Catalog, or Snowflake/Databricks interoperability. Required Qualifications & Skills Experience: Strong experience in data engineering focused specifically on Snowflake architecture and implementation. Technical Stack: Advanced SQL, Python (including PySpark or Snowpark), and modern transformation tooling like dbt. Snowflake Expertise: Deep knowledge of Role-Based Access Control (RBAC), zero-copy cloning, time travel, and performance tuning. Cloud Platforms: Hands-on experience within major cloud environments like AWS, Azure, or Google Cloud Platform (GCP). #LI-KR1 Job Description Summary Nationwide’s industry-leading workforce is passionate about creating data solutions that are secure, reliable and efficient in support of our mission to provide extraordinary care. Nationwide embraces an agile work environment and collaborative culture through the understanding of business processes, relationship entities and requirements using data analysis, quality, visualization, governance, engineering, AI engineering, and machine learning to produce targeted data solutions. If you have the drive and desire to be part of a future-forward data-enabled culture, we want to hear from you! As a Data Engineer, you’ll be responsible for acquiring, curating, and publishing data for analytical or operational uses. Data should be in a ready-to-use form that creates a single version of the truth across all data consumers, including business users, data scientists, and Technology. Ready-to-use data can be for both real-time and batch data processes and may include unstructured data. Successful data engineers have the skills typically required for the full lifecycle of software engineering development from translating requirements into design, development, testing, deployment, and production maintenance tasks. You’ll have the opportunity to work with various technologies including big data,