Johnson and Johnson

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:

Alajuela, Costa Rica

Job Description:

Johnson & Johnson is hiring for a Principal Data Engineer – Supply Chain, Manufacturing and Finance to join our team located in Shockwave Medical Costa Rica.

Fueled by innovation at the intersection of biology and technology, we’re developing the next generation of smarter, less invasive, more personalized treatments. Ready to join a team that’s pioneering the development and commercialization of Intravascular Lithotripsy (IVL) to treat complex calcified cardiovascular disease. Our Shockwave Medical portfolio aims to establish a new standard of care for medical device treatment of atherosclerotic cardiovascular disease through its differentiated and proprietary local delivery of sonic pressure waves for the treatment of calcified plaque.

We are seeking an experienced Modern Data Stack Data Engineer with specialized expertise in the domains of Supply Chain, Manufacturing, and Finance. This role is critical in architecting and managing data solutions that support and enhance our core business operations. Your deep understanding of Oracle Fusion Cloud applications and your ability to design semantic layers will be key to transforming raw data into strategic business insights.

Essential Job Functions

• Domain-Specific Data Engineering: Develop and manage data pipelines specifically tailored for Supply Chain, Manufacturing, and Finance data using technologies like Snowflake, Fivetran, dbt and Airflow
• Semantic Layer Design: Design and implement a semantic layer to improve data accessibility and usability across business units, ensuring that data is modeled in a way that aligns with business processes and needs.
• Data Integration from Oracle Fusion Cloud: Efficiently extract and load data from Oracle Fusion Cloud, with a focus on leveraging BI Publisher and BICC PVOs for comprehensive data capture from Finance, Supply Chain, and Manufacturing modules.
• Advanced Data Transformation: Utilize SQL and dbt to perform complex data transformations within Snowflake, ensuring data is clean, efficient, and ready for analysis.
• Collaboration with Business Units: Work closely with stakeholders in Supply Chain, Manufacturing, and Finance to understand their data needs and deliver precise data models and dashboards.
• Data Quality and Accuracy: Implement robust data quality checks and monitoring with tools like Monte Carlo to ensure high data integrity and reliability.
• Performance Optimization: Regularly evaluate and optimize data pipelines for enhanced performance and scalability.
• Visualization and Business Intelligence: Create and maintain advanced visualizations and dashboards in Power BI, translating data into actionable business insights.

Requirements

• Professional Experience:

Bachelor’s degree in systems Engineering or similar fields.

At least 10 years of experience in IT environment and at least 5+ years in data engineering with

significant exposure to Supply Chain, Manufacturing, and Finance functions.

• Technical Proficiency: Expert knowledge of Snowflake, dbt, Python, and SQL. Experience with Fivetran, Airflow, and Azure Data Factory is highly preferred.
• Oracle Fusion Cloud Expertise: Deep understanding of Oracle Fusion Cloud, especially BICC PVOs and BI Publisher, for effective data extraction and reporting.
• Analytical Skills: Strong analytical capabilities with a proven record of solving complex data problems.
• Communication: Excellent communication skills to effectively collaborate with technical teams and business stakeholders.
• Leadership Qualities: Demonstrated project management and leadership skills, with a strategic vision to align data initiatives with business goals.