Snowflake Solution Architect (Life Sciences / Biotech Data Platforms)

Snowflake Solution Architect (Life Sciences / Biotech Data Platforms)


Location: Remote (EST time zone)


Position type: Contract

What are we looking for?


We are seeking a highly experienced Snowflake Solution Architect to design and deliver scalable, cloud-native data platforms supporting commercial, clinical, and enterprise data domains within life sciences organizations. This role will focus on building modern data ecosystems that integrate diverse data sources into governed, analytics-ready environments that enable reporting, advanced analytics, and AI/ML use cases.


The ideal candidate brings deep expertise in Snowflake and modern data architectures, along with hands-on experience designing and implementing data warehouse solutions in regulated environments. This individual will work closely with business stakeholders, data engineers, and analytics teams to translate complex requirements into performant, scalable, and maintainable solutions.

Key Responsibilities
• Architect and implement scalable data warehouse solutions using Snowflake
• Design end-to-end data architectures including ingestion, transformation, storage, and consumption layers
• Develop and optimize data models (dimensional and normalized) to support analytics and reporting use cases
• Lead integration of multiple data sources including commercial, clinical, and third-party vendor data
• Define and implement ETL/ELT pipelines using modern tooling (e.g., DBT, Azure Data Factory, Databricks)
• Establish data governance, security, and data quality frameworks aligned with regulatory requirements
• Optimize Snowflake performance, cost management, and workload scaling strategies
• Collaborate with stakeholders to define data strategy, architecture roadmaps, and platform evolution
• Support downstream analytics, BI (e.g., Power BI), and data science initiatives
• Provide technical leadership and mentorship to data engineering teams

Required Qualifications
• 10+ years of experience in data architecture, data warehousing, or data engineering
• Experience in life sciences, biotech, or healthcare data (commercial, clinical, RWD, etc.)
• 3+ years of hands-on experience with Snowflake in a solution architecture role
• Strong expertise in SQL and data modeling (dimensional modeling, data vault, etc.)
• Experience designing and implementing cloud-based data platforms (Azure preferred, AWS acceptable)
• Hands-on experience with modern data stack tools (DBT, Databricks, MuleSoft, etc.)
• Experience integrating complex datasets (e.g., transactional, third-party, semi-structured data)
• Strong understanding of data governance, data quality, and security best practices
• Excellent communication skills with ability to interface between business and technical teams

Preferred Qualifications
• Familiarity with HCP/HCO, claims, Rx, or clinical trial datasets
• Experience with MDM solutions and customer data integration
• Knowledge of regulatory considerations (e.g., GxP, HIPAA)
• Snowflake certifications (e.g., SnowPro Core or Advanced)