Senior ELT & Data Warehouse Engineer

State of Ohio; Columbus (OH); On-site; USD 119,713,000 - 176,333,000; Full time

Job summary

The Bureau of Workers' Compensation (BWC) in Columbus, part of the State of Ohio, seeks a Senior ELT Analytics Specialist to design, develop, and optimize data solutions powering enterprise reporting and BI. The role spans data engineering, BI design, and data architecture across multiple environments.

You will lead ELT development, ensure data quality, mentor junior staff, and collaborate with business and IT leaders to deliver scalable data systems in a fast-paced government setting.

Responsibilities

• Design, develop, test, implement, and support ELT code using Python, SQL, Snowflake, StreamSets, and DBT.
• Perform data migrations and design monitoring solutions.
• Implement high-availability and disaster-resilient data warehouse solutions.
• Monitor load balancing and tune databases including Oracle and Snowflake.
• Provide Tier II support for database and ELT issues.

Skills

Database Administration

Analyzation

Attention to Detail

Interpreting Data

Problem Solving

Continuous Improvement

Tools

Python

SQL

Snowflake

StreamSets

DBT

Oracle

Job description

The Bureau of Workers' Compensation (BWC) in Columbus, part of the State of Ohio, seeks a Senior ELT Analytics Specialist to design, develop, and optimize data solutions powering enterprise reporting and BI. The role spans data engineering, BI design, and data architecture across multiple environments.

You will lead ELT development, ensure data quality, mentor junior staff, and collaborate with business and IT leaders to deliver scalable data systems in a fast-paced government setting.