Job Description

Summary Novartis is looking for a Associate Analyst - Analytics for its International BA team. The Associate Analyst will be responsible for providing analytical support on high complexity reports to internal customers, contributing to business decision-making by analysing commercial analytics data and identifying trends. The role includes working in commercial analytics projects, maintaining the existing reports and supporting the development of reporting platforms based on business inputs. The Associate analyst will work collaboratively with various cross-functional teams to meet business requirements. They will also participate in performance tracking, knowledge sharing, and support day-to-day business-related tasks. The role requires being detail-oriented, having a knack for interpreting data trends and insights, and being adept at collaborative work.

• Possess strong analytical skills to collect, organize, analyse, and disseminate significant amounts of information
• Interpret granular data, analyse results and derive actionable insights. Clearly communicate data-driven insights to stakeholders that may assist them in decision-making processes
• Support in developing, maintaining, and improving insightful reporting solutions and dashboards
• Support the engagement lead in managing and organizing data sets from databases to find patterns and trends in data while ensuring data integrity and accuracy
• Use data analytics to understand customer behaviour and improve marketing effectiveness

• Support the leads in standardization of reports across brands
• Establish and maintain positive relationships with key stakeholders and understand their perspectives
• Stay informed on industry trends and developments to advise management on strategies for business growth
• Build and maintain standard operating procedures (SOPs), quality checklists to enable excellent quality outputs and knowledge repositories

Essential Requirements:

• MBA with Graduate / Postgraduate in Medicine (MD/MBBS/BDS) Pharmacy / Life Sciences/ bachelors degree in marketing, Statistics, or a related field.
• Data analytics experience. Experience in a market research firm or pharmaceutical company will be preferred
• 0 - 2 years of overall experience in data modelling, SQL and robust technical problem-solving skills.
• Expertise in MS Excel, SQL, Power Query, and ETL tools like Alteryx, DataIKU. Knowledge of Statistical modelling or ML is preferred
• Experience working with Power BI
• Proficiency in statistical analysis tools (R, Python, or similar) will be preferred
• High agility to work across projects, dataset and technologies
• Ability to operate optimally in an international matrix environment. Strong teammate who is dynamic and result oriented
• Understanding of healthcare terminology and real-world patient level data will be desirable
• Ability to multi-task, work in a demanding global team environment, work under tight deadlines. Develop and maintain strong individual and team performance.

Skills:

• SQL, Advanced Excel & Power point
• ETL tools (Alteryx, DataIKU)
• Power BI
• Good to have knowledge of Python and/or Snowflake.
• Knowledge of Statistical Analysis, AI/ML will be desirable
• Process Documentation

Skills Desired Administrative Assistance, Adobe InDesign, Advertising Campaigns, Business Networking, Communication Skills, Curiosity, Customer Retention, Digital Marketing, Email Marketing, Marketing Collateral, Marketing Communications, Marketing Plans, Mobile Marketing, Press Releases, Social Media, Sop (Standard Operating Procedure), Trade Shows

Novartis