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