Lead the design and implementation of data engineering solutions, focusing on data ingestion and quality while collaborating with internal and external partners.
Job Description Summary
Lead the transformation of business requirements into IT solution design specifications, implementing data ingestion and integration solutions on data platforms to meet customer expectations. Ensure solutions are reliable, scalable, and flexible. Act as an Associate Director Engineering for cloud data platforms, supporting development activities for the SPINE program. Engage with internal and external IT partners, leveraging 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.
Job Description
- 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
Essential Requirements:
- University degree in Informatics, Computer Sciences, Life Sciences or similar
- 14+ years of relevant 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
Commitment to Diversity & Inclusion:
We are committed to building an outstanding, inclusive work environment and diverse teams representative of the patients and communities we serve.
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
Skills Desired
Budget Management, Business Acumen, Influencing Skills, Performance Management, Risk Management, Service Delivery Management, Strategic Planning, Waterfall ModelTop Skills
AWS
Ms Sql Server
Oracle
Python
R
SQL
Similar Jobs
Biotech • Pharmaceutical
Manage resource allocation and ensure compliance in clinical trials. Oversee project management, documentation, and maintain adherence to quality standards.
Biotech • Pharmaceutical
The ITOT Senior Specialist Manufacturing Services Automation Engineer will design and integrate IT/OT solutions, provide operational support, and drive improvements in manufacturing environments to enhance productivity and compliance.
Top Skills:
HistorianMesMqttOpcScada
Biotech • Pharmaceutical
Lead the technology transformation at Novartis by shaping change portfolios, developing technical product roadmaps, and ensuring delivery across complex environments.
Top Skills:
AgileScrum
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.
