Back to list

Vacancy description

Advanced SQL & Excel Analyst in Bangalore, भारत

IQVIA

  • Full-timeStandard weekly hours

Bangalore, भारत

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.

Similar vacancies

More like this role

... support broader team requirements Requirements - Graduate or postgraduate degree in technology or related field - 1–3 years of relevant analytics experience - Advanced SQL proficiency for querying and data manipulation - Advanced Excel skills including data analysis and quality control - Hands-on experience with Power BI or ...

Bangalore, भारत

  • Full-time
... 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, ...

Bangalore, भारत

  • Hybrid
  • On-site
  • Full-time
  • Data Analytics

$27 USD

... science expertise with core consulting expertise to augment engagement teams with analytical firepower to deliver outstanding results. Role Summary: The Business Analyst will support the analytics team by building high-quality SQL queries, Excel models, and data-driven insights. This role focuses on strong analytical thinking, ...

Hyderabad, भारत

  • Full-time
  • Accounting
  • Data Analytics
... alternative-investment performance measures, including:Time-Weighted Return (TWR)Money-Weighted Return (MWR)Internal Rate of Return (IRR)Multiple on… What you need - SQL - Excel - Reporting - Analytics - Power BI - Dashboarding Good to have - CFA - ETL - Python - Power Query - LLMs - Reconciliation Job details - Location: Hyderabad ...

Hyderabad, भारत

EdgeQ Technologies Private Limited

Data Analyst

  • Full-time
  • Data Analytics
... Bachelor's degree in Computer Science, Information Technology, Statistics, Mathematics, Business Analytics, or a related field. - 1–3 years of experience as a Data Analyst or in a related role. - Strong knowledge of SQL and database querying. - Hands‑on experience with Microsoft Excel and Tableau. - Excellent communication and ...

भारत

  • Data Analytics
Salary: 35 to 60 LPAExp: 8 to 15 yearsLocation: GurgaonNotice: Immediate only..!!Key Skills: SQL, Advance SQL, BI tools, ETLRoles and Responsibilities:- Extract, manipulate, and analyze large datasets from various sources such as Hive, SQL databases, and BI tools.- Develop and maintain dashboards using Tableau to provide ...

Noida, भारत

Acurus Solutions Private Limited

Data Analyst

  • Data Analytics
Job Opening – Data Analyst Department: Data & Analytics Role: Data Analyst Job Overview We are looking for a detail-oriented Data Analyst with strong Excel skills and basic to intermediate knowledge of MySQL. The candidate should have the ability to work with large datasets, perform data analysis, generate reports, and ...

Royapettah, भारत

Pathfinder Business Analysis Private Limited

Data Analyst

  • Data Analytics
... Strong SQL skills with the ability to perform building queries and data manipulation - Knowledge in Python libraries and automation workflow. - Knowledge in MS- Excel such as (VLOOKUP, Pivot tables) - Advanced excel, MS - Access. - Good in data analytics skills and quality audits. - Experience in US Property tax/Real Estate ...

Coimbatore, भारत

Edgeverve Systems Limited

Infosys - Data Analyst - SQL/Python

  • Data Analytics
... expertise in AI and machine learning to transform complex datasets into actionable business https://jobeax.com/link/ru5GUQcYM0jBK7Pi candidate will combine advanced analytics, statistical techniques, and predictive modelling to support data-driven decision-making and business https://jobeax.com/link/JQlli5hw40FS19iT Responsibilities ...

Chennai, भारत

GSPANN Technologies Inc.

GSPANN - Senior Data Analyst - SQL

  • Data Analytics
About the Role : We are looking for an experienced Senior Data Analyst with strong expertise in SQL, Power BI, data modelling, and business intelligence. The ideal candidate will be responsible for analysing complex datasets, developing interactive dashboards, building reliable reporting solutions, and translating business ...

Gurgaon, भारत