Associate Consultant - Data Analytics and Reporting

IQVIA Inc

Bengaluru

On-site

INR 800,000 - 1,200,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

IQVIA is seeking an Advanced SQL & Excel Analyst to support the ANZ Analytics team in delivering recurring and ad hoc analytics, reporting, and dashboarding. You will work with large datasets, transform data, and build dashboards using Power BI or MicroStrategy, while ensuring data quality and timely delivery.

The role emphasizes hands-on analysis, data validation, and collaboration with distributed teams, with opportunities to grow into broader analytics areas like Patient Analytics and SFE.

Qualifications

  • Graduate/PG in Technology with 1–3 years analytics exp.
  • Strong SQL and Excel skills.
  • Experience with Power BI or MicroStrategy.
  • Analytical mindset with attention to detail.
  • Ability to work with large datasets and collaborate in distributed teams.

Responsibilities

  • Support the ANZ analytics team with recurring and ad hoc analytics and dashboards.
  • Extract, transform, and analyze large data using SQL and Excel.
  • Develop and maintain dashboards using Power BI and MicroStrategy.
  • Perform quality checks on weekly/monthly deliverables to improve QC processes.
  • Investigate data issues and root causes; respond to ad hoc data requests.
  • Collaborate with team to translate requirements into outputs.

Skills

Advanced SQL
Advanced Excel
Power BI
MicroStrategy
Python (advantage)
Data analysis

Education

Graduate/PG in Technology
1–3 years analytics experience

Tools

Power BI
MicroStrategy

Job description

Advanced SQL & Excel Analyst

The Associate Consultant will support the Australia and New Zealand Analytics team in delivering recurring and ad hoc analytics, reporting, and dashboarding requirements. The role will initially focus on hands-on data analysis, data transformation, visualization, quality control, and responding to analytical requests from the team, with scope expanding over time. The ideal candidate will be analytically curious, highly detail-oriented, and comfortable working with large and complex datasets, with a strong motivation to develop expertise in pharmaceutical and healthcare analytics.

Functional Expertise

The role requires strong analytical aptitude and the ability to explore data, identify patterns or inconsistencies, and translate analytical requirements into accurate and efficient outputs.

  • Primary: Descriptive and exploratory analysis of large datasets
  • Recurring weekly/monthly analytics and reporting
  • Dashboard development, maintenance, and visualization
  • Data validation and quality control
  • Ad hoc data analysis based on evolving business requirements
  • Identifying opportunities to standardize, automate, and improve the efficiency of recurring QC and reporting processes
Good to have / Future development
  • Exposure to pharmaceutical or healthcare analytics
  • Patient Analytics (PA)
  • Sales Force Effectiveness (SFE), including segmentation and targeting
  • Interest in developing broader analytics capabilities as the scope of work expands
Principal Accountabilities
  • Support the development and delivery of recurring and ad hoc analytics for the ANZ team, ensuring accuracy, consistency, and timely delivery
  • Extract, transform, manipulate, and analyze large volumes of data using SQL and Excel
  • Develop, refresh, and maintain dashboards and analytical outputs using Power BI and/or MicroStrategy
  • Perform detailed quality checks on weekly and monthly deliverables and identify opportunities to make QC processes more robust and efficient
  • Investigate data issues and discrepancies by independently digging into underlying datasets and identifying potential root causes
  • Respond to ad hoc analytical questions and data requests from the broader project team
  • Collaborate effectively with team members to understand analytical requirements and translate them into appropriate outputs
  • Contribute ideas for improving existing reporting, dashboarding, data transformation, and QC processes
  • Build knowledge of pharmaceutical datasets, business processes, and commercial analytics use cases over time
  • As the role evolves, support broader analytical requirements including Patient Analytics and Sales Force Effectiveness, depending on business needs
Education and Skill Required
  • Graduate/Post-graduate degree in Technology
  • 1–3 years of relevant analytics experience
  • Hands on experience in advanced proficiency in SQL and Excel
  • Experience with Power BI and/or MicroStrategy
  • Strong analytical and problem-solving skills, with the ability and motivation to work extensively with large datasets
  • Strong attention to detail, particularly for data validation, reconciliation, and quality control
  • Curious and analytical mindset with an ability to investigate data beyond predefined tasks
  • Strong written and verbal communication skills and ability to collaborate effectively within distributed teams
  • Ability to learn quickly and adapt to changing analytical requirements
  • Experience with Python, pharmaceutical datasets, Patient Analytics, or SFE would be an advantage
Technical Expertise: Mandatory
  • Advanced SQL, including the ability to query, manipulate, validate, and analyze large datasets
  • Advanced Microsoft Excel, including strong data manipulation, analytical, and QC capabilities
  • Hands-on experience with Power BI or MicroStrategy and maintenance of dashboards and recurring reporting solutions

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide.

Learn more at https://jobs.iqvia.com

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.

Experience Level Mid Level

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Advanced SQL & Excel Analyst
Advanced SQL & Excel Analyst

IQVIA Inc • Bengaluru

On-site
INR 5,676,000 - 8,515,000
Senior Consultant US Pharma / Healthcare Analytics
Senior Consultant US Pharma / Healthcare Analytics

3across • Hyderabad

On-site
INR 1,800,000 - 2,700,000
Associate Director - Database Management System
Associate Director - Database Management System

IQVIA Inc • Bengaluru

On-site
INR 4,500,000 - 8,000,000
Associate Data Analytics
Associate Data Analytics

Amgen Inc. • India

On-site
INR 1,500,000 - 3,000,000
Analyst – Reporting & Analytics
Analyst – Reporting & Analytics

PharmSight Inc • Gurgaon

Remote
INR 600,000 - 1,000,000
Flexible work environment
Career growth opportunities
Senior Analyst, Data Scientist
Senior Analyst, Data Scientist

putnamassociatesllc • Gurugram District

Hybrid
INR 1,200,000 - 2,000,000
Associate Data Analytics
Associate Data Analytics

Mployee.me • Hyderabad

On-site
INR 1,500,000 - 2,300,000
Senior Analyst - Pharmaceutical Commercial Analytics
Senior Analyst - Pharmaceutical Commercial Analytics

Astrazeneca India Private Limited • Chennai

On-site
INR 1,800,000 - 3,000,000
Associate / Associate Consultant, EMEA Strategy Consulting
Associate / Associate Consultant, EMEA Strategy Consulting

IQVIA Inc • Gurugram District

On-site
INR 600,000 - 1,000,000
Career development opportunities
Collaborative work environment
Direct impact on healthcare solutions
Executive – Data Analyst
Executive – Data Analyst

CorroHealth, Inc. • Uttar Pradesh

On-site
INR 500,000 - 900,000