Advanced SQL & Excel Analyst

Overview

Support the Australia and New Zealand Analytics team in delivering recurring and ad hoc analytics, reporting, and dashboarding, starting with hands-on data analysis, transformation, visualization and quality control.

What you'll do

• 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

What you'll need

• 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

Nice to have

• Exposure to pharmaceutical or healthcare analytics
• Interest in developing broader analytics capabilities as the scope of work expands
• Experience with Python, pharmaceutical datasets, Patient Analytics, or SFE
• Sales Force Effectiveness (SFE) experience, including segmentation and targeting
• Patient Analytics (PA) experience

Details

• Location: Bangalore, India