Mark Andrews

IDR is seeking a Data Architect to join one of our top clients for a remote opportunity. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today!

• Extract PC, BC, and KCC data from GWCP to Snowflake Rawzone using Change Data Capture (CDA)
• Minimize downtime and data loss through resilient extraction design
• Define new Rawzone schemas; map and integrate them into the Trusted/Vault layer
• Apply Data Vault 2.0 modeling (Hubs, Links, Sats) for scalability and auditability
• Design performant schema mappings & business-rule transformations
• Implement minimal-impact updates to the Refined zone while preserving historical lineage
• Leverage EOR to move PC, BC, KCC payloads into DataHub ODS & marts
• Assess and optimize extraction layers without disrupting existing SLAs

• 7+ years in data engineering / architecture with Guidewire downstream integration experience

• Expert-level knowledge of Guidewire Cloud CDA extraction for PC, BC, and KCC

• Proven Snowflake design & performance-tuning skills (Raw, Trusted/Vault, Refined zones)

• Hands-on Data Vault modeling and data-mart build-out for financial domains

• Strong command of EOR, DataHub (ODS & extraction layers), and CDC strategies

• Depth in SQL & at least one scripting language (Python, PySpark, or similar)