IT - Developer I - V

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

Make A Difference With A Career In Insurance

At The Cincinnati Insurance Companies, we put people first and apply the Golden Rule to our daily operations. To put this into action, we’re looking for extraordinary people to join our talented team. Our service-oriented, ethical, knowledgeable, caring associates are the heart of our vision to be the best company serving independent agents. We help protect families and businesses as they work to prevent or recover from a loss. Share your talents to help us reach for continued success as we bring value to the communities we serve and demonstrate thatActions Speak Louder in Person.

If you’re ready to build productive relationships, collaborate within a diverse team, embrace challenges and develop your skills, then Cincinnati may be the place for you. We offer career opportunities where you can contribute and grow.

Build your future with us

Our IT Business Intelligence & Automation team seeks curious individuals who embrace uncertainty, take risks, and learn quickly from experiences. Professionals who demonstrate respect and humility, value collaboration and believe better solutions come from working together may be a great fit for our team.

To ensure active engagement, all associates are expected to appear on camera during virtual meetings with other associates, customers and stakeholders. This practice is important for maintaining connection, as non-verbal cues are essential for effective communication and building relationships.

Work location and flexibility are subject to change based on evolving business needs, but generally, selected candidates who reside:

• within 50 miles of Headquarters may be expected to work in a hybrid capacity, combining remote and onsite work when business needs necessitate.

• more than 50 miles from Headquarters must be flexible and available to travel to Fairfield, OH, on an occasional basis for special events, training sessions, or key meetings.

Be ready to:

• develop reliable, reusable, automated and streamlined ELT code

• analyze and organize raw data from multiple sources to produce requested or required data elements

• design table structures and ELT to build performant data solutions that are scalable in a fast-growing data ecosystem

• create reconciliation procedures and data checks to ensure data quality

• build in automated audit, balancing, and controls

• provide production support, including on-call rotation and technical assistance to end-user and IT staff

• lead user requirements gathering and documentation designs

• proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries

• lead application and technical architecture analysis, design, and implementation, and ensure BI product fulfills requirements

• lead efforts with data management and database specialists to troubleshoot and report issues

• design new reporting applications to ensure reporting requests can be supported by the underlying data source

• adhere to all metadata management and data quality standards by leading quality management reviews

• understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge

• proactively identify, build, and maintain relationships with business process owners and colleagues

• identify changes in scope or work effort that could result in budgetary overrun or missing of delivery date, design and implement contingency

• demonstrate expert problem-solving capabilities

• mentor development team members in design and development of BI solutions

• proven experience in designing and implementing ELT processes (preferred tools: dbt, SQL, Jinja, Python)

• proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models

Be equipped with:

• strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills

• ability to comprehend complex technical and logical concepts and adapt quickly to changes

• ability to maintain own workflow and meet deadlines while managing parallel project deliverables with minimal direction

• ability to create effective visual models to enable collective understanding of processes, data flow, user interaction, and others as needed

• prior reporting application support experience

• track record of successfully architecting small, medium, and enterprise-scale solutions

Preferred:

• two or more years of experience with SQL, data modeling, and dimensional modeling

• experience with modern cloud data platforms and technologies, including Azure, Snowflake, and dbt

• experience designing, developing, and supporting business intelligence dashboards and reports using Microsoft Power BI, including data quality scorecards, KPI reporting, and data lineage

• experience supporting data, analytics, or reporting solutions for regulatory, financial, operational, or compliance reporting requirements

• experience working within Agile teams and delivery methodologies

Enhance your talents

Providing outstanding service and developing strong relationships with our independent agents are hallmarks of our company. Whether you have experience from another carrier or you’re new to the insurance industry, we promote a lifelong learning approach. Cincinnati provides you with the tools and training to be successful and to become a trusted, respected insurance professional – all while enjoying a meaningful career.

Enjoy benefits and amenities

Your commitment to providing strong service, sharing best practices and creating solutions that impact lives is appreciated. To increase the well-being and satisfaction of our associates, we offer a variety ofbenefits and amenities.

Embrace a diverse team

As a relationship-based organization, we welcome and value a diverse workforce. We grant equal employment opportunity to all qualified persons without regard to race; creed; color; sex, including sexual orientation, gender identity and transgender status; religion; national origin; age; disability; military service; veteran status; pregnancy; AIDS/HIV or genetic information; or any other basis prohibited by law. All job applicants have rights under Federal Employment Laws. Please reviewthis informationto learn more about those rights.