IT Business Analyst

IT Business Analyst

Japanese and English bilingual resource to support AD's sponsored repo enablement. The consultant is responsible for the analysis, design, and delivery governance required to rationalize downstream data flows following the FOX Upgrade Project. The consultant will lead and complete the assessment of existing downstream data flows and legacy RDB dependencies, define the target-state data architecture with Izumi positioned as the enterprise-wide primary data hub, and produce a structured transition roadmap to enable migration from a fragmented data landscape to a unified Golden Source Architecture.

Phase 1: Discovery – Identify All Systems Referencing FOX

The consultant will provide expert analysis, facilitation, and documentation, including:

• Lead and coordinate stakeholder interviews to identify systems referencing FOX (including non-RDB consumers).
• Map data flows and dependencies between FOX and downstream systems.
• Document current-state system interaction diagrams and data lineage.
• Prepare a discovery report summarizing findings, risks, and recommended scope/approach.
• Lead cross-functional workshops (business, IT, architecture) and capture decisions.
• Deliverables: Discovery deliverable package with system list and dependency mapping, project governance and monthly status reporting.

Phase 2: Design Governance – Izumi Ingestion Layer & Snapshot Logic

Work items include:

• Lead requirements definition sessions for ingestion logic (pre batch vs. post batch).
• Produce functional and non-functional requirements.
• Lead and document solution design reviews with architecture and engineering teams.
• Maintain authoritative design decisions, assumptions, and traceability documentation.
• Govern alignment across data, architecture, and FOX teams.
• Produce the stakeholder-approved design/requirements artifacts required by implementation teams.
• Deliverables: Requirements and design documentation package approved by stakeholders, project governance and monthly status reporting.

Phase 3: Validation Oversight – Data Parity Between RDB and Lakehouse Outputs

Work items include:

• Define the overall parity validation strategy, approach, and acceptance criteria.
• Lead data comparison reviews and defect triage governance.
• Review and assess test results provided by technical teams and identify gaps and remediation recommendations.
• Document discrepancies, root-cause classifications, and resolution recommendations.
• Produce validation summary reports and sign-off documentation.
• Deliverables: Data parity testing summary and UAT support documentation, project governance and monthly status reporting.

Phase 4: Transition Management – Group-Based Migration of Downstream Systems

Work items include:

• Define the downstream group migration strategy to minimize business disruption.
• Lead readiness assessment and cutover planning coordination with each system owner.
• Produce migration runbooks, checklists, and communication materials.
• Govern risk assessments, dependency planning, and mitigation strategies.
• Lead go/no-go decision forum and document final migration decisions.
• Produce final transition summary and lessons-learned documentation.
• Deliverables: Approved transition plan and migration coordination package, project governance and monthly status reporting.