Sr Business Data Analyst

Insight Global; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading technology and consulting firm in Toronto is seeking a Senior Analyst/Lead to design and implement capital management solutions within the Treasury Technology team. This role requires expertise in translating business rules into robust technology requirements, managing data processes, and optimizing data pipelines. The ideal candidate has over 5 years of experience in capital management technology and strong leadership skills, complemented by a relevant degree.

Qualifications

• 5+ years experience in capital management technology or treasury systems.
• Proven expertise in translating business rules into technology requirements.
• Strong experience with data integration and testing methodologies.

Responsibilities

• Design, implement, and enhance capital management solutions.
• Partner with teams to optimize data ingestion pipelines.
• Conduct data discovery and profiling for data quality.

Skills

SQL

Spark SQL

APIs

Postman

Databricks

Capital metrics understanding

Leadership skills

Stakeholder management

Education

Bachelor's degree in Finance, Computer Science, Engineering

Advanced degree

Tools

Databricks

AXIOM

Job description

Job Description

The Capital Management Technology Senior Analyst / Lead is a senior, hands‑on expert responsible for designing, implementing, and enhancing capital management solutions within the Treasury Technology team. This role combines leadership and technical expertise, translating complex capital business rules into robust technology solutions, and managing data processes.

Translate business rules and data into detailed technology requirements, mappings, and controls.

Produce source‑to‑target mappings, data dictionaries, and interface specifications for capital management and reporting platforms.

Execute onboarding of priority data sources into strategic data platforms.

Conduct data discovery and profiling for critical capital data sources to ensure completeness, accuracy, and quality.

Partner with data engineers and technology teams to build and optimize data ingestion pipelines.

Write user stories and acceptance criteria for capital management features.

Prepare test cases and QA plans; lead triage activities to validate data and system integrity.

Develop and maintain data lineage, catalogs, and control documentation for compliance and audit readiness.

Contribute to canonical capital models and reusable solution patterns.

Foster best practices in requirements management, data analysis, and solution delivery.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail]. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Bachelor’s degree in Finance, Computer Science, Engineering, or related field; advanced degree preferred.
• 5+ years experience in capital management technology, treasury systems, or related financial services roles.
• Proven expertise in translating business rules into technology requirements and controls.
• Strong hands‑on experience with data platforms, data integration, and testing methodologies.
• Proficiency in data mapping, documentation, and governance practices.
• Excellent leadership, communication, and stakeholder management skills.
• Experience leading and developing teams of analysts or technical professionals.

Technical Skills

• SQL and Spark SQL
• APIs and Postman
• Databricks for data retrieval and validation
• Familiarity with AXIOM (SaaS-based platform for capital markets) and other Treasury platforms
• Strong understanding of capital metrics (CET1, retail vs wholesale), ALM, liquidity, and funds transfer pricing