Supply Chain Lead, Data Architect / Modeler

About the role

Johnson & Johnson's MedTech business is looking for a Data Modeler / Data Architect to support its supply chain data ecosystem. Reporting to the Senior Manager, Architecture, the role defines and governs scalable data models and domain data architectures that support trusted data products, analytics, reporting and AI. It partners with business, data product, engineering, governance, analytics, AI and enterprise architecture teams, and is posted for Bogotá, Colombia and São Paulo, Brazil.

Key responsibilities

• Define and maintain target-state domain data architectures and conceptual, logical, physical, dimensional and semantic data models for MedTech supply chain data products, analytics, reporting and AI solutions.
• Lead discovery and design sessions with business and technology stakeholders to turn supply chain processes and information needs into scalable, reusable data structures.
• Model business entities, relationships, hierarchies, reference data, history and key measures across planning, sourcing and procurement, manufacturing, quality, inventory, logistics, distribution, customer service and order fulfillment.
• Establish and govern data-modeling standards, naming conventions, reusable patterns and design principles across source, ingestion, transformation, semantic and consumption layers.
• Lead or facilitate data architecture and model reviews, document trade-offs and escalate risks to the Senior Manager, Architecture.
• Partner with data engineering teams to validate conformance to approved models, including keys, relationships, history, performance, security, access, quality and lineage.
• Advance metadata management, business glossary alignment, lineage, discoverability, data quality and traceability with data governance and business data owners.
• Assess source-system and process changes, guide model versioning, migration and controlled change management, and identify opportunities to reduce technical debt and improve reuse and performance.
• Provide technical guidance and coaching to modelers, engineers, analysts and data product teams.

Required profile

• Bachelor's degree in computer science, information systems, engineering, data management or a related discipline; advanced degree preferred.
• Minimum 5 years of experience in data modeling, data architecture, data warehousing, analytics engineering or a related discipline, including ownership of complex enterprise or domain designs.
• Experience leading architecture or design reviews and influencing decisions without direct authority.
• Ability to communicate clearly with technical and non-technical audiences and to work independently across architecture, engineering, data product, governance, analytics, AI and business teams.

Required skills

• Demonstrated expertise in conceptual, logical, physical, normalized, dimensional and semantic modeling.
• Strong knowledge of relational databases, data warehouses, lakehouse architectures, cloud data platforms and modern data integration patterns.
• Hands-on experience with enterprise data-modeling tools such as erwin or ER/Studio, including model governance, versioning and documentation.
• Working knowledge of metadata, lineage, data quality, master and reference data, security, access controls and data governance.
• Preferred: Databricks on Azure, medallion or lakehouse patterns, semantic-layer design, SAP S/4HANA data structures, data catalogs and business glossaries, and relevant certifications.