Senior Business Analyst

Johnson and Johnson; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Johnson & Johnson MedTech seeks a Senior Business Analyst to lead procurement analytics through trusted reporting and dashboards in a global supply chain. You will design, develop, and maintain Power BI solutions that improve spend visibility, supplier performance, and operational KPIs, partnering with procurement and data teams to translate requirements into scalable reporting products.

You will ensure data quality, governance, and governance, while delivering actionable insights for

Qualifications

• Bachelor's degree in engineering, CS, information systems, analytics, statistics, supply chain, business, or related field.
• 4-7 years of relevant experience in BI, analytics, reporting, or digital enablement roles.
• 4+ years of hands-on Power BI development in an enterprise environment.
• Proficiency in Power BI Desktop, Power BI Service, DAX, Power Query (M), and data modelling.
• Working knowledge of Microsoft Fabric / Power BI Fabric, including OneLake, Dataflows, pipelines, or integrated analytics workflows.
• Proficiency in SQL and experience with structured enterprise data sources.
• Experience developing dashboards and KPI reporting for business stakeholders with strong data accuracy and usability.
• Strong analytical thinking and ability to translate requirements into solutions.
• Excellent written and verbal communication across matrixed teams.

Responsibilities

• Develop and maintain Power BI dashboards and reports for procurement performance management and KPI monitoring.
• Design and maintain scalable semantic models and data connections from data lakes or warehouses.
• Create business logic using DAX and Power Query (M) for reusable calculations.
• Integrate data from ERP, SharePoint, Excel, APIs, and Fabric to ingest diverse sources.
• Ensure data accuracy and governance across dashboards and semantic models.
• Publish, secure, maintain, and monitor Power BI reporting solutions; manage workspace access and refresh schedules.
• Partner with stakeholders to gather requirements and translate analytics into actionable insights.
• Drive continuous improvement of dashboards, data workflows, and automation opportunities.

Skills

Advanced analytics

Analytical reasoning

Cross-functional collaboration

Data analysis

Detail-oriented

Problem solving

Education

Bachelor's degree in Engineering, CS, Information Systems, Analytics, Statistics, Supply Chain, or related field

Tools

Power BI Desktop

Power BI Service

DAX

Power Query (M)

Data modelling

Microsoft Fabric / Power BI Fabric

OneLake

SQL

Job description

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions are personal.Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow, and profoundly impact health for humanity.Learn more at jnj.com .

As guided by Our Credo, Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson, we respect the diversity and dignity of our employees and recognize their merit.

Job Function:

Data Analytics & Computational Sciences

Job Sub Function:

Business Intelligence

Job Category:

Professional

All Job Posting Locations:

Bangalore, Karnataka, India

Job Description:

Job Title: Senior Business Analyst, Supply Chain Procurement / MedTech

Pay Grade: 25

Job Function: Data Analytics & Computational Sciences

Job Sub Function: Business Intelligence / Procurement Digital Enablement

Job Category: Professional

Business Context: Johnson & Johnson MedTech Supply Chain Procurement

Location: Bangalore, India

1. Job Description

Johnson & Johnson MedTech is seeking a Senior Business Analyst to support Supply Chain Procurement through the delivery of trusted reporting, dashboards, and actionable analytics. This role is responsible for designing, developing, and maintaining Power BI solutions that improve visibility into spend, supplier performance, sourcing effectiveness, contract compliance, cost productivity, and operational KPIs. The position partners with Procurement stakeholders, process owners, and digital or data teams to translate business requirements into scalable reporting products that enable informed decision-making and strengthen operational discipline. At pay grade 25, this role is expected to operate as a strong individual contributor with hands-on expertise in Power BI development, data modelling, reporting governance, and stakeholder engagement within a matrixed enterprise environment.

2. Key Responsibilities

A. Procurement Performance Reporting & Visualization

• Develop and maintain Power BI dashboards and reports that support procurement performance management, spend visibility, supplier scorecards, sourcing outcomes, and operational KPI monitoring

B. Data Modelling, Transformation & Integration

• Design and maintain scalable semantic models like inside Fabric workspaces, connecting directly to data lakes or Data Warehouses
• Develop business logic using DAX and Power Query (M) to ensure consistent and reusable calculations
• Integrate and transform data from relevant sources such as ERP, SharePoint, Excel, APIs, and Fabric Pipelines to ingest data from various on-premises and cloud sources

C. Data Quality, Governance & Controls

• Ensure data accuracy, completeness across dashboards, semantic models, and reporting outputs

D. Report Deployment, Administration & Support

• Publish, secure, maintain, and monitor reporting solutions within Power BI
• Support workspace management, user access, refresh schedules, distribution, and lifecycle activities for production reporting solutions

E. Stakeholder Partnership & User Enablement

• Partner with key stakeholders to gather requirements and prioritize reporting needs
• Translate analytical requirements into practical reporting solutions and actionable insights for business and operations
• Serve as the procurement and spend analytics SME and strategic partner for stakeholders by shaping metric frameworks, defining business logic, driving insights, resolving complex data and reporting issues, and providing leadership-level interpretation of performance trends to support operational and strategic decision-making

F. Continuous Improvement & Digital Enablement

• Continuously improve existing dashboards, semantic models, and reporting workflows for relevance, efficiency, and user adoption
• Identify opportunities to simplify manual reporting and support digital enablement or automation initiatives in collaboration with relevant teams
• Stay current with Microsoft analytics capabilities, including Power BI and related platform enhancements relevant to the business

3. Required Qualifications

Education, Experience, and Skills:

• Bachelor's degree in engineering, Computer Science, Information Systems, Analytics, Statistics, Supply Chain, Business, or a related field
• 4-7 years of relevant experience in business intelligence, analytics, reporting, or digital enablement roles
• 4+ years of hands‑on experience in Power BI development within an enterprise environment
• Strong proficiency in Power BI Desktop, Power BI Service, DAX, Power Query (M), and data modelling
• Working knowledge of Microsoft Fabric / Power BI Fabric, including OneLake, Dataflows, pipelines, or integrated analytics workflows
• Proficiency in SQL and experience working with structured enterprise data sources
• Experience developing dashboards and KPI reporting for business stakeholders with strong attention to data accuracy, usability, and reporting quality
• Strong analytical thinking, problem-solving capability, and ability to translate business requirements into practical reporting solutions
• Effective written and verbal communication skills, with the ability to work across matrixed teams and stakeholder groups

4. Preferred Qualifications

• Exposure to ERP, procurement, sourcing, supplier management systems
• Knowledge of procurement analytics and spend analytics concepts, including spend visibility, category insights, supplier performance, savings tracking, and compliance reporting
• Demonstrated ability to act as a procurement and spend analytics SME and trusted advisor, influencing metric design, business context, reporting priorities, and providing insights across stakeholder groups
• Experience with Azure, Microsoft Fabric, APIs or enterprise analytics platforms
• Basic knowledge of Python or automation approaches for reporting and analytics improvement

Preferred Skills:

Advanced Analytics, Analytical Reasoning, Business Behavior, Business Intelligence (BI), Cross-Functional Collaboration, Data Analysis, Data Integration, Data Modeling, Data Privacy Standards, Data Reporting, Detail-Oriented, Management Systems Implementation, Problem Solving, Process Oriented, Project Management, Statistical Analysis Systems (SAS) Programming, Workflow Analysis