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.