Summary: Seeking a senior architect/lead to standardize data consumption from an Azure Databricks-based data lake across multiple teams at a global healthcare leader. Highlights: 1. High-impact architecture work in an enterprise-scale environment 2. Opportunity to set patterns for multiple teams 3. Work with a modern data stack (Azure + Databricks) **About Our Client:** Johnson \& Johnson is one of the world’s most respected and innovative healthcare companies, dedicated to improving the health and well\-being of people everywhere. With a global presence across pharmaceuticals, medical devices, and consumer health, J\&J is known for combining science, technology, and design to deliver impactful solutions. **About the Role:** We’re looking for a senior architect/lead to standardize how multiple teams consume data from an Azure Databricks\-based data lake. Today, different teams are using different approaches, creating duplicated pipelines, weak transparency on usage, and governance/security risk. You’ll assess the current state, define a small set of recommended design patterns for data consumption, and propose a simplified future\-state architecture (with a strong focus on Azure Databricks \+ Power BI). **Contract:** interim engagement (expected \~3–4 months), extension possible based on impact. **What You’ll Do:** * Assess the current data consumption landscape (multiple teams/pillars, multiple approaches). * Define and document recommended architecture patterns to consume data from Azure Databricks (repeatable “reference designs”). * Reduce pipeline sprawl by recommending simplifications across ETL/data movement steps (where feasible). * Improve transparency/traceability of data usage (governance/lineage mindset). * Align with highly technical stakeholders (data engineering/data science/platform teams) and present recommendations clearly. * Support adoption planning: rollout approach, risks, and operating model suggestions (what skills/team shape is needed). **Requirements:** * Strong, hands\-on experience with Azure Databricks in production environments. * Proven experience designing data consumption architectures/patterns used across multiple teams (not just building one\-off pipelines). * Solid ETL / data pipeline architecture knowledge (designing, simplifying, governing). * Strong SQL and experience with downstream consumption layers (SQL Server in the data path is a big plus). * Power BI familiarity (as the key reporting/consumption layer). * Senior stakeholder communication skills (can work with very technical teams and drive architectural clarity). **Nice to Have:** * Databricks Unity Catalog experience (governance/catalog/permissions). * Experience building or formalizing a semantic layer. **Benefits:** * High\-impact architecture work: you’ll set patterns that multiple teams will adopt. * Enterprise\-scale environment with modern data stack (Azure \+ Databricks). * Fully remote contractor role (LATAM\-friendly) * Opportunity to work with a global healthcare leader * High chance of extension after the initial contract