The Cincinnati Insurance Companies · 1 month ago
IT - Developer II - IV (Remote)
United States
Full-time
Remote
Mid, Senior Level, Lead/Staff
3+ years expThe Cincinnati Insurance Companies is seeking an experienced developer to join their Business Intelligence & Data Management department. The role involves building robust and scalable data pipelines to provide actionable insights, ensuring data quality and supporting data-driven decision-making across the organization.
Insurance
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
Qualification
Required
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 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 (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
Benefits
We offer career opportunities where you can contribute and grow.
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.
To increase the well-being and satisfaction of our associates, we offer a variety of [benefits and amenities](https://www.cinfin.com/cincinnati-insurance-careers/benefits).
Company
The Cincinnati Insurance Companies
The Cincinnati Insurance Companies markets business, home and auto insurance products through independent insurance agencies.
1001-5000 employees
H1B Sponsorship
The Cincinnati Insurance Companies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
50%
Represents job field similar to this job
Engineering and Development
Accounting and Finance
Trends of Total Sponsorships
*2025 (7)
2023 (2)
2021 (1)
2020 (2)
Funding
Current Stage
Late StageLeadership Team
Michael J. Sewell
CFO, Executive Vice President & Treasurer
Steven A. Soloria, CFA, CPCU
Sr. Vice President, Chief Investment Officer
Recent News
Morningstar.com
2026-07-15
Coverager - Insurance news and insights
2026-06-17
2026-06-16
Company data provided by crunchbase