Solution Architect Data Platform Modernization

As an experienced Data Architect, your role will involve defining the end-to-end migration strategy and owning the target state architecture across various aspects such as data ingestion, storage, transformation, consumption, security, and observability. You will be responsible for creating and maintaining high-level and detailed architecture diagrams, migration wave plans, and reference patterns. Additionally, you will align the architecture with enterprise standards, security, compliance, and cloud governance. Key Responsibilities: - Design the Databricks architecture, including 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 to define equivalent or improved implementations in Databricks and Snowflake. - Define canonical migration patterns for table structures, stored procedures, complex SQL, business logic, batch and incremental loads/CDC. - Design reusable migration frameworks and accelerators, such as code templates, parameterized pipelines, and data validation utilities. - Establish a wave-based migration model with clear entry/exit criteria by subject area/domain/criticality. - Define target ELT patterns using dbt on Snowflake (staging, core, mart layers). Qualifications Required: - 15+ years of experience 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. - Ability to align enterprise standards, security controls, DevSecOps, and future extensibility for AI/ML, self-service analytics, and downstream integrations. As an experienced Data Architect, your role will involve defining the end-to-end migration strategy and owning the target state architecture across various aspects such as data ingestion, storage, transformation, consumption, security, and observability. You will be responsible for creating and maintaining high-level and detailed architecture diagrams, migration wave plans, and reference patterns. Additionally, you will align the architecture with enterprise standards, security, compliance, and cloud governance. Key Responsibilities: - Design the Databricks architecture, including 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 to define equivalent or improved implementations in Databricks and Snowflake. - Define canonical migration patterns for table structures, stored procedures, complex SQL, business logic, batch and incremental loads/CDC. - Design reusable migration frameworks and accelerators, such as code templates, parameterized pipelines, and data validation utilities. - Establish a wave-based migration model with clear entry/exit criteria by subject area/domain/criticality. - Define target ELT patterns using dbt on Snowflake (staging, core, mart layers). Qualifications Required: - 15+ years of experience 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. - Ability to align enterprise standards, security controls, DevSecOps, and future extensibility for AI/ML, self-service analytics, and downstream integrations.