Snowflake Solution Architect
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)
· 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)