Advanced SQL & Excel Analyst
As an Associate Consultant with IQVIA, you will be part of the Australia and New Zealand Analytics team, focusing on data analysis, transformation, and visualization. Your role will involve handling large datasets, conducting detailed quality checks, and developing dashboards using tools like Power BI or MicroStrategy. Candidates should possess strong analytical skills, a graduate/post-graduate degree in Technology, and hands-on experience in SQL and Excel. This position offers an opportunity to contribute to pharmaceutical and healthcare analytics, ensuring data accuracy and timely deliverables.
Job description
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 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.
Job details
- Published
- November 2, 2026
- Job source
- myworkdayjobs
- Workplace
- On-site · Bangalore, IN
- First seen
- November 2, 2026
Requirements
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 an ability and motivation to work extensively with large datasets. Strong attention to detail, particularly for data validation, reconciliation, and quality control. Strong written and verbal communication skills.
Skills mentioned in this job
LiftmyCV exclusive data
Analytics Services Private Limited (IN03) hiring intelligence
Analytics Services Private Limited (IN03) currently has 2 active jobs tracked by LiftmyCV. 2 new jobs in the past 7 days.
Active openings
2
Currently tracked by LiftmyCV
New in 7 days
2
2 new jobs in the past 30 days
Published salaries
—
Not published by this employer yet
Average opening age
1 days
Across 2 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • Principal Cloud Engineer
- • Senior Software Development Engineer
Frequently requested skills
As of November 17, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Analytics Services Private Limited (IN03)
Similar jobs from this company
- Business Systems AnalystAnalytics Services Private Limited (IN03)Bangalore, INOn-site
- Pharmaceutical AnalystAnalytics Services Private Limited (IN03)Gurugram, INOn-site
- Forecast Analyst 2Analytics Services Private Limited (IN03)Bangalore, INOn-site
- Clinical Advisory AnalystAnalytics Services Private Limited (IN03)Bangalore, INOn-site
- Business AnalystAnalytics Services Private Limited (IN03)Bangalore, INOn-site
- India - QA AnalystAnalytics Services Private Limited (IN03)Bangalore, INOn-site
Across the market
Similar jobs from other companies
- MIS Analyst (Excel/Advanced Excel)SS&C Fintech Svc India - AiroliNavi Mumbai, INOn-site
- Advanced Analytics Senior Analyst - Customer ExcellenceCommonwealth Bank of AustraliaSydney, AUOn-site
- Business Automation Analyst (Python, AI & Advanced Excel)RemotePro.PhTelecommute, PHRemote
- IT Analyst Advanced04D Federal Reserve Bank of ClevelandCleveland, USOn-site$111,400–$139,200 per year
- Advancement AnalystMcGill UniversityMontreal, CAOn-site$73,470–$90,840 per year
- Manager Operational Excellence, Advanced TherapiesjjSao Paulo, BROn-site
Related job searches
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.