Job Title

Role OverviewWe are looking for a hands-on Senior Business Analyst with 8–10 years of experience in Commercial Data Warehouse (CDW) and analytics. The role involves working closely with business stakeholders and data engineering teams to define, document, and deliver scalable data solutions that support commercial operations and decision-making.Key ResponsibilitiesBusiness & Functional AnalysisEngage with business stakeholders (Sales, Marketing, Market Access, Commercial Operations) to gather and analyze requirements.Translate business needs into detailed BRDs, FRDs, user stories, and data requirements.Define KPIs, metrics, business rules, and reporting needs for commercial analytics.Conduct gap analysis and recommend data-driven solutions.Data Warehouse & AnalyticsWork closely with data engineering teams on data modeling (dimensional models – fact/dimension).Define source-to-target mappings (STTM) and data transformation logic.Support development of Commercial Data Warehouse (CDW) and data marts.Ensure integration of multiple data sources such as:Sales data (primary/secondary)CRM dataMarket dataCustomer / HCP / Territory dataDelivery & TestingSupport Agile delivery – backlog grooming, sprint planning, and prioritization.Develop and execute UAT test cases and validate data accuracy.Perform data validation, reconciliation, and quality checks.Coordinate with cross-functional teams to ensure timely delivery.Stakeholder & CommunicationAct as a bridge between business, data engineering, and reporting teams.Provide regular updates, manage expectations, and support change management.Deliver functional walkthroughs, documentation, and user training where required.Required Skills & Experience8–10 years of experience as a Business Analyst, with strong hands-on involvement.Proven experience in Commercial Data Warehouse (CDW) / Enterprise Data Warehouse projects.Strong understanding of:Data warehousing concepts (ETL/ELT, dimensional modeling)Data mapping and data lineageSQL for data analysis and validationExperience working with commercial datasets such as sales, CRM, market data, or customer analytics.Hands-on experience with UAT, data validation, and business rule definition.Strong experience working in Agile/Scrum environments.Excellent stakeholder management and communication skills.Ability to work independently in a remote, distributed team environment.Preferred QualificationsExperience in Life Sciences / Pharma commercial analytics.Exposure to tools/platforms such as Snowflake, Azure, AWS, Databricks, or Redshift.Experience with visualization tools (Tableau, Power BI).Familiarity with data governance and data quality frameworks..