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.