Data Warehouse ArchitectKey ResponsibilitiesArchitect and implement scalable data warehouse solutions using SnowflakeDesign end-to-end data architectures including ingestion, transformation, storage, and consumption layersDevelop and optimize data models (dimensional and normalized) to support analytics and reporting use casesLead integration of multiple data sources including commercial, clinical, and third-party vendor dataDefine 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 requirementsOptimize Snowflake performance, cost management, and workload scaling strategiesCollaborate with stakeholders to define data strategy, architecture roadmaps, and platform evolutionSupport downstream analytics, BI (e.g., Power BI), and data science initiativesProvide technical leadership and mentorship to data engineering teamsRequired Qualifications10+ years of experience in data architecture, data warehousing, or data engineeringExperience in life sciences, biotech, or healthcare data (commercial, clinical, RWD, etc.)3+ years of hands-on experience with Snowflake in a solution architecture roleStrong 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 practicesExcellent communication skills with ability to interface between business and technical teamsPreferred QualificationsFamiliarity with HCP/HCO, claims, Rx, or clinical trial datasetsExperience with MDM solutions and customer data integrationKnowledge of regulatory considerations (e.g., GxP, HIPAA)Snowflake certifications (e.g., SnowPro Core or Advanced)