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. 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:
