Summary
Collaborate closely with Finance associates to drive data-informed decision-making through Operational Excellence initiatives. Strong expertise in building scalable data transformation workflows and delivering actionable insights through advanced analytics and visualization tools. This role focuses on optimizing data pipelines, leveraging modern platforms, and enabling business intelligence through interactive dashboards.
About the Role
Key Requirements:
- Design and optimize ETL workflows for extracting, transforming, and loading data from diverse sources, ensuring scalability and efficiency.
- Leverage SAP Analytics Cloud (SAC) to connect to multiple data sources, perform advanced transformations, and create interactive dashboards that deliver actionable insights.
- Demonstrate strong storytelling capabilities within SAC, using visualizations and narratives to generate key business insights and support strategic decisions.
- Utilize Alteryx Designer & Server / Dataiku to automate data preparation, cleansing, enrichment, and transformation techniques for high-quality datasets.
- Develop and maintain interactive dashboards and reports using Power BI to deliver actionable insights beyond static spreadsheets.
- Write and optimize complex SQL queries (Oracle, Snowflake) involving multi-table joins and advanced logic for efficient data retrieval and performance tuning.
- Implement robust data models and pipelines to support analytics and business intelligence initiatives.
- Collaborate with cross-functional teams to understand business requirements and translate them into scalable data solutions.
- Continuously improve data workflows and reporting processes to enhance reliability, reduce manual effort, and enable real-time decision-making.
- Apply analytical and creative problem-solving skills to design innovative solutions for complex data challenges.
Essential Requirements:
- Bachelors / Masters in Technology / MBA (university degree required)
- 2-4 years relevant experience in SAC/Power BI(or any other BI tool)/Alteryx/Dataiku
Desirable Requirements:
- Timely reporting to stakeholders
- Innovative ideas or solutions
- Active participation in team initiatives
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
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
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 [email protected] and let us know the nature of your request and your contact information. Please include the job requisition number in your message.
Novartis is committed to building an outstanding, inclusive work environment and diverse teams' representative of the patients and communities we serve.
