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! PURPOSE OF THE JOBThe 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. ESSENTIAL DUTIES AND RESPONSIBILITIES 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 and troubleshoots serverless functions that support data workflows from a data infrastructure perspective (overall environment/cloud infrastructure setup is owned by the Cloud Infrastructure team). Implements and manages application performance monitoring and observability tooling to provide end-to-end visibility into data platform performance, resource utilization, and anomaly detection. Builds and maintains operational dashboards and alerting frameworks to proactively identify and resolve data infrastructure issues before they impact downstream consumers. Small Enhancements & Continuous Improvement Implements small operational enhancements to existing data pipelines—configuration updates, performance tuning, parameter changes, and minor fixes as defined by the team. Supports data ingestion workflows including monitoring connector health and adjusting configurations for operational needs. Supports regulatory reporting data initiatives from a data operations and pipeline reliability perspective. Identifies and implements operational improvements—automating manual processes, improving alerting coverage, and reducing mean time to resolution (MTTR). Collaboration & Coordination Works closely with Data Engineering development teams to receive production handoffs, validate runbooks, and ensure smooth transitions from development to operations. Partners with Enterprise Architecture, Technology, Cloud Infrastructure, and Project teams to ensure operational consistency while maintaining data governance requirements. Contributes to data governance and data quality best practices including operational reviews, incident post-mortems, and continuous improvement initiatives. SUPERVISORY RESPONISBILITIES This role does not have supervisory responsibilities.