IT - Developer II - IV (Remote)

Summary

The Cincinnati Insurance Companies is an insurance organization focused on serving independent agents and helping protect families and businesses. The Developer II-IV will build scalable data pipelines and reporting solutions, support data quality and business intelligence initiatives, and collaborate with business and technical teams on data architecture, analysis, and production support.

Responsibilities

• Develop reliable, reusable, automated and streamlined ETL/ELT code
• Analyze and organize raw data from multiple sources to produce requested or required data elements
• Design table structures and ETL/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 technical assistance to end-user and IT staff
• Assist and/or lead user requirements gathering and documentation designs
• Proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries
• Participate and/or 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

Skills

• Experience with continuous integration and continuous delivery/deployment concepts (CI/CD)
• Demonstrated experience using GitHub for version control, collaborative development, and code review workflows in a team-based environment
• Proficiency in using Visual Studio Code as a development environment, including debugging tool to streamline coding workflows
• Experience working with Snowflake for scalable data warehousing, including designing and optimizing data pipelines and leveraging its features for performance and security
• 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
• Understanding of enterprise technical landscape
• Experience with agile teams
• Strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills
• Ability to comprehend 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
• Proven experience in designing and implementing ETL/ELT processes
• Property and casualty insurance background
• Knowledge of developing BI dashboards
• Preferred three or more years of business requirements experience

Qualifications

Must Haves

• experience with continuous integration and continuous delivery/deployment concepts (CI/CD)
• demonstrated experience using GitHub for version control, collaborative development, and code review workflows in a team-based environment
• Proficiency in using Visual Studio Code as a development environment, including debugging tool to streamline coding workflows
• experience working with Snowflake for scalable data warehousing, including designing and optimizing data pipelines and leveraging its features for performance and security
• 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
• understanding of enterprise technical landscape
• experience with agile teams
• strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills
• ability to comprehend 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

Nice to Haves

• proven experience in designing and implementing ETL/ELT processes
• property and casualty insurance background
• knowledge of developing BI dashboards
• preferred three or more years of business requirements experience

Benefits

• Cincinnati provides you with the tools and training to be successful and to become a trusted, respected insurance professional.
• Generally, selected candidates who reside more than 50 miles from Headquarters may work remotely but must be flexible and available to travel to Fairfield, OH, on an occasional basis for special events, training sessions, or key meetings.