Data Pipeline Engineer — Cloud, ETL/ELT & Analytics

Ballpark Operations; Cincinnati (OH); On-site; USD 90,000 - 140,000; Full time

Job summary

The Cincinnati Reds are seeking a Data Engineer to work with the Data and Baseball Systems teams to maintain and extend data pipelines, collect and transform data, and prepare data for distribution to department analysts.

Strong emphasis on building scalable ETL/ELT pipelines, cloud familiarity (Azure/GCP/AWS), and real-time data processing with Kafka/Kinesis; knowledge of Airflow or similar workflows is required. This position is based in Cincinnati, OH and based in the IT/Data organization.

Qualifications

• Bachelor degree or equivalent 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.
• Ability to travel within the United States, preferred, as directed
• Willing to relocate. This position is based in Cincinnati, OH

Responsibilities

• Pipeline Development – 40%: Build, optimize, and maintain ETL/ELT pipelines using Python and SQL to collect and transform data from various sources.
• Data Optimization – 20%: Write efficient SQL queries, implement indexing strategies, and perform performance tuning to ensure fast data retrieval.
• Cloud & Workflow Management – 15%: Utilize cloud-based data tools and workflow orchestration systems (e.g., Airflow) to automate data distribution.
• System Management – 15%: Monitor and troubleshoot existing data systems to ensure reliability for departmental analysts.
• Collaboration & Process – 5%: Participate in code reviews and proactively improve workflows to support team knowledge sharing.
• Other – 5%: Other duties as assigned.

Skills

SQL

Python (PySpark)

DevOps practices

Git CI/CD

Cloud platforms

ETL/ELT pipelines

IaC (Terraform)

Kafka/Kinesis

Airflow/Dagster/Prefect

English fluency

Education

Bachelor degree or equivalent experience in a computational science or technical field

Tools

Azure DevOps

Terraform

CloudFormation

Git

Airflow

Dagster

Prefect

Kafka

Kinesis

Job description

The Cincinnati Reds are seeking a Data Engineer to work with the Data and Baseball Systems teams to maintain and extend data pipelines, collect and transform data, and prepare data for distribution to department analysts.

Strong emphasis on building scalable ETL/ELT pipelines, cloud familiarity (Azure/GCP/AWS), and real-time data processing with Kafka/Kinesis; knowledge of Airflow or similar workflows is required. This position is based in Cincinnati, OH and based in the IT/Data organization.