Lead Business Analyst

Birlasoft; Dadri; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Birlasoft is seeking an experienced Business Analyst to bridge Clinical Data Engineering with modern data platforms. You will translate clinical data requirements into scalable data solutions, collaborating with Clinical Operations, QA, and Cloud teams.

The role emphasizes experience with AWS, Snowflake, StreamSets, dbt, ETL/ELT, and Medallion Architecture, ensuring data accuracy, lineage, and regulatory compliance across bronze to gold layers.

Qualifications

• Experience in Life Sciences or Pharma with Clinical Data knowledge.
• Ability to translate business requirements into data solutions.
• Familiarity with data governance and regulatory considerations in Life Sciences.
• Experience with data pipelines, data lakes, or data warehouses.
• Proficient SQL for data validation and profiling.
• Experience with Agile, Jira/Confluence, and stakeholder management.

Responsibilities

• Gather and analyze data requirements with Clinical teams.
• Understand data from EDC, CTMS, eTMF and lab systems.
• Define business requirements, epics, user stories, and criteria.
• Develop source-to-target mappings, data dictionaries, transformation rules.
• Collaborate with Data Engineers and Architects on AWS-based solutions.
• Define data ingestion requirements using StreamSets and AWS services.
• Support Snowflake data warehouse and data lakehouse initiatives.
• Define dbt-based transformations and business logic.
• Perform data analysis, profiling, reconciliation, and validation using SQL.
• Ensure data quality, traceability, and regulatory compliance.
• Participate in Agile ceremonies and maintain Jira/Confluence docs.

Skills

Clinical Data

Data Engineering

Stakeholder management

SQL

Education

Bachelor's/Master's degree in Life Sciences/Pharmacy/CS/IT/Data Engineering or related field

Tools

AWS

Snowflake

StreamSets

dbt

ETL/ELT

Job description

Job Title: Business Analyst - Clinical Data Engineering & Snowflake

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.
• 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.