Senior Data Engineer — Onsite Data Pipelines & AI

caseysstoresupportcenter; Iowa (LA); On-site; USD 102,000 - 141,000; Full time

Job summary

Casey’s Store Support Center in Ankeny, IA is hiring a Senior Data Engineer to build data ingestion and transformation frameworks, model data for analytics, and optimize the data platform. You will work with Data Engineering, Analytics, and Technology teams to solve complex data problems using cloud tech.

The role requires 5+ years in enterprise data solutions, strong Python/PySpark/SQL skills, and experience with Databricks or Snowflake.

Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Engineering, Information Technology, or equivalent years of related work experience.
• 5+ years of experience designing and developing enterprise data solutions and integrations, ETL, data warehousing, and data modeling (star schema, etc.).
• Strong proficiency in Python, PySpark and SQL; experience with Databricks, Snowflake, or other modern data platform.

Responsibilities

• Leads complex data engineering initiatives, actively participating in requirements gathering and refining technical solutions as business needs evolve.
• Mentors other engineers on software/data engineering best practices, data modeling, and pipeline development.
• Experience using AI to accelerate data engineering practices and enforce standards.
• Performs thorough testing of data pipelines and data models to ensure data is accurate and pipelines are resilient and self-healing.
• Evaluates source data systems and understands how to extract and model data for analytics and operational use cases.
• Ingests data from API, streaming, event, and batch source systems.
• Evaluates the technology landscape and makes recommendations for continuous improvement of the data platform.
• Provides support for the data platform as part of an on-call rotation.
• Builds, maintains, and troubleshoots CI/CD pipelines in GitHub.
• Acts as the primary point of escalation for the Data Engineering team to troubleshoot data and platform issues.

Skills

Python

PySpark

SQL

AI in data engineering

Data modeling

Education

Bachelor's degree in Computer Science, Data Analytics, Engineering, Information Technology, or equivalent years of related work experience

Tools

Databricks

Snowflake

Azure

Data Factory

Key Vault

ADLS Gen2

Function Apps

Job description

Casey’s Store Support Center in Ankeny, IA is hiring a Senior Data Engineer to build data ingestion and transformation frameworks, model data for analytics, and optimize the data platform. You will work with Data Engineering, Analytics, and Technology teams to solve complex data problems using cloud tech.

The role requires 5+ years in enterprise data solutions, strong Python/PySpark/SQL skills, and experience with Databricks or Snowflake.