Senior Business Analyst

Apexon; Hyderabad, Bengaluru; Hybrid; INR 1,600,000 - 2,400,000; Full time

Job summary

Apexon in Hyderabad is seeking an experienced Senior Business Analyst with 7+ years in Data & Analytics to lead requirements, data mapping, and documentation.

You will work with stakeholders, translate business needs into FRD/BRD, perform data profiling, and support SIT/UAT while collaborating with data engineering and BI teams to deliver robust dashboards in Power BI. Experience with API/SFTP exchanges and agile/waterfall methods is valued.

Qualifications

• 7+ years of Business Analysis hands-on experience in Data & Analytics projects.
• Proficient in BRD/FRD/FIA documentation, data mapping, and test scenarios.
• Advanced SQL for data analysis, profiling, and validation.

Responsibilities

• Conduct requirements gathering sessions with business stakeholders.
• Review BRDs, KBQs, FIAs, vendor docs, source files, and data dictionaries.
• Create FRD, business rules, KPIs, source-to-target mappings, user stories, and test scenarios.
• Perform data discovery, profiling, validation, reconciliation, and impact analysis.
• Utilize SQL, Excel, Microsoft Fabric for data exploration and validation.
• Analyze data sources, transformations, and reporting requirements.
• Support business stakeholders in reporting mockups and dashboard requirements for Power BI.
• Translate business requirements and data logic to data engineering teams and participate in solution design discussions.
• Support SIT/UAT, defect triage, and requirement validation.
• Track dependencies, risks, assumptions, and action items, and provide regular project status updates to stakeholders.

Skills

SQL

Excel

Power BI

Microsoft Fabric

Data mapping

Data validation

Data reconciliation

Dimensional data modeling

BRD/FRD/FIA documentation

Tools

Power BI

Microsoft Fabric

Excel

Job description

Job Summary

Senior Business Analyst with 7+ years of experience in Data & Analytics projects, specializing in requirements gathering, BRD/FRD/FIA documentation, advanced SQL, data mapping, data validation, and reconciliation. Must have working knowledge of Microsoft Fabric, Power BI, dimensional data modeling, and API/SFTP-based data exchange. Experience in Agile and Waterfall methodologies, SIT/UAT, and stakeholder management is essential. Pharmaceutical commercial data experience is preferred.

Key Responsibilities

• Conduct requirements gathering sessions with business stakeholders.
• Review and understand BRDs, KBQs, FIAs, vendor documentation, source files, and data dictionaries.
• Create and maintain Functional Requirement Specification Documents (FRD), business rules, KPIs, source-to-target mappings, user stories, and test scenarios.
• Perform data discovery, profiling, validation, reconciliation, and impact analysis.
• Utilize SQL, Excel, Microsoft Fabric, and self-service analytics tools for data exploration and validation.
• Analyze data sources, transformations, and reporting requirements.
• Support business stakeholders in reporting mockups and dashboard requirements for Power BI.
• Translate business requirements and data logic to data engineering teams and participate in solution design discussions.
• Support SIT/UAT, defect triage, and requirement validation.
• Track dependencies, risks, assumptions, and action items, and provide regular project status updates to stakeholders.

Required Qualifications

• 7+ years of Business Analysis hands-on experience supporting Data & Analytics projects.
• Strong hands-on expertise in requirements documentation, including BRD, FIA, FRS, business rules, data mapping, and test scenarios.
• Advanced SQL skills for data analysis, profiling, and validation.
• Understanding of dimensional data modeling concepts, including Facts, Dimensions, Primary Keys, and Star Schema design.
• Working knowledge of Microsoft Fabric, Power BI, Excel, and self-service analytics tools.
• Understanding of APIs based data exchanges, SFTP-based file exchanges, and analytics data ingestion concepts.
• Strong communication skills and articulation of thoughts with technical and non-technical stakeholders.
• Experience working in Waterfall and Agile methodologies.