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 alignment of all insights.

Consistent Learning & Innovation Champion:

• Stay ahead of industry trends in data engineering, cloud analytics, and AI-driven insights.
• Drive best practices in data management & recommend fresh approaches to enhance data solutions.
• Develop business knowledge and understanding of JJMT processes and capabilities specific to market, competitive, and procedure volume datasets.
• Champion automation & foster a cooperative environment conducive to innovation.
• Responsible for ensuring personal & Company compliance with all Federal, State, local & Company regulations, policies, & procedures, as well as upholding all values of the J& J Credo.

Qualifications / Requirements:

• Minimum of a Bachelor’s Degree is required, Advanced Degree strongly preferred. Statistics, Mathematics, Data Science, Computer Science or related field is required.
• At least 3-5 years of post-academic work/industry experience is required; medical technology or healthcare field is highly desired.
• Proficiency in Data Modeling (Azure, Data Factory, Databricks, Purview) is required.
• Proficiency in ETL orchestration (Azure DevOps, CI/CD Pipelines) is required.
• Proficiency in complex data transformation (SQL, Alteryx, Python, SAS, R) is required.
• Experience in data flow mapping & advanced data visualization tools (Power BI, Tableau) is required.
• Advanced Excel, PowerPoint and strong data management skills are required.
• Understanding Data Models, MDM, Data Governance frameworks, integrating diverse data sources & building self-service analytics platforms is required.
• Attention to detail and with extensive experience in aggregating data and formulating insights is required.
• Experience with Microsoft Azure, Fabric, OneLake & PowerBI is highly preferred.
• Experience in Medical Technology is highly preferred.
• Proven leadership ability & driver of cross-functional collaboration is required.
• Excellent verbal & written communication skills, particularly in presenting technical information to non-technical stakeholders, is required.
• Effective project management skills with experience managing multiple projects simultaneously is required.
• Strong intuition to proactively identify current problems & gaps to effectively minimize future maintenance is required.
• Results oriented, a strong demonstration of translating business strategy into business insights is highly preferred.
• Experience with Commercial systems (Compensation, Sales Analytics, Contracting systems) is preferred.

Johnson & Johnson is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, protected veteran status or other characteristics protected by federal, state or local law. We actively seek qualified candidates who are protected veterans and individuals with disabilities as defined under VEVRAA and Section 503 of the Rehabilitation Act.

Johnson & Johnson is committed to providing an interview process that is inclusive of our applicants’ needs. If you are an individual with a disability and would like to request an accommodation, please contact us via https: //www.jnj.com/contact-us/careers or contact AskGS to be directed to your accommodation resource.

#LI-Hybrid

The anticipated base pay range for this position is:

The base pay range for this position is $91, 000 to $147, 200.

Additional Description for Pay Transparency:

Subject to the terms of their respective plans, employees and/or eligible dependents are eligible to participate in the following Company sponsored employee benefit programs: medical, dental, vision, life insurance, short- and long-term disability, business accident insurance, and group legal insurance. Subject to the terms of their respective plans, employees are eligible to participate in the Company’s consolidated retirement plan (pension) and savings plan (401(k)). Subject to the terms of their respective policies and date of hire, Employees are eligible for the following time off benefits: Vacation –120 hours per calendar year Sick time - 40 hours per calendar year; for employees who reside in the State of Washington –56 hours per calendar year Holiday pay, including Floating Holidays –13 days per calendar year Work, Personal and Family Time - up to 40 hours per calendar year Parental Leave – 480 hours within one year of the birth/adoption/foster care of a child Condolence Leave – 30 days for an immediate family member: 5 days for an extended family member Caregiver Leave – 10 days Volunteer Leave – 4 days Military Spouse Time-Off – 80 hours Additional information can be found through the link below. https: //www.careers.jnj.com/employee-benefits