Lead Business Analyst

Job Title: Business Analyst – Clinical Data Engineering & Snowflake

Location: Noida/Pune/Chennai/Bengaluru/Mumbai

Experience: 6–12 Years

Employment Type: Full-time

Job Summary

We are seeking an experienced Business Analyst with strong Life Sciences/Clinical Data and Data Engineering experience to support enterprise data engineering and modernization initiatives. The role will act as a bridge between Clinical/Business stakeholders, Data Engineers, Architects, QA, and Cloud teams, translating business requirements into scalable data solutions.

The ideal candidate should have strong knowledge of AWS, StreamSets, Snowflake, dbt, ETL/ELT, clinical data, and Medallion Architecture, with an understanding of transforming raw clinical data into bronze, silver, and gold data layers.

Key Responsibilities

• Partner with Clinical Data Management, Clinical Operations, Regulatory, Safety, and business teams to gather and analyse data requirements.

• Understand clinical data from sources such as EDC, CTMS, eTMF, laboratory, safety, and other clinical systems.

• Define business requirements, functional specifications, epics, user stories, acceptance criteria, and business rules.

• Develop and maintain source-to-target mappings, data dictionaries, transformation rules, and data lineage.

• Work closely with Data Engineers and Architects on AWS-based data engineering solutions.

• Define requirements for data ingestion using StreamSets and AWS services, including S3 and related data services.

• Support Snowflake data warehouse/data Lakehouse initiatives, including ingestion, transformation, and consumption requirements.

• Work with engineering teams to define and validate dbt-based data transformations and business logic.

• Understand Medallion Architecture and requirements for transforming Raw → Bronze → Silver → Gold datasets.

• Perform data analysis, profiling, reconciliation, and validation using SQL.

• Define data quality rules, validation criteria, UAT scenarios, and acceptance criteria.

• Support defect triage and resolution by analysing source-to-target data issues and transformation logic.

• Ensure clinical data accuracy, traceability, lineage, and regulatory compliance.

• Participate in Agile ceremonies, backlog refinement, sprint planning, reviews, and retrospectives.

• Maintain requirements and project documentation using Jira, Confluence, and related tools.

Required Skills & Qualifications

• Bachelor's/Master's degree in Life Sciences, Pharmacy, Computer Science, IT, Data Engineering, or related field.

• 6+ years of Business Analyst experience, preferably within Pharma/Life Sciences or Healthcare.

• Strong understanding of Clinical Data and Clinical Trials.

• Experience working on Data Engineering, Data Migration, Data Lake, or Data Warehouse projects.

• Strong knowledge of AWS, Snowflake, StreamSets, and dbt.

• Understanding of ETL/ELT, data pipelines, data transformation, data quality, and data lineage.

• Experience with Medallion Architecture – Raw/Bronze, Silver, and gold layers.

• Strong SQL skills for data analysis, validation, reconciliation, and profiling.

• Experience creating source-to-target mappings and transformation specifications.

• Understanding of GxP, data integrity, auditability, and regulated Life Sciences environments.

• Strong experience with UAT, Agile delivery, Jira, Confluence, and stakeholder management.