Data Engineer

Burtch Works; Cincinnati (OH); Hybrid; USD 95,000 - 120,000; Full time

Job summary

Burtch Works is seeking a Data Engineer to partner with our Data and Systems teams in Cincinnati, OH. This contract-to-hire role focuses on building and maintaining data pipelines, transforming data, and automating distribution across departments.

The ideal candidate will bring 2+ years of experience, strong SQL and Python (PySpark) skills, and hands-on cloud experience (Azure, AWS, GCP). Experience with Airflow, Dagster, or Prefect is a plus.

Qualifications

• Bachelor's degree or equivalent in a computational science or technical field.
• 2+ years of professional experience in data engineering or related role.
• Proficiency in SQL, query optimization, and indexing strategies.
• Strong Python skills for data processing (PySpark).
• Familiarity with DevOps practices, Git integrations, and CI/CD.
• Experience with cloud-native tools and technologies (Azure, GCP, AWS).
• Experience building, optimizing, and maintaining ETL/ELT pipelines.
• Basic infrastructure-as-code experience (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.

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 to automate data distribution.
• System Management (15%): Monitor and troubleshoot existing data systems to ensure reliability for analysts.
• Collaboration & Process (5%): Participate in code reviews and improve workflows to support team knowledge sharing.
• Other (5%): Other duties as assigned.

Skills

SQL

Python

PySpark

CI/CD

Git integrations

DevOps

Data pipelines

Data modeling

Education

Bachelor's degree or equivalent in computational science or technical field

Tools

Airflow

Dagster

Prefect

Terraform

CloudFormation

Azure

AWS

GCP

Kafka

Kinesis

Job description

Job Summary

The Data Engineer will work closely with the Data team and the Systems team to maintain, enhance, and extend our client\'s 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.

Job Title: Data Engineer

Location: Cincinnati, OH (hybrid)

Employment Type: Contract-to-hire

Key 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.

Required Qualifications

• Bachelor\'s degree or equivalent experience in a computational science or technical field
• 2+ years of professional experience
• Proficiency in SQL, query optimization, and indexing strategies
• Strong Python skills for data processing (PySpark)
• Familiarity with DevOps practices, Git integrations, and CI/CD (Azure DevOps)
• Experience with cloud-native tools and technologies (Azure, GCP, AWS)
• Experience building, optimizing, and maintaining ETL/ELT pipelines
• Basic infrastructure-as-code experience (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