Data Engineer

The Cincinnati Reds • Cincinnati, OH

9d • Onsite

About The Position

The Data Engineer will work closely with the Data team and the Baseball Systems team to maintain, enhance, and extend the Cincinnati Reds data pipelines. You will be responsible for collecting and transforming data from various sources as well as preparing and distributing data for consumption by the department’s systems and analysts. The ideal candidate is an experienced data pipeline builder who excels at automating and optimizing data systems, with a strong preference for cloud experience.

Requirements

• Bachelor degree or equivalent experience in a computational science or technical field
• 2+ years professional experience
• Proficiency in SQL, query optimization, indexing strategies
• Strong Python for data processing (PySpark)
• Familiarity with DevOps practices, Git integrations, CI/CD (Azure DevOps)
• Experience with cloud-native tools and technologies (Azure, GCP, AWS)
• Building, optimizing, and maintaining ETL/ELT pipelines
• Basic infrastructure-as-code (Terraform, CloudFormation)
• Understanding of real-time data processing (Kafka, Kinesis)
• Experience with workflow orchestration tools (Apache Airflow, Dagster, Prefect)
• Spoken and written fluency in English.

Nice To Haves

• Ability to travel within the United States, preferred, as directed
• Willing to relocate. This position is based in Cincinnati, OH

Responsibilities

• Build, optimize, and maintain ETL/ELT pipelines using Python and SQL to collect and transform data from various sources.
• Write efficient SQL queries, implement indexing strategies, and perform performance tuning to ensure fast data retrieval.
• Utilize cloud-based data tools and workflow orchestration systems (e.g., Airflow) to automate data distribution.
• Monitor and troubleshoot existing data systems to ensure reliability for departmental analysts.
• Participate in code reviews and proactively improve workflows to support team knowledge sharing.
• Other duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level