Senior Technical Data Business Analyst

Role Summary

We are seeking a Senior Technical Data Business Analyst with strong techno-functional expertise and hands-on experience in Investment Banking, preferably Debt Capital Markets (DCM) and Equity Capital Markets (ECM).

The ideal candidate should have robust technical data analysis capabilities, experience with data migration and data quality, and the ability to work closely with business, technology, and vendor teams.

Key Responsibilities

- Lead end-to-end requirements gathering, analysis, documentation, and management.
- Prepare BRDs, FRDs/FRSs, and system requirements documentation.
- Perform SQL-based data analysis, validation, reconciliation, and investigation.
- Develop and maintain data models and ensure data quality.
- Support data migration initiatives, including mapping, transformation, and validation.
- Create process flows, business workflows, and UML-based documentation.
- Collaborate with business and technology stakeholders to support project delivery.
- Work with APIs, system integrations, and interface specifications.
- Support Agile delivery and stakeholder communication.
- Leverage BI tools for reporting and analytics.

Mandatory Skills & Experience





- Investment Banking Domain: Strong experience in Investment Banking, preferably DCM and ECM.
- SQL & Data Analysis: Strong SQL skills, data validation, reconciliation, and root-cause analysis.
- Data Modeling: Experience with conceptual, logical, and physical data models.
- Data Migration: Hands-on experience in data mapping, transformation, validation, and reconciliation.
- Data Quality & Governance: Experience in data quality management and governance practices.
- Business Analysis: Requirements gathering, BRD, FRD/FRS, SRS, and requirements management.
- Business Process Analysis: Process flows, workflow documentation, and system analysis.
- Stakeholder Management: Experience collaborating with business, technology, and vendor teams.

Good-to-Have Skills

- UML: Use Case, Activity, Sequence, and Entity Relationship Diagrams (ERDs).
- Process Modeling: BPMN and workflow modeling.
- APIs & System Integrations: REST, SOAP, and microservices integration.
- SDLC Methodologies: Agile, Scrum, and Waterfall.
- BI & Reporting Tools: Power BI, QlikView, Cognos, or Tableau.

📌 Senior Technical Data Business Analyst – Investment Banking (DCM/ECM) | SQL, Data Modeling & Data Migration | Remote – Canada Only
🏢 TestingXperts
📍 Canada