IT - Developer II - IV; Remote

MAKE A DIFFERENCE Share your talents and develop your skills as you build a career in a professional environment with a personal feel.

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 our communities and demonstrate that Actions 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 continue to grow.

Build your future with us

Our IT department is currently seeking an experienced BI developer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions

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.

To ensure active engagement in meetings,it is mandatory for all IT associates to have cameras turned on for all interactionswith other associates, customers, and stakeholders. Your camera must be on and positioned correctly to clearly show your face. This practice is crucial for maintaining connection and engagement, as non-verbal cues are essential for effective communication.

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…