- Utilise advanced Excel functions to conduct analysis of large datasets. Ensure the integrity of databases, implementing robust measures for data accuracy and reliability.
- Develop and execute data validation processes to uphold the accuracy and dependability of data.
- Utilise diverse data analysis tools and systems to extract, transform, and load data for reporting and analytical purposes. Create trackers and provide insights on pricing performance.
- Understand the product portfolio of Novo Nordisk and competitors. Develop and design solutions to meet project requirements, potentially in the form of an Excel-based model/dashboard, report, or presentation.
- Maintain regular communication with internal and external stakeholders to understand business needs and deliver outcomes. Be the technical expert of the team and the point of contact for all such queries. Support ad-hoc tasks/projects.
Qualifications
We are looking for a candidate with the following qualifications:
- A Master’s Degree (preferably within a quantitative/analytical/IT discipline) from a well-recognised institute.
- 4-6 years of experience working in a technical/analytical data management role, preferably in the Pharma industry.
- Proficiency in advanced Excel functionalities for data analysis and reporting.
- Strong understanding of database management and proficient in data validation techniques.
- Essential SQL skills – ability to perform queries, filtering, and data extraction.
- Essential VBA skills – ability to understand, maintain, and create low-to-medium complexity macros.
- Proficient in data visualisation using Power BI & Excel. Good academic track records and grades.
- Ability to translate business problems into the most efficient and effective analysis plan; execute the analysis including data pull, data preparation, data validation, and convert them to insights.
- Ability to collaborate and communicate with different stakeholders, primarily with internal stakeholders, customers, vendors, consultants, and project teams.
- Strong strategic and analytical capabilities, with demonstrated experience in analysing complex situations, collecting data, and effectively synthesising the analytics/data.
- Solid project management and relationship-building skills to overcome complex and multidimensional business challenges.