Senior ELT & Data Warehouse Engineer

Ohio BWC (official); Columbus (OH); On-site; USD 118,474,000 - 176,333,000; Full time

Job summary

Ohio Bureau of Workers' Compensation (BWC) in Columbus, OH seeks a Senior ELT Developer / Data Warehouse Engineer. You will design, develop, and optimize enterprise data pipelines powering reporting, analytics, and BI across multiple environments.

You will mentor others and collaborate with leadership to deliver robust, scalable data systems. The role emphasizes ELT development with Python, SQL, Snowflake, and DBT, plus BI tooling like Tableau, Power BI, and Cognos in a complex data landscape.

Qualifications

• 60 months combined work experience in performance tuning, configuration, data modeling and Tier II database support including 12 months in Data Warehouse.
• Alternative education paths require related work experience spanning data warehousing and core IT roles as described in the posting.

Responsibilities

• Design, develop, test, implement, and support complex ELT code using Python, SQL, Snowflake, StreamSets, and DBT.
• Perform data migrations and design business process monitoring solutions.
• Implement high-availability and disaster-resilient solutions across multiple data warehouse and reporting environments.
• Monitor load balancing and tune system parameters for optimal performance across databases (Oracle, Snowflake).
• Provide Tier II technical support for database and ELT issues, including performance, availability, data integrity, security, and customer concerns.
• Define and support Data Warehouse BI designs; assist in implementing Data Warehouses and data marts.
• Implement custom SQL solutions and data extracts for business customers; build dashboards and analytic applications.
• Replicate and transform data to support analytics and BI initiatives.
• Develop and maintain documentation, including installation procedures, monitoring guides, security policies, and migration processes.
• Write platform-specific code to support migrations across dev, UAT, performance, beta, and production.
• Conduct performance tuning across environments and design data security models and data layouts.
• Collaborate with Data Warehouse Architect, CIO, IT Managers to meet enterprise requirements; mentor junior staff.
• Prepare weekly activity and status reports; create and resolve trouble tickets with remediation updates.
• Develop database strategies to support evolving business needs; expand knowledge of project planning and IT lifecycle concepts.

Skills

Database Administration

Attention to Detail

Interpreting Data

Problem Solving

Continuous Improvement

Analyzation

Tools

Oracle

SQL

Cognos Framework Manager

Erwin

Tableau

R

Power BI

Python

Cognos Studios

Job description

Ohio Bureau of Workers' Compensation (BWC) in Columbus, OH seeks a Senior ELT Developer / Data Warehouse Engineer. You will design, develop, and optimize enterprise data pipelines powering reporting, analytics, and BI across multiple environments.

You will mentor others and collaborate with leadership to deliver robust, scalable data systems. The role emphasizes ELT development with Python, SQL, Snowflake, and DBT, plus BI tooling like Tableau, Power BI, and Cognos in a complex data landscape.