Snowflake Data Architect

Job Description

We are a fast-growing data-analytics consultancy dedicated to the *Life Sciences / Pharmaceutical commercial analytics * space. Our teams build cloud-native data platforms that power sales, marketing, and patient-centric insights for leading global pharma brands—delivering compliant, high-impact solutions at enterprise scale. ### 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. - Expert‐level 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). - Bachelor’s in Computer Science, Engineering, Information Systems (Master’s 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. Job Type: Full-time Pay: ₹2,000,000.00 - ₹2,500,000.00 per year Work Location: In person Speak with the employer +91 9008078505