Job Description

Summary This role will play a critical role in supporting Novartis internal stakeholders by delivering high-quality, data-driven insights across complex analytical projects. This role requires hands-on experience with real-world patient-level data (e.g., claims, EHR) and a strong command of data processing tools such as SQL and DataIKU. You will be responsible for managing and transforming large, diverse datasets--including LAAD, Xponent, and SMART--into actionable insights that inform strategic decisions.
This role will collaborate closely with cross-functional teams to define data specifications, build analytical frameworks, and contribute to the development of advanced analytics and APLD methodologies. A key part of your responsibility will be to drive standardization across brand reporting and maintain strong relationships with key stakeholders. This role demands a proactive mindset, strong communication skills, and the ability to thrive in a fast-paced, global environment.

Key responsibilities

• Provide analytics support to Novartis internal customers on various high complexity analytical reports.
• Working knowledge of multiple datasets e.g. LAAD, Xponent, SMART etc. and managing and organizing data sets from databases to find patterns and trends in data.
• Transforming these complex and granular data into actionable insights.
• Putting together specifications to extract/transform data into required formats for different analytical elements using SQL/DSS or other data processing tools.
• Require experience in quantitative analysis with a demonstrated focus in analytics, and experience with coding languages (SQL OR Python) to query and extract data. Also, experience with BI tools, working with very large data sets is a plus.
• Create the foundation for more sophisticated approaches to APLD analysis and advanced analytics wherever it is required and beneficial.
• Establish and maintain positive relationships with key functional stakeholders.
• Takes initiative to drive standardization of reports across brands.

Essential Requirements:

• Masters/ Bachelor's in technology/ life-sciences/ management
• Minimum of 3+ years' experience processing and analyzing real world patient level data (Claims data/EHR etc.,).
• Expertise in SQL, DataIKU and/or other data processing tool. Knowledge of Statistical modeling or ML is a plus.
• Understanding of healthcare terminology and real-world patient level data
• Good communication and interpersonal skills. Conceptual, analytical & tactical thinking, strategic thought process

Ability to multi-task, work in a demanding global team environment, work under tight deadlines. Develop and maintain strong individual and team performance.
Skills Desired Advertising Campaigns, Alteryx, Analytical Thinking, Brand Awareness, Business Networking, Curiosity, Digital Marketing, Email Marketing, Marketing Communications, Marketing Plans, Marketing Strategy, Media Campaigns, Process Documentation, Strategic Marketing