The Cincinnati Insurance Companies · 17 hours ago
IT - Architect (Remote)
United States
Full-time
Remote
Senior Level, Lead/Staff
5+ years expThe Cincinnati Insurance Companies is dedicated to putting people first and is looking for a transformational IT Architect to join their IT Business Intelligence & Data Management team. The role involves leading the design of a modern data platform, defining enterprise modeling standards, and guiding teams in adopting best practices across analytics and data engineering.
Insurance
Responsibilities
Own and evolve the Modern BI & Data Engineering Playbook, including templates for dbt, Git/GitHub workflows, and CI/CD pipelines
Architect Snowflake end to end: RBAC, workload isolation, performance optimization, cost governance, environment structure, and naming conventions
Define enterprise data modeling standards including conformed layers and reusable domain-level data products
Establish and govern enterprise CI/CD pipelines for automated testing, documentation, and deployment
Create and maintain standardized dbt project structures, macros, testing frameworks, and reusable starter templates
Develop cloud-native and on-prem hybrid architecture patterns for consistent security and deployment
Standardize orchestration patterns using Airflow, Dagster, or Prefect
Implement DataOps principles including data-as-code, quality checks, lineage, monitoring, and automated alerting
Drive component-based governance to ensure reuse and eliminate redundant BI and ETL pipelines
Champion a federated yet governed model for BI and data product development
Implement discoverability and lineage to enable teams to reuse and extend existing components
Embed as a player-coach with domain teams to co-develop patterns and pipelines
Lead workshops and mentor engineers on Snowflake, dbt, Git, CI/CD, and analytics engineering best practices
Design component layers that support AI capabilities such as RAG and analytics assistants
Integrate AI capabilities into the SDLC, including automated testing and documentation enrichment
Partner with Portfolio and Service Management to lead incremental migrations from legacy BI/ETL tools to the modern stack
Qualification
Required
5+ years in data engineering or data architecture, including 3+ years in a lead or principal architect role
expert‑level dbt: structure, macros, testing, documentation, and operating multi‑project environments
Snowflake mastery: RBAC, virtual warehouses, performance tuning, workload isolation, and cost management
DataOps & Git fluency: strong opinions and hands‑on experience with Git branching/PRs and CI/CD (e.g., GitHub Actions, Jenkins) for automated testing and deployment
proven migration leadership from legacy, vendor‑locked tools (e.g., DataStage, Informatica, Oracle) to modern, code‑based stacks
dimensional & relational modeling expertise, including data mesh hybrid modeling and conformed layer design
communication & leadership: clear, pragmatic, and credible with engineers and non‑technical stakeholders; player‑coach mentality
Preferred
deep understanding of Property & Casualty (P&C) insurance data models, including: policy (coverages, endorsements, limits), claims (loss events, reserves, payments), billing (premium calculations, payment schedules), underwriting (risk assessment, profitability metrics)
familiarity with regulatory and compliance requirements impacting insurance data (e.g., state filings, statutory reporting)
ability to translate business concepts (loss ratio, combined ratio, underwriting profitability) into data models and metrics
experience designing data products for insurance use cases such as: underwriting profitability marts, claims analytics and fraud detection, policy lifecycle reporting
knowledge of industry standards (e.g., ACORD data models) is a plus
domain knowledge (policy, claims, billing, underwriting) and awareness of regulatory considerations
orchestration: Airflow, Dagster, or Prefect
ingestion: Fivetran or Airbyte
cataloging/observability: Alation, Monte Carlo, Acceldata, or similar
AI/ML integration: RAG architecture; using AI to augment SDLC and test
experience in AWS/Azure/GCP
Bachelor's or master's in computer science, Information Systems, or related field (or equivalent experience)
Benefits
Hybrid work options
Tools and training to be successful
Meaningful career
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
Represents job field similar to this job
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
Company data provided by crunchbase