Reports and Analytics Value Stream Lead
Johnson & Johnson Innovative Medicine
Summary
The Reports & Analytics Value Stream Lead will own reporting readiness across the MAKE sites of Limerick, Jacksonville, Añasco, Groningen, Uppsala, Spruce and Milpitas as they transition from legacy ERP systems to SAP S/4HANA. Working with site SMEs, Data SMEs, MAKE BPOs, Digital Brain, Data/CDL and Transcend teams, the VSL will identify existing operational reports and determine which reports will be impacted by the ERP transition.
Job description
The VSL will provide end-to-end leadership across reporting discovery, impact assessment, solution disposition, requirements, delivery, validation, deployment and adoption. The role will bridge MAKE business processes and the technical reporting ecosystem, ensuring that changes to SAP transactions, master data, interfaces and data structures are understood and addressed across downstream reporting and analytics solutions.
Report Disposition
- Rebuilt for SAP S/4HANA
- Retired because it is no longer required
- Replaced by a standard Digital Brain report or dashboard
- Remediated by mapping/replacing legacy data through CDL
- Temporarily supported during the legacy/SAP S/4HANA transition
- Assigned an accountable solution owner, delivery team, technical dependency plan, testing approach and sustainable post-go-live support model
The VSL will own the resulting cross-site reporting backlog and drive requirements, prioritization, remediation, testing, business validation, deployment and change management. The VSL will work closely with each site’s SMEs and leadership to ensure users understand what is changing, which legacy reports will be retired, what the future-state solution will be and how reporting will operate after go-live. The VSL will promote reuse of Global Template and enterprise reporting solutions, challenge unnecessary local variations, and reduce duplicate, obsolete or unsupported reports rather than recreating the legacy reporting landscape in the future-state environment.
Primary Accountability
Ensure every business-critical MAKE report required to operate each manufacturing site has a defined future-state solution and is tested, validated and available when the site goes live on Transcend. Ensure reporting solutions remain accurate, controlled and operational as SAP S/4HANA changes source data, master data, interfaces, business processes and downstream data dependencies.
Key Responsibilities and Deliverables
Reporting Inventory and Impact Assessment
- Cross-site MAKE report inventory
- Report criticality and impact assessment
- Report disposition matrix
- Digital Brain standard-report mapping
- CDL remediation requirements
- Reporting build/remediation backlog
- Site reporting readiness tracking
- Identify dependencies between reports and SAP data objects, master data, interfaces, transformation logic, data platforms and visualization tools
- Document end-to-end traceability from source systems through ingestion, ETL/ELT and business-logic layers to final reports, dashboards or analytical outputs
- Identify reports supporting business continuity, SOX, quality, regulatory or other critical control requirements and apply the appropriate validation and approval requirements
Requirements and Solution Governance
- Ensure reporting requirements and identified gaps are documented through approved Transcend intake and governance processes
- Coordinate FIT/GAP assessment and determine whether needs can be satisfied through SAP S/4HANA, Fiori, Digital Brain, CDL, existing enterprise products or business-owned analytical solutions
- Maintain reporting requirements, decisions, dependencies, risks and delivery status in JIRA or other approved program-management tools
- Support escalation and governance of gaps requiring new development, architectural decisions, funding or Design Authority approval
- Clarify accountability among Transcend, Digital Brain, Data/CDL, site teams and business-owned analytics teams for solution design, development, testing, deployment and long-term support
Delivery and Technical Coordination
- Drive requirements, prioritization and reporting remediation
- Coordinate BPO, site SME and Data SME activities
- Lead cross-site stakeholders and manage the reporting backlog
- Translate business needs into sufficiently detailed functional and data requirements for engineering and analytics teams
- Evaluate the effect of changes to SAP tables, data objects, transactions, interfaces, refresh schedules, calculation logic and master-data structures on downstream reporting
- Coordinate delivery across relevant technologies, including SAP S/4HANA and Fiori, CDL, Tableau, Alteryx, Databricks, Power BI and other approved enterprise platforms
- Challenge solution estimates, assumptions and designs sufficiently to identify missing dependencies, duplicated solutions or unsustainable support models
- Ensure appropriate ownership, documentation and knowledge transfer for solutions that will remain after the Transcend program concludes
Testing, Cutover and Stabilization
- Define report-level acceptance criteria covering completeness, accuracy, calculation logic, reconciliation, refresh performance, security and business usability
- Coordinate reconciliation between legacy and SAP S/4HANA reporting outputs, including investigation and resolution of material variances
- Ensure testing covers source-to-output data flows, not only the visual appearance of reports and dashboards
- Maintain evidence of validation, approvals and unresolved exceptions for critical or controlled reports
- Develop reporting cutover plans covering deployment, legacy-report retirement, user access, data availability and temporary transition solutions
- Coordinate production validation and reporting hypercare after each site deployment
- Lead reporting issue triage during cutover and hypercare, including prioritization, escalation, ownership and resolution tracking
- Confirm retained solutions transition into an enduring support model with named business and technical owners
Stakeholder, Resource and Change Leadership
- Forecast required business SME, Data SME, engineering, testing and change-management capacity against deployment milestones
- Identify resource, funding and backfill gaps that could affect reporting readiness and escalate them through appropriate governance forums
- Coordinate internal teams, implementation partners and external resources while maintaining clear accountability for outcomes
- Communicate reporting risks, decisions and readiness using concise, evidence-based status reporting for site and program leadership
Key Capabilities
Business and Transformation Leadership
- Manufacturing/MAKE process knowledge
- Reporting and analytics experience
- ERP/S/4HANA transformation experience
- Data and reporting dependency understanding
- Cross-site stakeholder leadership
- BPO and SME coordination
- Strong program and backlog management
- Business testing and validation
- Change management
- Ability to challenge legacy requirements and drive standardization
- Ability to operate across business, data and technology teams without losing accountability between organizational boundaries
- Ability to manage ambiguity, resolve competing site priorities and drive decisions within a global transformation program
- Experience managing reporting readiness across multiple deployment waves, sites or business units
Technical and Data Literacy
- Working knowledge of enterprise reporting architecture, including source systems, ingestion, interfaces, ETL/ELT, transformation logic, semantic or business-logic layers and downstream consumption
- Ability to trace data from SAP S/4HANA or another source through intermediate data platforms to the final report, dashboard or analytical output
- Working knowledge of relational data concepts, including joins, data grain, calculated fields, filtering, aggregation and reconciliation
- Practical experience with Tableau and Alteryx solutions, including workflows, data sources, dependencies, calculations, schedules and migration implications
- Working familiarity with Databricks or comparable cloud data platforms, including governed ingestion, transformation and consumption patterns
- Working familiarity with Power BI or comparable modern enterprise visualization platforms
- Familiarity with SAP S/4HANA reporting capabilities, including Fiori applications, embedded reporting and downstream data enablement
- Ability to assess technical designs and delivery estimates without necessarily serving as the hands-on development lead
Requirements
- Minimum of a Bachelor’s or equivalent University Degree required
- Supply Chain, Logistics, Business, Data Engineering, Information Technology, or a related discipline is preferred
- Manufacturing/MAKE process knowledge
- Reporting and analytics experience
- ERP/S/4HANA transformation experience
- Data and reporting dependency understanding
- Cross-site stakeholder leadership
- BPO and SME coordination
- Strong program and backlog management
- Business testing and validation
- Change management
- Ability to challenge legacy requirements and drive standardization
- Working knowledge of enterprise reporting architecture, including source systems, ingestion, interfaces, ETL/ELT, transformation logic, semantic or business-logic layers and downstream consumption
- Ability to trace data from SAP S/4HANA or another source through intermediate data platforms to the final report, dashboard or analytical output
- Working knowledge of relational data concepts, including joins, data grain, calculated fields, filtering, aggregation and reconciliation
- Practical experience with Tableau and Alteryx solutions
- Working familiarity with Databricks or comparable cloud data platforms
- Working familiarity with Power BI or comparable modern enterprise visualization platforms
- Familiarity with SAP S/4HANA reporting capabilities, including Fiori applications, embedded reporting and downstream data enablement
- Experience supporting reporting or analytics within a manufacturing or regulated environment
- Experience with a large-scale SAP or ERP transformation
- Experience leading reporting inventory rationalization or legacy-report retirement
- Experience coordinating business-owned reporting with enterprise data and analytics platforms
- Experience with SAP S/4HANA, Fiori, Tableau, Alteryx, Databricks, Power BI, CDL or comparable enterprise technologies
- Experience working with controlled, validated, SOX-relevant, quality-critical or regulatory reporting
- Experience using JIRA or comparable tools to manage requirements, delivery backlogs, dependencies, risks and testing evidence
- May require up to 25% domestic and/or international travel
Benefits
- Pension plan
- 401(k) savings plan
- Vacation
- Sick time
- Holiday pay
- Floating holidays
- Work, personal and family time
- Parental leave
- Bereavement leave
- Caregiver leave
- Volunteer leave
- Military spouse time-off
Company overview
Johnson & Johnson Innovative Medicine is the pharmaceutical division of Johnson & Johnson, leading the way in medical innovation with a relentless focus on bringing transformational treatments to patients worldwide. The company applies rigorous science and compassion to address the most complex diseases of our time, developing groundbreaking medicines across key therapeutic areas including oncology, immunology, neuroscience, and cardiopulmonary medicine. With deep expertise and global reach, Johnson & Johnson Innovative Medicine reimagines how devastating diseases are treated and cured, delivering hope and better care for millions of patients and their families. The organization pioneers the path from laboratory research to clinical application, championing patients every step of the way while maintaining an unwavering commitment to scientific excellence and patient-centered innovation.