~~~Please note: This is a temporary contractor opportunity at Novartis ~~~
Novartis touches the lives of a tenth of the world’s population. Every role here, regardless of contract type, makes an impact on human life!

Novartis US partners with external managed service provider Magnit Global to offer engaging temporary contractor opportunities like this, to those who are looking for flexibility in their career while looking to gain new skills and experiences providing services to an inclusive global medicines company. Click here to learn more about Magnit www.magnitglobal.com

Ready to work with/through Magnit at Novartis? Please read on...
Enterprise AI-Ready Data Architect / Senior Data Engineer

The Enterprise AI-Ready Data Architect / Senior Data Engineer is a hybrid role with a focus on enterprise data architecture, AI integration, and hands-on data engineering. You will design and implement AI-ready, analytics-ready data products and semantic layers (including ontologies) that enable scalable enterprise analytics and integration with AI agents and GenAI use cases. You will embed governance-by-design (quality, lineage, contracts, observability) and partner closely with business and technology stakeholders—in pharmaceutical domains.

Key Responsibilities
1) Enterprise Data Architecture (AI-Ready by Design)
• Define and deliver strategic enterprise data architectures that scale and support AI-ready outcomes.
• Design data workflows capturing as-is and to-be states for enterprise modernization.
• Establish architecture patterns for:
• Semantic Context Layer
• Data Warehouses, Data Lakehouses
• Data Catalogs and Data Marketplaces
• Event-driven and metadata-driven architectures
• Distributed data management (Data Mesh, Data Fabric, Domain-Driven Design)
• Streaming data management

2) Data Products, Semantic Products, and Master Data
• Design data products that are AI-ready and reusable across domains and use cases.
• Build and govern semantic models, metrics-first modeling, and ontologies (knowledge graph concepts).
• Deliver Master Data Management (MDM) capabilities and align master/reference data with business needs.
• Support structured and unstructured data management to enable broader AI and analytics capabilities.

3) AI Integration and GenAI Enablement
• Enable contextual intelligence and data enrichment using:
• Contextual retrieval, entity linking, enrichment using LLMs and embeddings
• Vector search, RAG pipelines, and LLM-based enrichment
• Implement graph-based approaches:
• RDF, OWL, and SPARQL querying
• Property graph / knowledge graph modeling for relationships and reasoning

4) Data Engineering Delivery
• Design and implement robust ETL/ELT pipelines and orchestration frameworks.
• Develop high-quality transformations and data modeling using:
• Advanced SQL
• Tools such as dbt, Airflow, Dataiku
• Ensure production-grade engineering practices for performance, reliability, and maintainability across pipelines.

5) Governance and Standards (Embedded)
• Implement open-source data standards across:
• Data contracts
• Data quality
• Data lineage
• Lead metadata-driven governance through metadata management, observability, and policy-aligned design.

Skills and Qualifications
Core Technical Skills
• Advanced SQL proficiency
• Data platforms and governance tooling experience (one or more):
• Snowflake, Databricks, Collibra, Salesforce
• ELT/ETL and orchestration:
• dbt, Airflow, Dataiku
• BI and reporting:
• Power BI
• Cloud platforms:
• AWS, Azure, GCP
• Modern architecture and data management:
• Data Mesh, Data Fabric, streaming, metadata-driven architecture
• Graph and semantic technologies:
• Knowledge graphs, property graphs (Neo4J), RDF/OWL, SPARQL, graph query languages

Domain and Modeling Expertise
• Experience with data modeling techniques:
• Conceptual, logical, physical modeling—preferably for the pharmaceutical industry
• Semantic modeling, ontology design, and reusable metric layers
• MDM concepts and implementation approaches

AI and GenAI Enablement Skills
• Familiarity with GenAI technologies for enhancing analysis/reporting and data enrichment
• Experience with embeddings, vector search, RAG patterns, and entity resolution/linking concepts

Nice to Have
• Experience with Palantir platform

Recommended Certifications
• CDMP (DAMA)
• TOGAF
• EDM Council frameworks:
• DCAM, CDMC, Open Knowledge Graph, Data Ethics and Responsible AI

Qualifications
• 10+ years of experience in data architecture, process automation, implementation and large-scale data engineering, ideally in pharmaceutical
• Advanced technical engineering and hands-on experience in data modeling for OLAP, workflow automation, AI/ML integration
• ETL pipeline design and development
• Bachelor’s degree in computer science, information technology, engineering, or data science
• Strong problem-solving skills and attention to detail.
• Excellent communication skills with the ability to work with senior stakeholders to translate business requirements to technical data requirements

Location: East Hanover (Onsite: 3days & 2 days remote a week)
Pay Rate:$53.57/Hour - $64.28/Hour  (W2 Only - based on Education and Experience)
Contract: 6-month 
Health, dental, vision, 401k

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?

EEO Statement:
The Novartis Group of Companies are Equal Opportunity Employers. We do not discriminate in recruitment, hiring, training, promotion or other employment practices for reasons of race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, marital or veteran status, disability, or any other legally protected status.

Accommodation: 
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to Magnit at directsourceproteam@prounlimited.com.