Hiring: Consultant, Data Engineer | Snowflake Data Engineer (Python / Snowpark) Company: Nationwide Location: Columbus, OH Job Posted Time: 2026-09-11 13:46:59 Employment Type: Hybrid Target Skills & Keywords : AWS, Agile, Airflow, Azure, CI/CD, Confluence, Data Pipeline, Databricks, EC2, ELT, GCP, Git, Iceberg, Jenkins, Jira, Machine Learning, NLP, Perl, Prefect, PySpark, Python, R, RBAC, Redshift, Ruby, S3, SQL, Shell, Snowflake, Spark, Systems Engineering, Vault, dbt About the job Experience: •: Data application and practices knowledge. Advanced skills with modern programming and scripting languages (e.g., SQL, R, Python, Spark, UNIX Shell scripting, Perl, or Ruby). Strong problem-solving, verbal and written communication skills. Ability to influence, build relationships, negotiate and present to senior leaders. •Other criteria, including leadership skills, competencies and experiences may take precedence. •Staffing exceptions to the above must be approved by the hiring manager’s leader and HR Business Partner. •Regularly and consistently demonstrates the Nationwide Values. Required Skills: •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. •Technical Stack: Advanced SQL, Python (including PySpark or Snowpark), and modern transformation tooling like dbt. Qualifications: •: Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred. Graduate studies in business, statistics, math, computer science or a related field are a plus. •Certifications are not required but encouraged. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!