Experienced Analyst, Asset Management, Orthopedics

Johnson & Johnson Co.

Bogotá

Hybrid

COP 30,000,000 - 55,000,000

Full time

10 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Johnson & Johnson in Bogotá seeks an Experienced Analyst, Asset Management for Orthopedics to support LATAM Set Planning, CAPEX analytics and BOM governance. You will collaborate with regional teams to ensure accurate planning, forecasting and asset productivity across multiple countries.

The role emphasizes data-driven decision making, strong Excel/Power BI proficiency, and close collaboration with Marketing, Finance and Supply Planning to optimize capacity and utilization.

Qualifications

  • Bachelor's degree in Industrial Engineering, Business Administration, Supply Chain, Logistics, Economics, Finance, Data Analytics or related field.
  • 1-3 years of relevant experience in Supply Chain, Planning, Inventory Management or Asset Management.
  • Strong quantitative and analytical capabilities.
  • Advanced Excel skills and proficiency with Power BI and Power Query.

Responsibilities

  • Set Planning, Execution & Tracking across LATAM.
  • Support end-to-end Set Plan process across LATAM.
  • Monitor investment and set requirements vs. execution.
  • Coordinate BOM validation and data quality with local teams.
  • Prepare KPI reporting for regional governance and insights.

Skills

Analytical thinking
Data analysis
Communication

Education

Bachelor's degree

Tools

Power BI
Power Query
Excel

Job description

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions 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 jnj.com.

As guided by Our Credo, Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson, we respect the diversity and dignity of our employees and recognize their merit.

Please note that this role is available across multiple countries and may be posted under different requisition numbers to comply with local requirements. While you are welcome to apply to any or all of the postings, we recommend focusing on the specific country(s) that align with your preferred location(s):

Brazil R-110468, Chile R-110469, Colombia R-106531, Mexico R-110470

Remember, whether you apply to one or all of these requisition numbers, your applications will be considered as a single submission.

Job Function

Supply Chain Planning

Job Sub Function

Supply Network Planning

Job Category

Professional

All Job Posting Locations:

Bogotá, Distrito Capital, Colombia

Job Description

"Johnson & Johnson announced plans to separate our Orthopedics business to establish a standalone orthopedics company, operating as DePuy Synthes. The process of the planned separation is anticipated to be completed within 18 to 24 months, subject to legal requirements, including consultation with works councils and other employee representative bodies, as may be required, regulatory approvals and other customary conditions and approvals. Should you accept this position, it is anticipated that, following conclusion of the transaction, you would be an employee of DePuy Synthes and your employment would be governed by DePuy Synthes employment processes, programs, policies, and benefit plans. In that case, details of any planned changes would be provided to you by DePuy Synthes at an appropriate time and subject to any necessary consultation processes.”

About Orthopaedics

Fueled by innovation at the intersection of biology and technology, we’re developing the next generation of smarter, less invasive, more personalized treatments.

Are you passionate about improving and expanding the possibilities of Orthopaedics? Ready to join a team that’s reimagining how we heal? Our Orthopaedics teams help keep more than 6 million people moving each year while delivering clinical and economic value to surgeons and healthcare systems. Our teams build solutions for joint reconstruction; trauma

and craniomaxillofacial; sports, extremities, and elective foot and ankle; spine; and robotics and digital surgery.

Your unique talents will help patients on their journey to wellness. Learn more at https://www.jnj.com/medtech.

We are searching for the best talent for Experienced Analyst, Asset Management, Orthopedics.

Purpose

The EXPT Analyst supports the LATAM Asset Management organization by providing analytical, operational and governance support across Set Planning, Set Execution, CAPEX, forecast management, BOM governance and asset productivity.

The position is responsible for maintaining accurate planning information, monitoring set execution against approved plans, identifying risks and opportunities in asset utilization, and coordinating inputs across Regional Asset Management, Field Asset / Inventory Planning, Supply Planning, Marketing, Finance and other cross-functional stakeholders.

The role enables data-driven decisions by ensuring visibility of demand, installed capacity, productivity, utilization, execution status and investment requirements across LATAM.

You Will Be Responsible For

  • Set Planning, Execution & Tracking
  • Support the end-to-end Set Plan process across LATAM.
  • Track approved investment and set requirements against actual execution.
  • Monitor set creation, deployment, shipment, availability and outstanding requirements.
  • Maintain structured tracking by country, business unit, franchise, brand and planning cycle.
  • Identify deviations between the approved Set Plan and actual execution, working with local teams to understand root causes.
  • Consolidate country updates and provide regional visibility of execution progress.
  • Support recurring Set Execution reviews with country and regional stakeholders.
  • Asset Productivity & Capacity Analytics
  • Analyze installed set capacity, consumption, productivity per set, turn rate and utilization across countries and franchises.
  • Identify assets with high installed capacity and low consumption.
  • Identify potential capacity constraints where additional sets may be required to support demand.
  • Develop recommendations to increase capacity, maintain or monitor current capacity, redeploy existing assets, or review excess inventory.
  • Compare productivity performance against established business thresholds and targets.
  • Support regional and country teams with quantitative analysis for asset investment decisions.
  • Monitor KPI evolution across planning cycles and highlight material changes.
  • Forecast & ANCHOR Management
  • Support maintenance and validation of Set Plan forecasts in ANCHOR.
  • Ensure approved changes are accurately reflected in the planning system.
  • Validate forecast volumes by country, franchise, brand, SKU / BOM and planning horizon.
  • Support reconciliation between the approved Set Plan, planning assumptions and system-loaded forecasts.
  • Coordinate required corrections with the appropriate local and regional stakeholders.
  • Monitor changes between planning cycles and provide visibility of significant increases, reductions or timing shifts.
  • BOM Governance & Data Quality Page 2
  • Coordinate and monitor BOM validation with local Marketing and Planning teams. EXPT Analyst | Job Description.
  • Support governance to ensure BOMs used for planning and forecasting are accurate and current.
  • Identify missing BOMs, outdated BOMs, BOM mismatches, additional SKUs, and discrepancies between planning assumptions and system information.
  • Maintain structured documentation of validated BOMs and pending corrections.
  • Coordinate regional and local alignment before forecast or Set Plan submissions when BOM changes affect requirements.
  • CAPEX / Revenue & Non-Revenue Analysis
  • Support analysis of Revenue and Non-Revenue asset investments.
  • Track CAPEX, OPEX, implants, instruments and other relevant investment categories against the approved Set Plan.
  • Analyze variations between planning cycles by country, business unit, franchise, brand, investment purpose and year.
  • Highlight major investment changes and support preparation of business rationales.
  • Provide visibility of incremental investment requirements and potential risks to the approved plan.
  • S&OE; Reporting & KPI Management
  • Prepare and maintain Asset Management indicators for S&OE; and other regional governance forums.
  • Develop reporting for Set Execution, productivity, capacity utilization, consumption per set, investment execution, forecast changes and exceptions.
  • Compare actual performance against previous planning cycles and agreed targets.
  • Convert detailed operational data into concise management insights and key drivers.
  • Support preparation of executive materials for regional and country leadership.
  • Exceptions & Cross-Functional Coordination
  • Maintain visibility of Set Plan and supply-related exception requests.
  • Consolidate supporting information, including business case, demand / forecast impact, customer opportunity, required sets, BOM / SKU information and expected timing.
  • Track submitted exceptions through the appropriate governance process.
  • Ensure alignment between local and regional stakeholders before submission.
  • Provide status visibility and escalate gaps or delays when appropriate.

Qualifications / Requirements

Required

  • Bachelor's degree in Industrial Engineering, Business Administration, Supply Chain, Logistics, Economics, Finance, Data Analytics or a related field.
  • 1-3 years of relevant experience in Supply Chain, Planning, Inventory Management, Asset Management, Demand Planning, Business Analytics or Financial / CAPEX analysis.
  • Strong quantitative and analytical capabilities.
  • Advanced Microsoft Excel, including PivotTables, XLOOKUP or INDEX-MATCH, SUMIFS, data validation, data reconciliation and large dataset management.
  • Power BI, including the creation and maintenance of dashboards, data models, KPI visualizations and management reporting.
  • Power Query, including data extraction, cleaning, transformation, consolidation and refreshable reporting workflows.
  • Microsoft PowerPoint.
  • Strong analytical and problem-solving skills.
  • KPI tracking and reporting.
  • Data quality management.
  • Business communication in English and Spanish.

Desirable

  • Academic or professional exposure to Supply Chain Planning, Inventory Management, Demand Planning, Asset Management, Data Analytics or Financial / CAPEX planning.
  • Experience working in a regional or multi-country environment is desirable.
  • SAP / APO or equivalent planning systems.
  • ANCHOR or related forecasting and planning tools.
  • Experience managing BOM and master-data structures.
  • Process automation capabilities.

Location & Travel Requirements:

  • Primary work location: Bogotá, Distrito Capital, Colombia
  • Primarily Hybrid Position.
  • Schedule is 1st shift.

Required Skills

Preferred Skills:

Administrative Support, Analytical Reasoning, Business Behavior, Communication, Data Reporting, Demand Planning, Execution Focus, Logistics Optimization, Manufacturing Flow Management, Office Administration, Problem Solving, Spend Analysis, Standard Operating Procedure (SOP), Strategic Sourcing, Supply Chain Resilience, Supply Planning, Sustainable Procurement, Transportation Management

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analyst, Orthopaedics Supply Chain Procurement
Analyst, Orthopaedics Supply Chain Procurement

Biopharma Asia • Bogotá

Hybrid
COP 70,000,000 - 120,000,000
Analyst, Orthopaedics Supply Chain Procurement (Bogota, Colombia)
Analyst, Orthopaedics Supply Chain Procurement (Bogota, Colombia)

Johnson And Johnson • Bogotá

Hybrid
COP 60,000,000 - 80,000,000
Analyst, Orthopaedics Supply Chain Procurement (Bogota, Colombia)
Analyst, Orthopaedics Supply Chain Procurement (Bogota, Colombia)

7456-Johnson & Johnson MedTech Colombia S.A.S. Legal Entity • Bogotá

On-site
COP 60,000,000 - 110,000,000
Financial Analyst, FP&A Intl
Financial Analyst, FP&A Intl

Johnson & Johnson Co. • Bogotá

On-site
COP 133,920,000 - 189,720,000
Sr. Manager, Global Fleet Lead
Sr. Manager, Global Fleet Lead

Johnson & Johnson Co. • Bogotá

On-site
COP 120,000,000 - 210,000,000
Regional Fleet Lead
Regional Fleet Lead

Johnson And Johnson • Bogotá

On-site
COP 200,000,000 - 340,000,000
Regional Commercial Operations Analyst - Colombia, Chile, Brazil.
Regional Commercial Operations Analyst - Colombia, Chile, Brazil.

Johnson & Johnson Co. • Bogotá

On-site
COP 60,000,000 - 90,000,000
Manager, Sourcing
Manager, Sourcing

Johnson & Johnson Co. • Bogotá

On-site
COP 143,225,000 - 206,881,000
Sr. Manager, Global Fleet Lead
Sr. Manager, Global Fleet Lead

Johnson And Johnson • Bogotá

On-site
COP 180,000,000 - 260,000,000
Regional Commercial Operations Analyst – Colombia, Chile, Brazil.
Regional Commercial Operations Analyst – Colombia, Chile, Brazil.

Johnson And Johnson • Bogotá

On-site
COP 141,456,000 - 235,760,000