Advanced SQL & Excel Analyst
Iqvia Biotech · Bengaluru · onsite · Posted 1d ago
Undisclosed1–3 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Summary
Functional Expertise
Good to have / Future development
Principal Accountabilities
Education and Skill Required
Technical Expertise
Mandatory
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
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.
- 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
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
Dashboard Developmentclinical researchdata manipulationadvanced sqldata transformationBusiness RequirementsDashboardDashboardingAnalyticsCommercial AnalyticsHealthcareCommunication Skillsdata analysisData Validation
About IQVIA Biotech
Iqvia Biotech
Durham
CA
About
IQVIA Biotech delivers specialized clinical development services, facilitating drug development for the pharmaceutical and biotech sectors.
Industries
BiotechnologyClinical TrialsHealth CareMedicalPharmaceutical
Employee ratings
23 reviews
3.4/ 5
Culture
3.3
Career growth
2.8
Work-life
3.1
Employees rate it well for
Work Life Balance7Work Culture5Senior Management4
Find them on