Summary
About the Role
Extracting, transforming, creating data model and loading data from multiple sources into QlikSense / Power BI or any such reporting tool to create analytic reports/ dashboards. Understand the data flow, normalize data , perform unit testing and data validation Analyze existing reports and optimize them for enhancements / standardization Work with various enterprise data teams, data scientists, and application engineers. Propose data schema and data flow optimization for reporting performance and enhancement as needed. Coordinates with team and stakeholders for BAU (Business as usual) and Adhoc projects and manage deliverables as assigned Provide subject matter expertise, support and consultation to colleagues and team on the needs as per the defined parameters of the project Provide key business data & Insights to support and drive decision made by Senior Business Team Translate Client needs/demand by adding solutions to existing/new projects to find pragmatic insights and solutions. Manage/oversee the Client portfolios and responsible for their delivery and inculcating automations/improvisations Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client’s current standards and processes Provide update on the delivery progress to the leadership and other stakeholders Works closely with Team Lead to drive functional expertise in the local team Conducts training/mentors new joiners for assigned topics/projects
Key Performance Indicators (Indicate how performance for this role will be measured)
Business Results:
Effective collaboration with key stakeholders in driving the analytics agenda Execution of projects successfully in timely manner, within budget Timely and high quality reporting to local and global stakeholders Strong business acumen, collaborator, communication and influencing skills Working experience in a matrix environment and in multinational teams Ability to find creative ways to build team dynamics, cross-functional training, organizational efficiencies
Ideal Background (State the preferred education and experience level)
Education (minimum/desirable):
B.E/Btech/BCA/MBA/B.A.Computer Science/MCA/Mtech
Languages:
Fluent in English (spoken and written)
- 4 to 7 years of overall work experience, with atleast 4+ years’ experience in an analytics or data driven organization with a strong focus on enabling data driven decision-making
- Strong analytical expertise in the requisite or related field
- Strong Business focus and Client centric approach
- Strong and proactive and proven ability to provide insights and analytical acumen/ judgement for decision making
Novartis Capabilities ( Describe the skills, personal abilities and behaviors that are required for the effective performance of this role)
Capabilities & Expertise:
Must:
Technical Skills: Knowledge of programming languages like SQL, Python, or R for data manipulation and analysis. Expertise in data visualization tools such as Power BI and QlikSense Data Analysis and Interpretation: Proficiency in statistical analysis, data mining, and extracting data from various sources to make business decisions Database Modeling: Proficiency in database modeling is essential. This includes understanding database structures, relationships, and constraints to ensure efficient data storage and retrieval. Have a detail understanding on data models, data schemas (normalized, flat, star, snowflake, etc.) Business Intelligence: Skills in business intelligence, data-driven decision-making, data collection methods, discovery, and interpretation. Proficiency in structuring, assessing, and transforming data using core functions in Excel and Power BI Communication and Problem-Solving: Ability to communicate complex data findings to non-technical stakeholders and solve problems with communicative problem-solving skills
Preferred:
Microsoft Certification on Power BI (PL-300) Strong team player who is dynamic and result oriented Good project management skills and ability to manage multiple stakeholders effectively Pharmaceutical industry or compliance domain knowledge – desirable
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
![A female Novartis scientist wearing a white lab coat and glasses, smiles in front of laboratory equipment. A female Novartis scientist wearing a white lab coat and glasses, smiles in front of laboratory equipment.](/themes/custom/polaris/patterns/images/careers-default-image.webp)