Job
Description
Summary We are seeking a highly skilled data processing and analytics professional with solid expertise in SPSS, Power BI, Excel (Power Query), and end-to-end market research data handling. The role involves working closely with survey data, from programming understanding to analytics and dashboarding. Prior experience in pharmaceutical studies (e.g., HCP/Patient, ATU) is a strong advantage. About The Role Key Responsibilities: Handle end-to-end survey data processing – including cleaning, transforming, and tabulating data from quantitative studies. Should be able to perform data validation, data cleaning, data tabulation (table scripting), data conversion, data recording, quality checks. Understand survey structure, including programming logic, skip patterns, and question flows. Identify and resolve data quality issues through rigorous validation and QC processes. Work extensively in SPSS for syntax-based tabulation (basic syntax, C-Tables, significance testing, weighting, syntax writing, labelling, statistical modelling). Perform correlation analysis, conduct correspondence analysis, utilize factor analysis. Leverage Power BI and Excel (VBA, Power Query) to create reports, dashboards, and data visualizations for internal stakeholders. Perform advanced statistical analyses such as KDA - regression (linear & logistic), clustering, and segmentation as per project needs. Collaborate with researchers to translate study objectives into analytical outputs – KPIs, scores, summaries, and insights. Key Skills Required Good Understanding of questionnaire logic, survey flows, and programming structures. Coding of open end (OE) data. Strong understanding of survey data tabulation and expertise in SPSS. Proficiency in Market research related Statistical Analysis. Advanced skills in Power BI (DAX, Power Query, data modelling). Strong proficiency in Excel (formulas, VBA, Power Query, pivot tables, data slicing). Solid understanding of market research concepts – especially in Pharma (e.g., ATU, HCP/Patient studies, trackers, multi-brand). Analytical mindset with hands-on experience in KDA, regression, segmentation, and clustering techniques. Ability to collaborate with researchers and understand business questions and objectives. Commitment To Diversity And Inclusion Novartis is committed to building an outstanding, inclusive work environment and diverse teams' representative of the patients and communities we serve. Accessibility And Accommodation Novartis is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the recruitment process, or in order to perform the essential functions of a position, please send an e-mail to diversityandincl.india@novartis.com and let us know the nature of your request and your contact information. Please include the job requisition number in your message Why Novartis: Helping people with disease and their families takes more than innovative science. It takes a community of smart, passionate people like you. Collaborating, supporting and inspiring each other. Combining to achieve breakthroughs that change patients’ lives. Ready to create a brighter future together? https://www.novartis.com/about/strategy/people-and-culture Join our Novartis Network: Not the right Novartis role for you? Sign up to our talent community to stay connected and learn about suitable career opportunities as soon as they come up: https://talentnetwork.novartis.com/network Benefits and Rewards: Read our handbook to learn about all the ways we’ll help you thrive personally and professionally: https://www.novartis.com/careers/benefits-rewards Show more Show less
