Consultant For Development Role (VBA and Power BI)

Iqvia Biotech; Bengaluru; On-site; INR 850,000 - 1,250,000; Full time

Job summary

Iqvia Biotech is seeking a Consultant - Profile to develop VBA and Python-based tools for forecasting, PMA, and business analytics in the life sciences sector. The role emphasizes automation, dashboards, and scalable solutions.

You will translate client requirements into technical specifications, guide analysts, produce documentation, and deliver automated dashboards while exploring new business opportunities. 4–6 years of related experience and strong Excel, VBA, and Python skills are required.

Qualifications

• Bachelor's degree in Engineering or Master's in Computer Applications.
• 4–6 years of related experience.
• Strong VBA and Python automation development experience.

Responsibilities

• Design technical solutions using VBA and Python for analytics projects.
• Analyze client requirements and translate them into technical specs.
• Provide technical direction to Analysts and Consultants and ensure best practices.
• Produce detailed documentation, workflows, and deployment guidelines.
• Deliver automated dashboards and Python-driven visualizations for clients.
• Identify opportunities for follow-on work and support business development.

Skills

VBA

Python

MS Excel

Life sciences domain

Analytics & data handling

PowerPoint

Education

Bachelor's Degree in Engineering

Master's degree in Computer Applications

Job description

Job Summary

Consultant - Profile Responsible for the development of various tools/applications, on time completion of projects or components of large, complex initiatives for clients in the life sciences sector. The role requires advanced technical expertise in VBA, Python, and related automation frameworks to design, build, and deploy analytical tools that address forecasting, PMA, and other critical business needs. In addition to delivering technical solutions, the position involves identifying and elevating potential new business opportunities and supporting the sales process.

Essential Functions

• Technical solution design: Leads or participates in teams to architect, code, and deliver consulting projects or components of larger, complex projects, with a focus on VBA and Python-based implementations.
• Client requirements analysis: Reviews and translates client requirements into technical specifications, developing cost-effective solutions that balance profitability with high client satisfaction.
• Team guidance: Provides technical direction to Analysts, Consultants, and Statistical Services, ensuring best practices in coding, automation, and data handling.
• Documentation and specifications: Produces detailed technical documentation, including code specifications, workflows, and deployment guidelines.
• Quantitative and qualitative analysis: Applies advanced programming and statistical methods to identify client issues and develop tailored solutions.
• Reporting and visualization: Designs and delivers client reports and presentations, integrating automated dashboards and Python-driven visualizations.
• Continuous improvement: Recommends enhancements and alternative technical approaches to optimize performance and scalability.
• Business development: Identifies opportunities for follow-on work and new leads by showcasing technical capabilities in automation and AI.
• Client engagement: Provides follow-up after project delivery, ensuring technical solutions are fully adopted and client satisfaction is achieved.
• Knowledge development: Proactively expands expertise in consulting methodologies, life sciences markets, and emerging technologies such as AI, while building subject matter expertise in VBA/Python automation.
• Project management: When acting as Project Manager, oversees technical timelines, code delivery milestones, and day-to-day communication with clients and team members.

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

Educational Qualification

• Bachelor's Degree in Engineering or Master's degree in Computer Applications
• 4-6 years of related experience

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 Python solution development.
• Proficiency in PowerPoint (client-ready storytelling).
• Familiarity with AI concepts and applications in business contexts.