Lead Data Insights Engineer - MedTech Surgery

At Johnson & Johnson, we believe health is everything.

Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions are personal. Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow, and profoundly impact health for humanity. Learn more at https://www.jnj.com

Job Function:
Data Analytics & Computational Sciences

Job Sub Function:
Data Engineering

Job Category:
Scientific/Technology

All Job Posting Locations:
Cincinnati, Ohio, United States of America, Raritan, New Jersey, United States of America

Job Description:

We are searching for the best talent for a Lead Data Insights Engineer.  The preferred location for this role is Raritan, NJ however candidates within a commutable distance of Cincinnati, OH will also be considered.  This role will work a Flex/Hybrid schedule with 3 days per week in office.  There is NO remote option.  Please Note:  Relocation Assistance is not available for this role.

Purpose: The Lead Data Insights Engineer will play a pivotal role & be responsible for architecting, developing, & maintaining the Gold Layer ETL processes that transform raw data into actionable business insights within our intelligence ecosystem.

This role orchestrates complex end-to-end data pipelines, ensuring seamless integration between upstream Bronze/Silver layers & downstream analytics, while enforcing data governance, lineage, & scalability.

The engineer will design & optimize business bays, defining data sources, transformation rules, & dynamic aggregation logic to support granular reporting.

A key focus is collaborating with the “Center” Data Strategy team to align upstream processes, minimize technical debt, & future-proof.

Additionally, the role will partner with business stakeholders (Marketing, Sales, Key Account Management) to co-prioritize data needs, build insights, & drive adoption of self-service analytics platforms.

The engineer will partner with Data Science to innovate with AI/ML automation for data governance, work closely with IT to deploy scalable solutions, & ensure compliance with regulatory standards.

By staying ahead of cloud analytics & AI trends, this role champions automation, eliminates manual inefficiencies, & enhances the intelligence ecosystem’s performance, ultimately enabling strategy & insights-driven decision making & commercial execution across the organization.

You will be responsible for:

Data Management & ETL Orchestration:


* Direct & innovate the end-to-end orchestration of the Gold layer ETL processes, owning complete Data Cleansing, Validation, Standardization, Enrichment, Aggregation & Formatting, ensuring performance, security, & scalability.


* Build & maintain individual business bays with necessary...