LOCATION: Hybrid - Jersey City, NJ
Experience Level: Mid (5-7 Years)
Japanese and English Bilingual resource to support SMBC ADs 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.
1. Discovery - Identify All Systems Referencing FOX (Phase 1)
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.
2. Design Governance - Izumi Ingestion Layer & Snapshot Logic (Phase 2)
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.
3. Validation Oversight - Data Parity Between RDB and Lakehouse Outputs (Phase 3)
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 signoff documentation.
Deliverables: Data parity testing summary and UAT support documentation, project governance and monthly status reporting.
4. Transition Management - Group Based Migration of Downstream Systems (Phase 4)
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/nogo 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: sharpdec
- Position Id: 52141
- Posted 18 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.
