Senior Data Engineer

About CloudLabs:

CloudLabs Inc was founded in 2014 with the mission to provide exceptional IT & Business consulting services at a competitive price, to help clients realize the best value from their investments.

Within a short span, CloudLabs evolved from pure-play consulting into a transformative partner for Business Acceleration Advisory, Transformative Application Development & Managed Services - enabling digital transformations, M&A transitions, Automation & Process-driven optimizations & complex Integration initiatives for enterprises across the globe.

As a Strategic Planning & Implementation Partner for global companies, CloudLabs has seen a 200% uptake in winning high-value, high-impact and high-risk projects that are critical for the business.

With offices in the US, Canada, Australia & India and with the team of 250+ experienced specialists, CloudLabs is now at an inflection point and ready for its next curve of progress.

Please write & follow us here:

Website:cloudlabsit.com

LinkedIn:CloudLabs Inc

Email us: [Confidential Information]

What we offer:

• We welcome candidates rejoining the workforce after career break/parental leave and support their journey to reacclimatize too corporate.
• Flexible remote work.
• Competitive pay package.
• Attractive policy, medical insurance benefits, industry leading training.
• Opportunity to work remotely is available.

Experience Required: Minimum 10 years of Experience

Job Location: Mumbai

Job Type: On-site

Key Responsibilities:

• Build and automate end-to-end data pipelines using Python and Snowflake (including Snowpark and Streams/Tasks) to ingest diverse clinical trial data feeds.
• Design, develop, and maintain secure, scalable data pipelines extracting data from Veeva Safety/Vault APIs into Snowflake.
• Design scalable data models in Snowflake that support complex R&D queries, ensuring alignment with industry standards (like CDISC SDTM/ADaM).
• Architect optimal Snowflake data models (schemas, tables, views) tailored for life sciences compliance and safety reporting.
• Partner closely with R&D data scientists to prepare, clean, and optimize features for machine learning and statistical modeling.
• Write and optimize complex SQL queries, stored procedures, and Snowpark/Python scripts for high-performance data processing.
• Maintain strict data governance, ensuring all pipelines comply with HIPAA, GxP, and clinical trial data privacy regulations.
• Ensure strict adherence to pharmaceutical data privacy, compliance (GxP), and security standards during data transit and storage.

Required Qualifications:

• 10 years of hands-on experience with Snowflake architecture, advanced SQL, Snowpipe, performance tuning, and query optimization.
• Strong proficiency in Python (pandas, API integrations, and Snowpark).
• Deep understanding of clinical trial data structures, electronic data capture (EDC) systems, or clinical data management systems (CDMS).
• Proven experience working with Veeva Vault APIs, Veeva Safety, or Veeva Vault Loader.
• Proven experience with orchestration tools and building robust error-handling into data pipelines.
• Familiarity with Life Sciences, specifically Pharmacovigilance (PV), drug safety, or GxP compliance data.
• Familiarity with Snowpark Python or standard data schemas like CDISC.