Specialist in Data Engineering

Effectively transform the business requirements into an IT solution design specification, implement data ingestion and integrations solutions on Data platforms leading to meeting the customer expectations while assuring solutions meets the , reliable, scalable and flexible.

Act as a Specialist Data Engineer for Cloud data platform and support development activities to SPINE program

Engage with internal and external IT partners and leverage both business and technical knowledge from various teams and functions to determine requirements and deliver data-driven solutions and recommendations to improve efficiency and add value., * Design and scalable Data Ingestion and integration solutions to process smooth onboarding of business data into TRD Data platform.

• Ensure data is 'fit for use' by applying business and technical rules during its life cycle
• Look for automation opportunities or accelerators where ever possible.
• Build Data pipelines using Python CI/CD and transformation work flows to process or integrate various data sets from Ingestion to consumptions layers.
• Align with Solution Architects and vendors for best practices
• Ensure Data Management practices are adopted towards data quality, Data modeling, harmonization, standards, Ontologies etc.
• Handles metadata effectively and leverage enterprise ontology management.
• Ensure FAIR data principles are adhered wherever applicable
• Perform requirement scoping assessments to determine feasibility of projects
• Highlight/identify gaps in existing functionality and review requirements with stakeholders
• Develop a comprehensive requirement specification that will determine the estimate of cost, time and resources to deploy solutions.
• Liaise with the service development team to suggest a high level functional solution
• Develop project estimates and complete financial model (costs, savings, revenue opportunities, investment horizon, etc.)
• Ensure that relevant stakeholders are involved in specification of new services and/or major upgrades to existing services.
• Ensure the overall user experience is taken into account when designing and deploying data solutions and services
• Ensure implemented solutions are according to specifications and fit for purpose Support end user training and self-service activities

• University degree in Informatics, Computer Sciences, Life Sciences or similar
• Strong demonstrated experience in Enterprise Data Engineering, designing and implementing ETL & BI data products using primarily with Python and/or R
• Experience on AWS Cloud data integrations and data management technologies, including data ingestion patterns in AWS cloud, handling Data objectives in the AWS cloud S3 & Redbrick environment
• Solid hands-on expertise with SQL including querying within relational databases including Oracle and MS SQL Server
• Good understanding of data architecture & analytics concepts including analytics, modelling, metadata, data transfer workflows, data error handling, dashboards and ETL related tools
• Proficiency in English (written & oral)

Nice to have:

• Knowledge in Agile way of working
• Experience in the pharmaceutical industry or another regulated industry

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 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 Division Operations Business Unit Universal Hierarchy Node