On-Site Data Engineer: ETL & Cloud Pipelines

Think Consulting; Cincinnati (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

Think Consulting is seeking a Data Engineer in Cincinnati, OH to join the Data & Systems team. You will build, optimize, and extend data pipelines, transforming data from multiple sources and preparing data for use by analysts.

Strong cloud experience preferred and hands-on pipeline development is required. Responsibilities include ETL/ELT pipeline construction, SQL optimization, and using Airflow or similar tools to automate data distribution.

Qualifications

• %2B years of professional experience in data engineering.
• Bachelor's degree or equivalent in computational science or technical field.
• Hands-on experience building data pipelines and automating data workflows.

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.

Skills

SQL optimization

Python (PySpark)

DevOps

Cloud (Azure/GCP/AWS)

ETL/ELT pipelines

Infrastructure as code

Real-time data processing

Workflow orchestration

Education

Bachelor's degree

Tools

Apache Airflow

Dagster

Prefect

Terraform

CloudFormation

Job description

Think Consulting is seeking a Data Engineer in Cincinnati, OH to join the Data & Systems team. You will build, optimize, and extend data pipelines, transforming data from multiple sources and preparing data for use by analysts.

Strong cloud experience preferred and hands-on pipeline development is required. Responsibilities include ETL/ELT pipeline construction, SQL optimization, and using Airflow or similar tools to automate data distribution.