Associate Consultant -(VBA Excel- Forecasting)

IQVIA; Gurugram District, Bengaluru; Hybrid; INR 1,000,000 - 1,600,000; Full time

Job summary

IQVIA is seeking a dedicated Analyst for a hybrid role in India (Bangalore/Gurugram). The position focuses on VBA automation, advanced Excel, and forecasting within life sciences datasets, delivering impactful insights for project teams and clients.

You will leverage BI tools and AI-driven solutions to develop structured analytical approaches, manage workstreams, and drive continuous improvement while collaborating with cross-functional teams.

Qualifications

• VBA automation and advanced Excel are mandatory.
• Experience with pharmaceutical forecasting and related datasets is required.
• Ability to build and validate forecast models and BI outputs.

Responsibilities

• Life Sciences Data Analysis using datasets such as IQVIA MIDAS and SDR.
• Build and evaluate market scenarios based on competitive dynamics.
• Apply time-series analysis, regression, and forecasting methods.
• Translate business assumptions into quantifiable drivers for models.
• Produce high-quality outputs with clear, reproducible analyses.
• Engage with clients and present findings with business relevance.

Skills

Analytical thinking

Problem-solving

Communication

Client focus

Ownership

Education

Bachelor’s Degree in Life Sciences / BE / MCA

Master’s Degree in Life Sciences / MCA

Tools

VBA

Advanced MS Excel

PowerPoint

Job description

Project Title: Associate Con (VBA Excel- Forecasting)

Work Experience: 2 to 8 Years

Work location: Bangalore/ Gurugram

Work Mode: Hybrid

Must Have Skills: VBA (mandatory)Advanced MS Excel ,Pharmaceutical Forecasting and datasets

We are seeking a dedicated and forward-thinking Analyst to join our dynamic team. In this role, you will leverage VBA automation, Business Intelligence tools, and AI-driven solutions to deliver impactful insights and high-quality work products for project teams and clients. Your ability to manage complexity, adapt to evolving challenges, and drive continuous improvement will be key to success.

Key Responsibilities

• Life Sciences Data Analysis: Work extensively with datasets such as IQVIA MIDAS, market research data, and SDR to extract actionable insights.
• Competitive Market Modeling: Build and evaluate market scenarios grounded in competitive dynamics and industry trends.
• Advanced Statistical Techniques: Apply time-series analysis, regression models, and forecasting methods to support evidence-based decision-making.
• Structured Model Development: Translate business assumptions into quantifiable drivers and integrate them into robust analytical models.
• Analytical Deliverables: Produce high-quality outputs, ensuring accuracy, reproducibility, and clarity for project teams and clients.
• Problem Structuring: Deeply understand client challenges and design structured analytical approaches to address them.
• Workplan Execution: Develop clear project workplans, monitor progress, and ensure timely delivery of milestones.
• Client Engagement: Support interactions, presentations, and discussions with clients, ensuring technical clarity and business relevance.
• Team Collaboration: Contribute effectively within cross-functional teams, fostering a positive and inclusive environment.
• Innovation & Improvement: Identify opportunities to enhance methodologies, tools, and processes with innovative solutions.
• Workstream Ownership: Take full accountability for assigned analytical workstreams, ensuring zero-defect delivery.

Additional Responsibilities

• Present insights in a clear, concise, and compelling manner
• Support proposal development and contribute to business development activities
• Actively participate in learning and capability-building initiatives
• Ensure adherence to company policies and client engagement standards
• Continuous learning to meet the evolving needs of business
• Active participation in organizational and team activities
• Being compliant with organizational policies and procedures

Must-Have Competencies:

• Communication Clear, concise, and structured written and verbal communication; ability to present complex insights effectively
• Client Focus Strong understanding of client needs and commitment to delivering high-value outcomes
• Ownership Accountability for deliverables, proactive problem-solving, and commitment to quality

Required Skills:

• Good knowledge in Pharmaceutical Forecasting and datasets.
• Advanced MS Excel (mandatory) modelling, large datasets, automation
• VBA (mandatory) – automation, tool development
• Strong analytical and problem-solving skills
• Proficiency in PowerPoint (client-ready storytelling)
• Familiarity with AI concepts and applications in business contexts.

Qualification:

• Bachelor’s Degree in Life Sciences / BE / MCA
  OR
• Master’s Degree in Life Sciences / MCA