Senior ELT & Data Warehouse Engineer

Ohio BWC (official); Columbus (OH); On-site; USD 87,000 - 128,000; Full time

Job summary

Ohio BWC in Columbus seeks a Senior ELT Developer / Data Warehouse Engineer to design, develop, and optimize data solutions powering enterprise reporting, analytics, and BI. You will work across environments, support mission‑critical data operations, and collaborate with IT leaders to deliver scalable data systems.

This role emphasizes ELT development with Python, SQL, Snowflake, StreamSets, and DBT, plus data migrations, performance tuning, and mentoring of junior staff.

Qualifications

• 5+ years of combined data engineering and ELT experience across data warehouses.
• Experience designing and implementing ELT workflows using Python, SQL, Snowflake, and DBT.
• Strong knowledge of data migration, performance tuning, and data security practices.
• Experience mentoring junior developers and collaborating with IT leadership.

Responsibilities

• Design, develop, test, and support ELT processes using Python, SQL, Snowflake, StreamSets, and DBT.
• Migrate data and design monitoring solutions for data quality and reliability.
• Implement high-availability and disaster-resilient data solutions across multiple environments.
• Tune performance and ensure data integrity, security, and availability across Oracle, Snowflake, and BI platforms.
• Mentor junior ELT developers and document solutions for knowledge transfer.

Skills

Python

SQL

Snowflake

StreamSets

DBT

Oracle

Tableau

Power BI

R

Tools

Erwin

Cognos Framework Manager

Job description

Ohio BWC in Columbus seeks a Senior ELT Developer / Data Warehouse Engineer to design, develop, and optimize data solutions powering enterprise reporting, analytics, and BI. You will work across environments, support mission‑critical data operations, and collaborate with IT leaders to deliver scalable data systems.

This role emphasizes ELT development with Python, SQL, Snowflake, StreamSets, and DBT, plus data migrations, performance tuning, and mentoring of junior staff.