Data Engineer

Cincinnati Reds; Cincinnati (OH); On-site; USD 110,000 - 140,000; Full time

Job summary

The Cincinnati Reds are seeking a Data Engineer to join the Information Technology – Baseball Data & Development team. You will design, build, and maintain data pipelines, collecting and transforming data from multiple sources for use by analysts and systems.

The ideal candidate excels at automating data workflows, has cloud experience (Azure, AWS, GCP), strong Python (PySpark), SQL optimization, and familiarity with ETL/ELT, IaC, and modern workflow tools like Airflow, Dagster, or Prefect.

Qualifications

• Bachelor's degree or equivalent in a computational science or technical field.
• 2+ years of professional data engineering experience.
• Strong SQL skills with query optimization and indexing.
• Python experience for data processing (PySpark).
• Experience with cloud platforms (Azure, AWS, GCP) and ETL/ELT.

Responsibilities

• Pipeline Development – Build, optimize, and maintain ETL/ELT pipelines.
• Data Optimization – Write efficient SQL queries and tuning.
• Cloud & Workflow Management – Use cloud tools and Airflow-based schedulers.
• System Management – Monitor and troubleshoot data systems.
• Collaboration & Process – Participate in code reviews and improve workflows.
• Other – Take on additional duties as needed.

Skills

SQL Proficiency

Query optimization

Indexing strategies

Python (PySpark)

DevOps practices

Git & CI/CD (Azure DevOps)

Cloud platforms (Azure, AWS, GCP)

ETL/ELT pipelines

IaC (Terraform, CloudFormation)

Real-time processing (Kafka, Kinesis)

Workflow orchestration (Airflow, Dagst

Education

Bachelor's degree in computational science or technical field

Tools

Azure DevOps

Terraform

CloudFormation

Kafka

Kinesis

Airflow

Dagster

Prefect

Job description

Data Engineer

Department: Information Technology – Baseball Data & Development
FLSA Status: Full-Time, Salary Exempt

Job Summary

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\u2019s 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

• Education: Bachelor\u2019s degree or equivalent experience in a computational science or technical field
• Experience: 2+ years of professional experience
• Skills: 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)
• Other: 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

Primary Duties & 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

Reports To: Senior Manager, Data Engineer

Next Role to Develop Toward: Senior Data Engineer

Development Requirements:

• Owns small to mid-sized projects with minimal oversight.
• Proactively improves processes and optimizes workflows.
• Contributes to code reviews and knowledge sharing.

Physical Requirements

• Ability to stand and walk for extended periods throughout the day.
• Comfortable working in varying conditions with moderate noise level (confined spaces like office/cubicles).
• Ability to handle repetitive tasks.
• Sufficient hand-eye coordination and manual dexterity for tasks like computer work, note-taking, etc.
• Ability to available for long shifts and to work long and variable hours, including weekends and holidays.

Expectations

• Adhere to Cincinnati Reds Organization Policies and Procedures.
• Act as a role model within and outside the Cincinnati Reds Organization.
• Perform duties as workload necessitates.
• Demonstrate flexible and efficient time management and ability to prioritize workload.
• Meet department productivity standards.
• Willingness to learn. Open to new methodologies

Opportunity Statement

The Cincinnati Reds are an Equal Opportunity Employer. It is the policy of the Cincinnati Reds to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, national origin, religion or creed, sex, age, military or veteran status, disability, citizenship status, marital status, genetic predisposition or carrier status, sexual orientation or any other characteristic protected by law.

Disclaimer: The statements herein are intended to describe the general nature and level of work being performed by the employee in this position. The above description is only a summary of the typical functions of the job, not an exhaustive or comprehensive list of all possible job responsibilities, tasks, and duties. Additional duties, as assigned, may become part of the job function. The duties listed above is, therefore, a partial representation not intended to be an exhaustive list of all responsibilities, duties, and skills required of a person in this position.