Senior Data Analyst

Novumgen; Vadodara; On-site; INR 2,000,000 - 3,200,000; Full time

Job summary

Novumgen is seeking a Senior Data Analyst to lead budgeting and cross‑functional reporting across Sales, Procurement, Demand Planning & Supply Chain, Market Access and Finance.

You will design and maintain Power BI dashboards, ensure data accuracy, and partner with senior stakeholders to translate questions into actionable insights.

Qualifications

• Bachelor's degree in a data-related field or equivalent experience.
• 2+ years in data analytics / BI, ideally in pharma or regulated industries.
• Strong analytical mindset with high attention to detail and accuracy.
• Excellent communication, capable of presenting data-driven insights to leaders.

Responsibilities

• Own the budgeting process end-to-end with Finance and department heads.
• Design, build and maintain Power BI dashboards across multiple functions.
• Ensure data accuracy, timeliness and governance of reporting outputs.
• Collaborate with stakeholders to translate requirements into self-service reports.
• Continuously improve report performance and data models (star schema, DAX).

Skills

Power BI

Data modeling

Excel

Python

SQL

DAX

Stakeholder engagement

Cross-functional data

Education

Bachelor's degree

Tools

Microsoft Fabric

Power Query

Job description

About the Role

We are seeking an experienced Senior Data Analyst to join our pharmaceutical business, playing a central role in company-wide financial planning and cross-functional reporting. This role owns the annual budgeting process end-to-end and is responsible for developing, maintaining, and optimising Power BI reporting across Sales, Procurement, Demand Planning & Supply Chain, Market Access, and Finance functions.

This is a high-visibility position requiring close collaboration with senior stakeholders across commercial, operational, and financial teams, translating complex data into actionable insights that support strategic decision-making across the business.

Key Responsibilities

Budgeting & Financial Planning

• Create, own, and maintain the company's annual budget, working closely with Finance and department heads.
• Support budget forecasting, variance analysis, and periodic reviews to ensure alignment with business objectives.
• Consolidate inputs from multiple business functions into a single, accurate, and well-governed budget model.

Business Intelligence & Reporting

• Design, build, and maintain Power BI dashboards and reports across:
• Sales
• Procurement
• Demand Planning & Supply Chain
• Market Access
• Finance
• Ensure data accuracy, consistency, and timeliness across all reporting outputs.
• Partner with stakeholders in each function to gather requirements and translate business questions into effective, self-service reporting solutions.
• Continuously improve report performance, usability, and data models (e.g., star schema design, DAX optimisation).

Data Management & Governance

• Leverage Microsoft Fabric for data integration, pipeline management, and unified analytics across data sources.
• Maintain data quality standards, documentation, and version control for all reporting assets.
• Support the wider data governance framework, ensuring compliance with pharma industry data handling standards.

Stakeholder Engagement

• Act as a trusted analytics partner to Sales, Procurement, Supply Chain, Market Access, and Finance leadership.
• Present insights and recommendations clearly to both technical and non-technical audiences.
• Identify opportunities to streamline reporting processes and reduce manual effort across teams.

Skills & Experience

Mandatory

• Strong hands‑on experience with Power BI (data modelling, DAX, Power Query, report/dashboard design).
• Practical experience with Microsoft Fabric.
• Advanced Microsoft Excel skills.
• Experience working with cross‑functional data (Sales, Procurement, Supply Chain/Demand Planning, Market Access, Finance) pharma industry experience strongly preferred.
• Strong analytical mindset with excellent attention to detail and accuracy.
• Excellent communication skills, with the ability to present data‑driven insights to senior stakeholders.

Desirable

• Python for data manipulation, automation, or advanced analytics.
• SQL for querying and managing relational databases.
• Familiarity with pharmaceutical industry regulations, terminology, or commercial models.

Qualifications

• Bachelor's degree in Data Analytics, Finance, Business, Statistics, or a related field (or equivalent experience).
• 2+ years of experience in a data analyst / BI analyst role, ideally within pharma, life sciences, or a similarly regulated industry.