Hybrid Data Engineer - ETL/ELT, BI & Snowflake

Cincinnati Insurance Company; Fairfield (OH); Hybrid; USD 95,000 - 130,000; Full time

Job summary

Cincinnati Insurance Company is seeking an experienced BI/Data Engineer to design and implement robust ETL/ELT pipelines, organize complex source data, and build scalable data solutions in a fast-growing data ecosystem.

You will leverage tools like DataStage, Python, SQL, and Power BI to deliver reliable insights and data quality across the organization. Collaboration with agile teams and mentoring junior developers are key parts of the role.

Qualifications

• Experience designing and implementing ETL/ELT processes.
• Proficiency with DataStage or equivalent.
• Strong SQL and Python skills.
• Knowledge of Snowflake data warehousing.

Responsibilities

• Build robust and scalable data pipelines that empower business users with reliable insights.
• Analyze and organize raw data from multiple sources to produce required data elements.
• Design table structures and ETL/ELT to support scalable data solutions.
• Create reconciliation procedures and data quality checks.
• Provide production support and assist end-users and IT staff.
• Lead requirements gathering and documentation design.

Skills

ETL/ELT design

CI/CD

GitHub

VS Code

Snowflake

Power BI

Python

SQL

Data warehousing

Data modeling

Data quality

Agile

Mentoring

Tools

DataStage

SAS

DBT

Power BI

SQL

Job description

Cincinnati Insurance Company is seeking an experienced BI/Data Engineer to design and implement robust ETL/ELT pipelines, organize complex source data, and build scalable data solutions in a fast-growing data ecosystem.

You will leverage tools like DataStage, Python, SQL, and Power BI to deliver reliable insights and data quality across the organization. Collaboration with agile teams and mentoring junior developers are key parts of the role.