IT - Developer II - IV (Remote)

Cincinnati Financial

6d•Remote

About The Position

The Cincinnati Insurance Companies is seeking an experienced developer to join their Business Intelligence & Data Management department. This role is part of an exciting transformation where associates are enhancing their skills and adopting modern tools like DBT, Python, and SQL to support data-driven decision-making. The developer will be responsible for building robust and scalable data pipelines to empower business users with reliable, actionable insights. All IT associates are required to have their cameras on during all interactions. Work location and flexibility are subject to change based on business needs, with potential for hybrid work for those within 50 miles of Headquarters and occasional travel to Fairfield, OH for those further away.

Requirements

Proven experience in designing and implementing ETL/ELT processes (preferred tools: Current platform: IBM's DataStage, SQL, SAS, Python; Moving to new platform: Python, DBT, SQL, Power BI).
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 tools 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 (property and casualty insurance background a plus).
Knowledge of developing BI dashboards (preferred tools: Current platform: IBM's Cognos, moving to new platform of: Microsoft's Power BI); creating data quality scorecards and data lineage.
Experience with agile teams.
Mentor development team members in design and development of BI solutions.
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.
Preferred three or more years of business requirements experience.

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.