Databricks Business Systems Analyst Consultant – Capital Markets

Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Oct 31, 2026
Posting language: English
Posted: Oct 1, 2026

Original job description

Are you a data-savvy Business Systems Analyst with expertise in Databricks? Apply Now!
Working with one of our top financial clients, this role calls for a Databricks Business Systems Analyst Consultant – Capital Markets. This position involves supporting a major Capital Markets Client Reporting Optimization and Integration initiative. The successful candidate will act as a bridge between business stakeholders, source systems, and the technical data engineering team, focusing on modernizing reporting environments and integrating data across Capital Markets data architecture. The role requires a highly data-centric professional comfortable working directly with source data and collaborating with developers to translate business needs into structured data solutions.
Responsibilities

Analyze business requirements and convert them into detailed data and reporting specifications
Examine source systems and datasets to understand data structures, relationships, and limitations
Map source system data to business reporting and analytics needs for Capital Markets
Collaborate with Databricks engineers on data integration, transformation, and modeling within the data environment
Validate data assumptions and identify issues through direct data analysis using SQL and other tools
Understand and navigate the Databricks environment, including Unity Catalog, schemas, and tables
Define dimensions, measures, and relationships supporting analytical reporting while applying star schema, dimensional modeling, and Medallion architecture best practices
Facilitate requirement clarification and resolution of data-related questions across business and technical teams
Provide data mappings, definitions, and context to support development efforts
Build data prototypes or proofs of concept to validate solutions with stakeholders and speed up delivery
Investigate discrepancies and data quality issues between source systems and reporting outputs
Help establish clear definitions for key business metrics such as revenue, client profitability, and risk measures
Collaborate with Power BI and Databricks teams to ensure the data architecture supports reporting needs
Engage in solution discussions around data integration, modeling, and reporting design
Act as a liaison between business users and technical developers to ensure alignment and clarity in data solutions

Desired Skill-Set

Extensive experience as a technically oriented Business Systems Analyst or Data Business Analyst
Practical experience working with Databricks and modern data environments
Strong SQL and data analysis skills
Deep understanding of data modeling and data structures
Knowledge of star schema, dimensional modeling, and Medallion architecture
Ability to analyze source systems and perform detailed data mapping
Proficiency working directly with data rather than relying solely on business requirements documentation
Excellent communication skills to liaise with both business stakeholders and technical teams
Experience translating business needs into technical data specifications
Strong analytical and problem-solving abilities
Domain expertise in Corporate Banking, Commercial Banking, or Capital Markets, including familiarity with revenue generation, client profitability, risk, and financial reporting in highly regulated environments

Nice to Have

Support experience with Databricks migration or data integration projects
Knowledge of Azure Databricks and Azure Data Services
Experience with Unity Catalog
Supporting Capital Markets reporting or analytics applications
Familiarity with Power BI or other analytical reporting platforms
Exposure to Python
Experience building data prototypes or collaborating with development teams
Working with complex financial datasets

BeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.
Privacy Policy

Apply About employer

More about this job

Responsibilities

Analyze business needs and source data to create detailed data mappings, reporting specifications, and models for a Capital Markets reporting optimization and integration initiative. Collaborate with business stakeholders, Databricks engineers, and Power BI teams to validate data, resolve quality issues, and deliver reporting solutions.

Requirements

Requires substantial experience as a technically oriented Business Systems Analyst or Data Business Analyst, practical Databricks experience, strong SQL and data analysis skills, and expertise in data structures, mapping, and modeling. Candidates should also understand Capital Markets or related banking domains and communicate effectively across business and technical teams.

Skills

Databricks
SQL
Data Analysis
Business Systems Analysis
Data Modeling
Data Mapping
Capital Markets
Unity Catalog
Dimensional Modeling
Star Schema
Medallion Architecture
Data Integration
Power BI
Azure Data Services
Python
Stakeholder Communication

Visa sponsorship

Not detected in the job text

Keywords

Databricks
SQL
Capital Markets
Client Reporting
Data Integration
Data Transformation
Data Modeling
Source Systems
Data Mapping
Unity Catalog
Schemas
Tables
Star Schema
Dimensional Modeling
Medallion Architecture
Power BI
Azure Databricks
Azure Data Services
Python
Data Quality
Revenue
Client Profitability
Risk Measures
Financial Reporting
Corporate Banking
Commercial Banking
Data Prototyping
Analytics
Business Requirements
Regulated Environments

Report this job