Analyst - Data Engineering

Summary

Coordinate and execute activities within the Master Data team, ensuring accurate setup and maintenance of master data across enterprise systems in alignment with established quality standards. This role plays a key part in safeguarding data integrity, consistency, and availability to support informed decision-making. Additionally, the position involves leading internal meetings, driving continuous improvement initiatives, and preparing presentations that support the organization’s data strategy.

About The Role

Key Responsibilities:

• Ensure the quality and accuracy of master data across Enterprise Resource Planning software, and in house planning software master data.
• Design, maintain, and update Power BI dashboards for continuous data quality monitoring.
• Coordinate data migration activities, including the preparation of datasets aligned with defined requirements.
• Ensure data consistency across systems and resolve discrepancies when identified.
• Support data analysis, cleansing, correction, and transformation to enhance usability and reliability.
• Document master data across systems in a structured manner to ensure traceability and clarity.
  
  

Essential Requirements

• Python: for process automation, data transformation, and advanced analytics.
• Power BI: for building interactive dashboards and monitoring data quality.
• Alteryx: for no-code ETL workflows and data preparation.
• SQL: for querying, extracting, and validating data from structured databases.
• Excel: for exploratory analysis, quick validations, and data documentation.
• Miro: for visual collaboration, process mapping, and activity planning.
  
  

Technical Competencies

• Data Engineering: Ability to design, build, and maintain efficient and scalable data pipelines.
• ETL Processes: Proficiency in extracting, transforming, and loading data from multiple sources.
• Data Analysis: Skill in interpreting data, identifying patterns, and generating insights to support decision-making.
• Reporting: Competence in creating clear, visual, and results-oriented reports.
• Analytical Thinking: Structured approach to solving complex problems through data analysis.
• Artificial Intelligence Application: Experience using AI for building intelligent agents and performing advanced data analysis.
  
  

Soft Skills

• Effective Communication: Ability to clearly convey ideas and adapt messaging to both technical and non-technical audiences.
• Team Collaboration: Willingness to work cross-functionally with various teams and departments.
• Proactivity: Initiative to identify improvement opportunities and act independently.
• Time Management: Strong organizational skills to prioritize tasks and meet tight deadlines.
• Results Orientation: Focus on delivering high-impact solutions aligned with business goals.
  
  

Desirable Requirements

Education: Graduation in Engineering or relevant degree

Languages: English

Experience: 5+ years

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

---