Snowflake Data Architect/ Snowflake Solutions Architect - Remote

Remote role

6 Week Assignment

Needing someone who has gone into an existing Snowflake environment, assessed the architecture and data pipelines, identified gaps around ingestion, data quality, modeling, lineage, security, and reporting, designed the target-state architecture, and helped create the modernization roadmap.

• Looking for a senior Snowflake Data Architect / Snowflake Platform Architect, but with strong assessment and advisory skills.
• Snowflake architecture expertise, including designing or assessing enterprise Snowflake environments.
• Strong data architecture experience across ingestion → raw → curated → modeled → data products/semantic layer → BI/AI
• Experience assessing existing environments, identifying gaps, and creating current-state / target-state architecture and roadmaps. The deliverables specifically include current-state, target-state, and data-flow diagrams.
• Strong ingestion / data pipeline architecture, including batch, streaming, APIs, CDC/replication, schema changes, and validation
• Data quality and governance knowledge, including metadata, lineage, cataloging, validation rules, and common definitions.
• Snowflake security, especially RBAC, masking, sensitive data, encryption, and access controls. That's particularly important because this is healthcare/patient data
• Ability to work consultatively with business and technical stakeholders, conduct discovery sessions, review the existing architecture/code/pipelines, identify problems, and recommend what should happen next

Formal JD

Required Skills & Experience

• 7+ years of experience in enterprise data engineering and analytics architecture, with at least 3+ years of hands-on experience designing and deploying Snowflake solutions.
• Proven experience leading greenfield Snowflake implementations, building platforms from the ground up in enterprise settings.
• Deep expertise in cloud services that complement Snowflake (Azure Data Factory, AWS Glue, GCP Dataflow, etc.).
• Extensive experience designing and implementing ELT pipelines using SQL and cloud-native tools.
• Strong understanding of modern data architectures, including Medallion lakehouse models, data vault, and dimensional modeling (Inmon & Kimball).
• Proficiency in governance and security best practices, including Snowflake RBAC, masking policies, and compliance controls.
• Hands-on experience optimizing Snowflake environments, including clustering keys, materialized views, and query performance tuning.
• Familiarity with streaming architectures and real-time data processing (Kafka, Snowpipe Streaming, etc.) is a plus.
• Experience working in Agile delivery environments, leading teams through solution design, implementation, and deployment.
• Strong consultative skills, with the ability to engage with stakeholders, define technical roadmaps, and deliver high-impact solutions.
• BA/BS required, preferably in Management Information Systems, Computer Information Systems, Computer Science, or related fields (applicable education and experience may be substituted).
• Advanced degree (MS) in a quantitative or related discipline preferred (applicable experience may be substituted).

Preferred Qualifications

• Prior experience at Snowflake or working directly with Snowflake professional services.
• Snowflake technical certifications (SnowPro Advanced Architect, SnowPro Core).
• Exposure to IDMC (Informatica Intelligent Data Management Cloud), Fivetran, or Matillion.
• Experience with DataOps concepts and CI/CD pipelines for Snowflake deployments.
• Knowledge of ML/AI pipelines leveraging Snowflake's Snowpark and external ML platforms.