About Xceedance
Xceedance: Your Trusted Partner for Innovative Insurance Solutions and Services. Join Us in Transforming the Future of Insurance Together.
About the job
We are seeking a highly skilled Data Architect with deep experience designing and implementing enterprise data solutions in the insurance domain, including Duck Creek Clarity/Insights. The ideal candidate will bring strong hands-on and architectural expertise across Snowflake, SSIS, and Azure Data Factory (ADF), driving scalable, secure, and governed data platforms that power reporting, analytics, and operational insights.
You will partner with business stakeholders, Duck Creek platform teams, engineering, and analytics teams to define data architecture standards, shape integration patterns, and deliver reliable data products supporting underwriting, claims, policy, billing, and customer analytics.
Key Responsibilities
Data Architecture & Strategy
- Define and own the end-to-end data architecture for Duck Creek-centric ecosystems, spanning ingestion, transformation, semantic layers, and consumption.
- Establish target-state architecture for Clarity/Insights data, including integration patterns with enterprise data platforms (Snowflake/Azure).
- Create and maintain conceptual, logical, and physical data models (policy, billing, claims, producer, customer, financial).
- Lead data platform modernization, including migration and re-platforming from legacy EDW/ETL to Snowflake and cloud-native patterns.
- Define standards for data quality, metadata, lineage, and governance across the data lifecycle.
Duck Creek Clarity & Insights
- Architect data flows for Duck Creek Clarity reporting and operational data extraction from Duck Creek systems.
- Design robust ingestion and downstream analytics architectures leveraging Duck Creek Insights datasets, reporting, and metrics.
- Partner with Duck Creek functional/technical teams to interpret data structures, events, and domain mappings, ensuring consistent definitions and reporting truth.
Snowflake Platform Architecture
- Design scalable Snowflake solutions: schemas, warehouses, clustering, micro-partitioning strategy, data sharing, and cost/performance optimization.
- Implement patterns for ELT in Snowflake using SQL-based transformations and orchestration tools (ADF/SSIS).
- Define data security architecture in Snowflake using RBAC, masking policies, row access policies, and secure views (as applicable).
Integration & Pipelines (SSIS + ADF)
- Build and oversee robust pipelines using Azure Data Factory (ADF) for ingestion/orchestration, scheduling, monitoring, retries, and alerting.
- Design, build, and optimize SSIS packages for hybrid integrations, legacy feeds, and incremental loads where required.
- Establish patterns for CDC/incremental loads, auditing, reconciliation, and operational observability.
Governance, Quality & Observability
- Define and implement data quality rules, monitoring, and remediation processes (DQ scorecards, exception handling).
- Own metadata/lineage approaches and documentation, aligning with enterprise governance frameworks.
- Promote best practices in DevOps for data, including CI/CD, code reviews, branching strategies, and environment management.
Stakeholder & Delivery Leadership
- Translate business requirements into architecture deliverables (HLD/LLD, integration specs, data contracts).
- Act as a technical leader/mentor for data engineers and analysts; drive design sessions and solution reviews.
- Collaborate across security, infrastructure, architecture, and compliance teams to ensure solutions are production-grade.
Required Skills & Experience
Must-Have
- 12+ years in data engineering/architecture roles with enterprise data platforms.
- Strong experience with Duck Creek Clarity and Duck Creek Insights (reporting/analytics/data structures).
- Strong expertise with Snowflake (data modeling, performance tuning, security, and cost optimization).
- Hands-on experience with Azure Data Factory (ADF) (pipelines, integration runtimes, triggers, parameterization).
- Strong hands-on experience with SSIS (package design, deployment, troubleshooting, performance tuning).
- Strong hands-on experience in migrating data from legacy to the Duck Creek system
- Proven experience designing dimensional (Kimball) and/or Data Vault models for analytics.
- Strong SQL skills; proven ability to optimize complex queries and transformations.
- Insurance domain knowledge: policy lifecycle, billing, claims, commissions, and reinsurance is a huge plus
Nice-to-Have
- Azure ecosystem: ADLS Gen2, Azure Synapse, Databricks, Key Vault, Azure Monitor/Log Analytics.
- Experience implementing real-time/near-real-time patterns (Kafka/Event Hub, streams).
Education & Certifications
- Bachelor’s/Master’s in Computer Science, Information Systems, or equivalent experience.
- Preferred: Duck Creek Insights/Clarity certification, Snowflake certification, Azure (DP-203), or equivalent.
Deliverables & Artifacts You’ll Produce
- Target-state architecture diagrams (current vs future), integration reference architectures
- Canonical data models and domain mapping for Duck Creek data sources
- Snowflake design standards: naming conventions, environment layout, warehouse sizing strategy
- Data pipeline patterns (ADF/SSIS), error handling frameworks, logging, and audit models
- Data quality framework and governance playbooks