Snowflake Data Architect

Role & Responsibilities

• Architect, build, and tune

  Snowflake data warehouses and ELT pipelines (SQL, Streams, Tasks, UDFs, Stored Procedures) to meet complex commercial-analytics workloads. 

• Integrate diverse pharma data sources

  (Veeva, Salesforce, IQVIA, Symphony, RWD, patient-services feeds) via Fivetran, ADF, or Python-based frameworks, ensuring end-to-end data quality. 
• Establish robust

  data models (star, snowflake, Data Vault)

  optimized for sales reporting, market-share analytics, and AI/ML use-cases. 
• Drive

  governance & compliance

  (HIPAA, GDPR, GxP) through fine-grained access controls, masking, lineage, and metadata management. 
• Lead code reviews, mentor engineers, and resolve performance bottlenecks while right-sizing compute for cost efficiency. 
• Partner with business stakeholders to translate commercial objectives into scalable data solutions and actionable insights. 

Skills & Qualifications

Must-Have

• 7+ yrs data-engineering / warehousing experience, incl. 4+ yrs hands-on Snowflake design & development. 
• Expertlevel SQL plus strong data-modeling (Dimensional, Data Vault) and ETL/ELT optimisation skills. 
• Proficiency in Python (or similar) for automation, API integrations, and orchestration. 
• Proven governance/security acumen within regulated industries (HIPAA, GDPR, PII). 
• Bachelors in Computer Science, Engineering, Information Systems (Masters preferred). 
• Strong client-facing communication and problem-solving ability in fast-paced, agile environments. 

Preferred

• Direct experience with

  pharma commercial datasets

  (sales, CRM, claims, MDM, adherence KPIs). 
• Cloud-platform depth (AWS, Azure, or GCP) and familiarity with tools such as Matillion/DBT/Airflow, Git. 
• Snowflake certifications (SnowPro Core / Advanced) plus Tableau, Power BI, or Qlik connectivity know-how.