IQVIA is hiring for the position of Advanced SQL & Excel Analyst in Bengaluru, India. Candidates with a Graduate or Postgraduate Degree are eligible to apply for this position. The complete information, eligibility criteria, and requirements are provided below.
Job Description:
| Company Name | IQVIA |
| Position | Advanced SQL & Excel Analyst |
| Qualifications | Graduate or Postgraduate Degree |
| Experience | 1-3 (Years) |
| Location | Bengaluru, India |
Key Responsibilities:
- Conduct descriptive and exploratory analyses of large datasets to generate meaningful business insights.
- Prepare and deliver recurring weekly and monthly analytical reports.
- Develop, maintain, and enhance dashboards and data visualizations.
- Perform data validation and quality checks to ensure accuracy and consistency.
- Conduct ad hoc data analysis based on evolving business requirements.
- Identify opportunities to standardize, automate, and improve the efficiency of recurring quality control (QC) and reporting processes.
Principal Accountabilities:
- Support the development and delivery of recurring and ad hoc analytics for the ANZ team, ensuring accuracy, consistency, and timely completion of deliverables.
- Extract, transform, manipulate, and analyze large volumes of data using SQL and Microsoft Excel.
- Develop, refresh, and maintain dashboards and analytical reports using Power BI and/or MicroStrategy.
- Perform detailed quality checks on weekly and monthly deliverables and identify opportunities to strengthen and streamline quality control processes.
- Investigate data issues and discrepancies by analyzing underlying datasets and independently identifying potential root causes.
- Respond to ad hoc analytical queries and data requests from the broader project team.
- Collaborate with team members to understand analytical requirements and translate them into appropriate data-driven outputs.
- Recommend improvements to existing reporting, dashboard development, data transformation, and quality control processes.
- Develop a strong understanding of pharmaceutical datasets, business processes, and commercial analytics use cases.
- Support broader analytical requirements, including Patient Analytics (PA) and Sales Force Effectiveness (SFE), as the role evolves and business needs expand.
Eligibility Criteria:
- Graduate or Postgraduate degree in Technology or a related field.
- 1-3 years of relevant experience in analytics.
- Advanced proficiency in SQL and Microsoft Excel, with hands-on experience in data extraction, manipulation, and analysis.
- Experience working with Power BI and/or MicroStrategy for dashboard development and data visualization.
- Strong analytical and problem-solving skills, with the ability and willingness to work extensively with large datasets.
- Excellent attention to detail, particularly in data validation, reconciliation, and quality control.
- A curious and analytical mindset, with the ability to investigate data beyond predefined tasks and identify underlying issues.
- Strong written and verbal communication skills, with the ability to collaborate effectively within distributed teams.
- Ability to learn quickly and adapt to evolving analytical requirements.
- Experience with Python, pharmaceutical datasets, Patient Analytics, or Sales Force Effectiveness (SFE) would be an added advantage.
Technical Expertise:
- Advanced proficiency in SQL, with the ability to query, manipulate, validate, and analyze large datasets.
- Advanced proficiency in Microsoft Excel, with strong skills in data manipulation, analysis, and quality control (QC).
- Hands-on experience with Power BI or MicroStrategy, including dashboard maintenance and the development and management of recurring reporting solutions.
About Company:
IQVIA is a leading global provider of advanced analytics, technology solutions, and clinical research services to the life sciences industry. IQVIA creates intelligent connections across all aspects of healthcare through its analytics, transformative technology, big data resources and extensive domain expertise. IQVIA Connected Intelligence™ delivers powerful insights with speed and agility — enabling customers to accelerate the clinical development and commercialization of innovative medical treatments that improve healthcare outcomes for patients. With approximately 86,000 employees, IQVIA conducts operations in more than 100 countries.
How To Apply?
- First, read through all of the job details on this page.
- Scroll down and press the Click Here button.
- To be redirected to the official website, click on the apply link.
- Fill the details with the information provided.
- Before submitting the application, cross-check the information you’ve provided.
