Lead Business Analyst

Bridgenext Digital Engineering•Ottawa, ON

89d•CA$125,000 - CA$140,000•Hybrid

About The Position

Bridgenext is seeking a Lead Business Analyst (Data Warehouse) with demonstrated experience in Capital Markets, Financial Services, Asset Management, or Wealth Management to support enterprise‑scale data initiatives. The role requires hands‑on experience working with financial data domains, industry‑specific data models, and core business and operational processes common to investment, trading, and asset/wealth management environments. The Lead Analyst will carry out requirements workshops, perform hands‑on SQL‑based data profiling and validation, create and maintain data documentation artifacts, and own UAT and post‑production validation to ensure delivered data assets meet business, operational, and regulatory expectations typical of financial services organizations.

Requirements

10+ years of experience as a Business Data Analyst, preferably within Capital Markets, Financial Services, Asset or Wealth Management domains
Extensive experience in requirements gathering and leading User Acceptance Testing (UAT) for Data Warehouse projects, with a strong emphasis on data ingestion processes.
Strong verbal and written communication skills, with the ability to clearly articulate complex or technical concepts to diverse audiences
Strong analytical mindset with a proven ability to bridge business and technical teams from a data perspective
Demonstrated problem‑solving, prioritization, and organizational skills, with attention to detail and focus on outcomes
Experience presenting or displaying complex data in simple, intuitive formats for business consumption
Hands‑on experience writing complex SQL queries for data analysis, validation, and reconciliation
Proven experience delivering data documentation artifacts in organizations of similar scale and complexity, within project timelines.
Canadian citizens and those authorized to work in Canada are encouraged to apply

Nice To Haves

GenAI experience is an asset, including use of AI to accelerate SQL analysis, test design, documentation, or impact analysis.
Working experience in investment/trading core systems is desirable, such as Bloomberg Polar Lake, SimCorp Dimension, Findur, Apex, Eagle, Charles River, Sylvan, Calypso

Responsibilities

Participate in enterprise data initiatives and lead requirements workshops to uncover insights, gather business and data requirements, and obtain stakeholder sign‑off
Perform data profiling, SQL‑based analysis and validation, and metadata collection to support data quality and delivery readiness
Support the implementation and adherence of data development practices across projects and teams
Create and maintain data artifacts and documentation, including business requirements, data mappings, and data flows
Ensure that project teams deliver data assets that meet documented business requirements and quality expectations
Liaise with multiple teams and stakeholders to drive alignment and resolve requirement or data‑related gaps
Lead UAT activities with business users and obtain formal acceptance and sign‑off
Perform production data validation post‑implementation to confirm accuracy, completeness, and usability of delivered data assets.