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.
