Solution Architect - Data Platform Modernization

Roles & Responsibilities: • Define the end-to-end migration strategy across: • Own the target state architecture across data ingestion, storage, transformation, consumption, security, and observability. • Create and maintain high-level and detailed architecture diagrams, migration wave plans, and reference patterns. • Align architecture with enterprise standards, security, compliance, and cloud governance. • Design the Databricks architecture: workspaces, clusters, jobs, Delta Lake layers (bronze/silver/gold), and integration with Azure services. • Define integration patterns with Azure services such as ADLS, ADF/Synapse, Key Vault, Azure DevOps, and monitoring/log analytics. • Select and standardize data access methods (e.g., external tables, views, direct connections, APIs) for downstream consumers. • Analyze existing schemas, workloads, and query patterns, and define equivalent or improved implementations in Databricks and Snowflake. • Define canonical migration patterns for: o Table structures (including partitioning, clustering, distribution) o Stored procedures, complex SQL, and business logic o Batch and incremental loads / CDC • Design reusable migration frameworks and accelerators (e.g., code templates, parameterized pipelines, data validation utilities). • Establish a wave-based migration model (by subject area / domain / criticality) with clear entry/exit criteria. • Define target ELT patterns using dbt on Snowflake (staging, core, mart layers). Experience : • 15+ years designing enterprise data platforms, Lakehouse / medallion architectures, and scalable analytics ecosystems in regulated industries. • Deep experience defining Bronze, Silver, and future Gold / ODS patterns using Databricks, ADLS/S3, Delta Lake, DBT, orchestration, and secure consumption layers. • Strong capability in canonical data modeling across Policy, Claims, Billing, Customer, and reference/master data domains. • Experience with architecture decisions for performance, partitioning, lineage, metadata, resilience, disaster recovery, and environment strategy. • Able to align enterprise standards, security controls, DevSecOps, and future extensibility for AI/ML, self-service analytics, and downstream integrations.