Experience: 15+
Summary
The Cloud Migration Data Architect is responsible for designing the target state architecture on Snowflake and defining the roadmap to move workloads from legacy environments. This includes establishing security frameworks, cost-control guardrails, and automated CI/CD pipelines to ensure a scalable and governed environment.
Key Responsibilities
Migration Strategy: Evaluate legacy workloads and determine the best migration path: Re-host (Lift & Shift), Re-platform (minor changes), or Re-architect (Redesign for Snowflake).
Architecture Design: Define the Snowflake account structure, including organization/account hierarchy, RBAC (Role-Based Access Control) models, and Virtual Warehouse sizing.
Data Modeling: Redesign legacy schemas into cloud-optimized formats like Star Schema, Snowflake Schema, or Data Vault 2.0.
ELT/ETL Modernization: Transition from traditional middleware to cloud-native tools like Snowpipe, Streams, Tasks, and dbt (data build tool).
Governance & Security: Implement Dynamic Data Masking, Row-Level Security (RLS), and end-to-end encryption to meet compliance (GDPR, HIPAA, etc.).
Cost Optimization (FinOps): Set up resource monitors and credit alerts to prevent budget overruns.
Technical Skills:
Snowflake (Warehouses, Stages, Time Travel, Zero-Copy Cloning, Iceberg Tables), AWS (S3, Glue), Azure (ADLS, ADF), or Google Cloud Platform (GCS, BigQuery), SQL, Python, Snowpark, dbt, Airflow, Informatica, Matillion, Teradata, Netezza, Hadoop/Hive, Oracle Exadata, SQL Server, Terraform, CloudFormation, Git, Jenkins/Azure DevOps
Certifications: SnowPro Core, SnowPro Advanced