Apply now

Posted 2 months ago

Databricks Business Systems Analyst Consultant – Capital Markets

@ BeachHead

Toronto, Ontario

Contract
Apply now
SIGNALS

Overview

BeachHead is hiring a contract Databricks Business Systems Analyst Consultant for a Capital Markets client reporting optimization and integration initiative. The role bridges business stakeholders, source systems and data engineers, working directly with source data to model and map reporting solutions.

Responsibilities:

  • Translate business requirements into data and reporting specifications
  • Examine source systems and map data to Capital Markets reporting needs
  • Validate data assumptions and investigate quality issues with SQL
  • Collaborate with Databricks and Power BI teams on modeling and integration
  • Define key business metrics such as revenue and client profitability

Requirements summary:

  • Extensive experience as a technical Business Systems or Data Business Analyst
  • Practical Databricks and strong SQL skills
  • Knowledge of star schema, dimensional modeling and Medallion architecture
  • Domain expertise in Corporate Banking, Commercial Banking or Capital Markets
  • Excellent communication with business and technical teams

Tools & skills

Source and dates

Source type not verified · jsonld

Employer posting date
2026-09-14
First seen by our source
2026-10-23
Source record updated
2026-11-11

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentBusiness operations
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

FieldValue
Open jobs on Jobsy115
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

Similar jobs

  • Middle-office OTC Derivatives Analyst – Advanced

    Toronto, ON
    $35–$41/hrFull Time

    Finance Professionals

    Must Have Skills:; Experience in Fund Accounting, Derivatives Administration, Fund of Funds, Hedge Funds, Pension Reporting and/or Equity Funds; Computer Skills: MS Office, knowledge and experience with Derivatives…

    General ledger, Reporting, Regulatory compliance, Work independently, Communication skills, Computer skills

  • Mechanical Engineer

    Toronto, ON
    $85k–$115k/yrFull Time

    HH Angus New

    5+ YOECandidates need a Mechanical Engineering degree, a P.Eng with PEO, and 5+ years of engineering consulting experience. Knowledge of AutoCAD and Revit, strong documentation skills, and the ability to work in multi-disciplinary teams are also required.

    AutoCAD, Revit

  • Business Systems Analyst

    Toronto, ON

    Scotiabank

    Experience with Charles River Investment Management System (CRIMS), Charles River Everywhere (CRE) or similar Trading and Portfolio Management systems is strongly preferred; 3–4+ years of experience as a Business…

    Senior Manager, First Line Testing - GTB, Business Risk Management - Toronto

    Toronto, ON

    Scotiabank

    You'll finalize periodic reports with results, ratings, themes and required actions for stakeholders, Senior Management and Second Line, and keep improving the reporting over time; Master’s degree in business…

    Director, Marketing Planning, Loyalty and Partnerships [12 Month Contract]

    Toronto, ON

    Scotiabank

    Leads and drives a customer focused culture throughout their team to deepen client relationships and leverage broader Bank relationships, systems and knowledge; Bachelor’s degree in Marketing, Business, Communications…

  • Research Laboratory Technician I - Biological Assays, Islet, and Transplant Studies

    Toronto, ON
    $28.18–$35.23/hrOn-siteContract

    University Health Network: University Health Network (UHN) is Canada's largest research hospital, which includes Toronto General and Toronto Western Hospitals, Princess…

    Shifts: Monday to Friday; Occasional work outside of regular working hours - Flexibility required; This role is ideal for a candidate with sound laboratory judgment and the ability to follow established procedures;…

    Financial Analyst II

    Toronto, ON
    $72k–$91k/yrHybridFull Time

    University Health Network: University Health Network (UHN) is Canada's largest research hospital, which includes Toronto General and Toronto Western Hospitals, Princess…

    As a member of the Technology & Innovation Finance team and reporting to Financial Business Manager, the Financial Analyst II performs a wide range of professional accounting activities…; Liaise, as required, with UHN…

  • Jr Campaign Manager

    Toronto, ON
    HybridFull Time, Temporary

    Creative Clicks B.V.: is a marketing and advertising company based out of AMSTERDAM, Netherlands.

    Creative Clicks needs candidates with 0-2 years of paid media or digital marketing experience, including internships. Candidates need hands-on knowledge of Meta Ads Manager or Google Ads, strong Excel or Google Sheets skills, and clear English communication.

    Meta Ads Manager, Google Ads, Excel, Google Sheets, GA4

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.