Junior BI & ELT Engineer (Hybrid)

Cincinnati Financial; United States; Hybrid; USD 90,000 - 140,000; Full time

Job summary

The Cincinnati Insurance Companies is seeking a data engineer in our IT BI & Automation team to build and optimize ELT processes, transforming data from multiple sources into reliable data elements for reporting and analytics.

You will design scalable table structures, implement dbt-based ELT pipelines, and partner with business groups to deliver high-quality BI solutions using SQL, Python, Azure, Snowflake, and Power BI. Hybrid work with occasional travel to Fairfield, OH may be required.

Qualifications

• Two or more years of experience with SQL, data modeling, and dimensional modeling.
• Experience with modern cloud data platforms including Azure, Snowflake, and dbt.
• Experience designing, developing, and supporting BI dashboards and reports using Power BI.
• Experience working in Agile environments and delivery methodologies.
• Strong ability to distill business requirements into data warehouse design artifacts.

Responsibilities

• Develop reliable, reusable ELT code and automate data pipelines.
• Analyze and organize raw data from multiple sources to produce data elements.
• Design table structures and ELT to build scalable BI solutions.
• Create data quality checks and reconciliation procedures.
• Provide production support including on-call rotation.
• Lead requirements gathering and documentation for BI solutions.
• Mentor team members in BI solution design.
• Collaborate with data management and DB specialists to troubleshoot issues.
• Design new reporting apps to support reporting needs.

Skills

SQL

Data modeling

Dimensional modeling

dbt

Python

Jinja

Azure

Snowflake

Power BI

Tools

Power BI

Azure

Snowflake

dbt

SQL

Job description

The Cincinnati Insurance Companies is seeking a data engineer in our IT BI & Automation team to build and optimize ELT processes, transforming data from multiple sources into reliable data elements for reporting and analytics.

You will design scalable table structures, implement dbt-based ELT pipelines, and partner with business groups to deliver high-quality BI solutions using SQL, Python, Azure, Snowflake, and Power BI. Hybrid work with occasional travel to Fairfield, OH may be required.