Staff Data Engineer

Johnson & Johnson • West Chester, MA

5d • Onsite

About The Position

Orthopedics Supply Chain is recruiting for a Staff Data Engineer. 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. This role will play a pivotal technical leadership role in building the modern data foundation that powers digital products across the Orthopaedics Supply Chain. You will help design lakehouse architecture on Databricks and AWS while enabling governed, reusable, business-ready data products for analytics, reporting, AI, and operational decision-making. The role suits an expert professional who can lead across solution architecture, pipeline design, engineering standards, and cross-team delivery. You will work closely with Product Owners, business teams, data engineers, machine learning teams, and external delivery partners to turn business problems into practical technical solutions and executable plans. You will also help advance modern engineering practices, including AI-assisted development, reusable patterns, data quality automation, and observability. This is an opportunity to make a meaningful impact if hands-on architecture and solving complex data challenges at scale are what energize you. Johnson & Johnson announced plans to separate its Orthopedics business into a standalone company, operating as DePuy Synthes. The planned separation is anticipated to be completed within 18 to 24 months. Should you accept this position, it is anticipated that, following the transaction, you would join DePuy Synthes, and your employment would be governed by its employment processes, programs, policies, and benefit plans.

Requirements

• A minimum of a Bachelor’s degree and/or equivalent University degree is required; a focused degree in in Computer Science, Engineering, Applied Mathematics, Information Systems, or a related field preferred.
• Minimum four (4) years of relevant professional work experience.
• Experience in data engineering, data architecture, or platform engineering (consistent with J&J leveling).
• Strong hands-on experience across Databricks, Apache Spark, PySpark, Spark SQL, Python, SQL, and Delta Lake.
• Strong experience with AWS cloud data services; Azure experience desirable.
• Proven expertise in modern data and lakehouse architecture, enterprise data platforms, dimensional modeling, and pipeline design.
• Experience designing batch, real-time, and event-based processing for enterprise-scale workloads.
• Experience with CI/CD, Git-based development, automated testing, deployment patterns, and production support.
• Proven skill in converting business needs into architecture, user stories, and executable delivery plans.
• Demonstrated ability to coordinate distributed engineering teams, contractors, and vendors.
• Excellent communication, facilitation, and relationship-building skills across technical, product, and business audiences.
• Knowledge of Power BI, Tableau, or enterprise BI platforms.
• Knowledge of workflow automation tools (e.g., Power Automate, Blue Prism, UiPath, or Amazon Quick Flows).

Nice To Haves

• Experience supporting Agile product teams and mentoring engineers in fast-paced environments.
• Familiarity with end-to-end supply chain domains (planning, manufacturing, procurement, distribution, logistics) within MedTech or a similar regulated industry.
• Knowledge of enterprise systems of record such as SAP, ERP, MES, PLM, and CRM, including legacy or fragmented data environments.
• Experience with Unity Catalog, data governance, lineage, metadata management, and observability frameworks.
• Hands-on experience with modern Databricks capabilities (Lakeflow, Spark Declarative Pipelines, Mosaic AI, AI/BI Genie) and AI-assisted development tools such as GitHub Copilot, Claude Code, Amazon Q Developer, or Cursor.
• Experience with dbt, Airflow, Terraform, Databricks Asset Bundles, GitHub Actions, or equivalent infrastructure-as-code tooling, and with designing AI-ready data foundations (semantic layers, knowledge graphs, governed data products) for advanced analytics teams.

Responsibilities

• Provide technical leadership for the Data Foundation initiative to modernize the enterprise data ecosystem through lakehouse architecture and cloud platform capabilities.
• Design complex data pipelines, integration patterns, and architecture using Databricks, AWS, Python, SQL, Spark, and Delta Lake.
• Turn business requirements and technical challenges into architecture decisions, implementation plans, and reusable patterns.
• Develop blueprints for batch, streaming, and event-driven pipelines that support analytics, BI, AI/ML, and digital product use cases.
• Partner with Product Owners, Supply Chain teams, data governance, AI and ML groups, and IT partners to align delivery with measurable business outcomes.
• Lead architecture and design discussions, ensuring solutions meet standards for scalability, reliability, quality, security, maintainability, and cost efficiency.
• Break down large initiatives into work packages, user stories, and acceptance criteria for internal engineers and external contractors.
• Coordinate contractor and vendor execution by assigning work, reviewing deliverables, and providing technical direction.
• Set clear standards for data modeling, modularity, reuse, automated testing, CI/CD, data quality, observability, lineage, and operational support.
• Lead hands-on development and technical reviews with Databricks, PySpark, Spark SQL, Python, SQL, dbt, and orchestration tools like Airflow.
• Champion responsible adoption of AI-assisted engineering to improve quality, documentation, testing, and delivery velocity.
• Mentor engineers and contractors through design and code reviews and architecture guidance (no direct people-management responsibility).
• Contribute to technical governance forums, architecture standards, and operating-model practices that improve consistency and reuse.

Benefits

• Employees are eligible to participate in the Company’s consolidated retirement plan (pension) and savings plan (401(k)).
• This position is eligible to participate in the Company’s long-term incentive program.
• Vacation –120 hours per calendar year
• Sick time - 40 hours per calendar year; for employees who reside in the State of Colorado –48 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
• Bereavement Leave – 240 hours for an immediate family member: 40 hours for an extended family member per calendar year
• Caregiver Leave – 80 hours in a 52-week rolling period
• Volunteer Leave – 32 hours per calendar year
• Military Spouse Time-Off – 80 hours per calendar year

What This Job Offers

• Job Type: Full-time
• Career Level: Senior