CDA Implementation Lead

Position - CDA Implementation Lead Location - Dearborn, MI Duration - 6+ Months Key Responsibilities 1. CDA Strategy & Architecture Leadership • Lead the design and implementation of the Cloud Data Access (CDA) aligned with enterprise modernization goals • Define target-state architecture integrating Guidewire (PC, BC, DataHub) with: • Cloud data platform (e.g., BigQuery) • Operational data stores (e.g., DynamoDB or equivalent) • Data ingestion and integration frameworks • Ensure architecture supports: • High scalability and performance • Real-time and batch data processing • Advanced analytics and reporting 1. Guidewire Data Integration & Optimization • Own end-to-end Guidewire data architecture, including: • PolicyCenter & BillingCenter data models • DataHub ingestion and canonical data structures • Lead integration patterns between Guidewire and CDA: • Event-based ingestion • Batch ETL/ELT pipelines • Ensure data consistency, lineage, and governance across Guidewire and enterprise platforms 1. Data Migration & Modernization • Drive migration of legacy insurance data systems to CDA platform Oversee: • Data profiling, cleansing, and transformation • Historical data onboarding (full + incremental loads) • Validation and reconciliation processes • Ensure functional parity with legacy extracts/reporting (e.g., Excel exports) 1. Data Engineering & Pipeline Execution • Lead development of modern ELT pipelines replacing legacy ETL tools • Implement scalable pipelines using: • Cloud-native tools (GCP stack preferred) • Streaming and batch frameworks • Ensure data quality frameworks, monitoring, and observability are in place 1. Program Leadership & Delivery Act as the technical lead across cross-functional teams: • Data engineering • Guidewire platform teams • Business analytics and reporting Manage: • Delivery roadmap and milestones • Risks, dependencies, and issue resolution • Ensure alignment with business stakeholders and product owners 1. Stakeholder Engagement Partner with: • Business teams (underwriting, billing, claims analytics) • Enterprise architecture teams • Vendor and SI partners • Translate business requirements into scalable data solutions Required Qualifications: Core Experience • 10+ years of experience in data architecture, data engineering, or data platforms • 5+ years in Guidewire ecosystem, with hands-on experience in: • PolicyCenter (PC) • BillingCenter (BC) • Guidewire DataHub (MANDATORY) Technical Expertise Strong knowledge of: • Guidewire data models and integration patterns • DataHub canonical model and ingestion framework • Experience with cloud platforms: • GCP (strongly preferred), or AWS/Azure • Expertise in: • Data warehousing (BigQuery or equivalent) • Data modeling (OLTP, OLAP, canonical models) • ETL/ELT modernization (migration from legacy tools like Informatica) Data Engineering Skills Proficiency in: • SQL and large-scale data processing • Batch and streaming pipeline design • Experience with: • Data migration strategies • Data quality frameworks • Metadata and lineage tools