Data Engineer II; Data Operations & Infrastructure

Are you looking to make an impactful difference in your work, yourself, and your community? Why settle for just a job when you can land a career? At ICW Group, we are hiring team members who are ready to use their skills, curiosity, and drive to be part of our journey as we strive to transform the insurance carrier space. We're proud to be in business for over 50 years, and its change agents like yourself that will help us continue to deliver our mission to create the best insurance experience possible.

Headquartered in San Diego with regional offices located throughout the United States, ICW Group has been named for the twelfth consecutive year in a row and for the 20th time overall as a Top 50 performing P&C organization offering the stability of a large, profitable and growing company combined with a focus on all things people. It's our team members who make us an employer of choice and the vibrant company we are today.

We strive to make both our internal and external communities better everyday! Learn more about why you want to be here!

The Data Engineer II – Data Operations & Infrastructure owns the operational health of ICW Group's data platform stack. This role receives production workloads from development teams and is responsible for their ongoing run and maintain lifecycle—monitoring, incident response, platform administration, governance, and small operational enhancements. The role ensures uptime, reliability, data quality, and cost efficiency across the data ecosystem.

Production Support & Operational Reliability

• Takes ownership of data pipelines and platform workloads after handoff from development teams, becoming the primary point of accountability for their production health.
• Provides day-to-day production support for on-premises and cloud-based data pipelines, ensuring continuity of operations, timely incident resolution, and adherence to defined SLAs.
• Monitors, triages, and resolves data pipeline failures, performance degradations, and platform alerts across the data tech stack.
• Performs root cause analysis on pipeline failures and data issues, implementing fixes to prevent recurrence.
• Validates runbooks and handoff documentation from development teams; identifies gaps and works with developers to close them prior to full operational ownership.
• Maintains and enhances production support documentation including runbooks, troubleshooting guides, SOPs, and knowledge transfer materials.
  Data Platform Administration & Governance
• Administers the data warehouse/lakehouse environment including user/role management, warehouse configuration, resource monitoring, cost optimization, and security policies.
• Manages and maintains the transformation layer infrastructure including environment management, job scheduling, model execution monitoring, and performance troubleshooting.
• Administers and monitors orchestration tools to ensure reliable scheduling, execution health, and pipeline SLAs are met.
• Supports data ingestion tool administration including monitoring sync health, managing schema changes, and troubleshooting ingestion failures.
• Supports business intelligence platform administration, with expanded ownership as the platform matures.
• Oversees data quality monitoring tools, ensuring rules are maintained, alerts are actionable, and data quality SLAs are met.
• Performs platform hygiene and decluttering—removing deprecated objects, unused connectors, stale pipelines, and orphaned resources across the data tech stack.
  Data Infrastructure Monitoring & Observability
• Leverages cloud monitoring services to monitor data infrastructure components, configure alarms, maintain dashboards, and set up log-based alerting for pipeline health.
• Maintains…