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 data tables & business rules, logic, & mappings to transform raw data into dynamic insights.
• Apply advanced data management techniques to aggregate & disaggregate insights dynamically, facilitating where possible granular levels of reporting.
• Clearly document & organize data flow mapping, ensuring data lineage, storage, process, dependencies, integrity & governance are maintained throughout the transformation process.

Build, Foster & Maintain Key Partnerships:

• Collaborate with the “Center” Data Strategy to identify data gaps, understand existing Enterprise Data Lakes’ Bronze & Silver layer ETL processes & leverage extractions from upstream data tables, proactively future proofing to minimize maintenance efforts.
• Engage the Business (Marketing, Sales, Key Account Management, Digital) to prioritize & define sources, requirements, rules, logic, & mapping for transforming raw data into dynamic insights, while providing fresh perspective of what else is possible.
• Innovate with Data Science in ways to automate Data Governance of Business Mappings through AI/ML.
• Co-shape with IT loading requirements for dynamic insights into a self-service platform & Commercial Intelligence Database.
• Drive user acceptance & adoption in the utilization of the source of truth for Commercial Intelligence, Strategic Targeting, & Data Products Ecosystem (analytics, dashboards, & reports).
• Communicate & cooperate with Legal, Privacy, & Compliance partners in align