Senior Data Engineer

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

At Casey's, every event generates data: a pizza delivery, filling up a gas tank, a truck pulling into the lot, pouring a cup of coffee. Our mission is to use that data to generate insights and help solve the organization's biggest challenges. Our team partners with departments across Casey's to make sense of data and provide direction to decision makers. To enable our strategy, we utilize cutting edge technology tools for data collection, transformation, and analysis. Are you driven to wrangle, cleanse, and transform data? Do you want to partner with leaders to make data-driven decisions? Does diving into a wide variety of data to extract insights excite you? We're looking for innovators who can take an idea from the whiteboard to the boardroom. If that's you, let's talk.

The Senior Data Engineer role will be responsible for developing data ingestion and transformation frameworks, data modeling for analytics, developing data pipelines, CI/CD, data platform performance/cost optimization, and helping enhance our data platform architecture. This is a collaborative role, where you will work closely with other members of the Data Engineering, Analytics, and Technology teams to solve challenging data problems with cloud technology.

The primary technologies utilized in this role include: Databricks (Python, PySpark, SQL) and Anomalo.

Key Responsibilities:

• Leads complex data engineering initiatives, actively participating in requirements gathering and continuously 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.

Compensation:

Starting pay range: $102,200-140,500. Actual pay may vary based on Casey’s assessment of the candidate's knowledge, skills, abilities (KSAs), related experience, education, and qualifications. Other factors impacting pay include local prevailing wages and internal equity. This position is eligible for an annual cash bonus based on company performance. Our full salary range for this role does extend beyond the typical hiring range listed, allowing team members the opportunity to continue to grow within the company.

• This positionrequires authorization to work in the U.S. without the need for employment-based immigration sponsorship now or in the future.Casey’s will not provide sponsorship or employer supportfor applications or petitions for F-1 OPT, F-1 CPT, H-1B, L-1, TN, O-1, E-3, H-1B1, J-1, or any other employment-based visa.
• Bachelor's degree in Computer Science, Data Analytics, Engineering, Information Technology, or equivalent years of related work experience.
• At least five (5) years of experience designing and developing enterprise data solutions and integrations, ETL, data warehousing, data modeling (star schema, etc.).
• Strong proficiency in Python, PySpark and SQL.
• Experience with Databricks, Snowflake, or other modern data platform.
• Comfort with a variety of data sources including APIs, streams, events, databases, files, etc.
• Hands-on experience with Azure, including ADLS Gen2, Data Factory, Key Vault, and Function Apps (or other equivalent cloud technology).
• Experience implementing CI/CD and automated testing for a data team.
• Familiarity with data governance concepts: data cataloging, tagging, handling sensitive data.
• Prior experience in Software Engineering is a plus.

This roledoes notallow for 100% remote work.Qualified candidates must live within a daily commutable distance of Casey's Store Support Center in Ankeny, IA and be willing to workonsite5 days per week.