Senior Business Data Analyst Capital Markets Data Architecture 02/05/2026ContractActiveJob Description Job Summary:The Lead Data Analyst will play a critical role in bridging business and data teams by gathering and translating business requirements into high-quality, analytics-ready datasets. This role combines strong business analysis capabilities with hands-on data expertise, supporting data warehouse design and downstream data consumption. The candidate will work closely with stakeholders, data modelers, developers, and QA teams, primarily using Databricks on Azure to support capital markets and marketing analytics initiatives.Key Responsibilities:Gather and document high-level business requirements by engaging with stakeholdersPerform data profiling, analysis, and curation activitiesDesign and support data warehouse solutions for GWAM and ad-hoc analytics needs for marketing teamsCollaborate with data modelers on: Dimensional and star schema designFact and dimension table structuresBuild, prepare, and validate datasets for downstream reporting and analyticsUtilize Databricks on Azure as the primary data platformAct as a liaison between business users, developers,



and QA teamsEnsure data is well-documented, accurate, and aligned with business requirementsRequired Skills:7+ years of experience in Capital Markets with solid understanding of public and private marketsStrong hands-on data experience including: Data warehouse designDimensional/star schema conceptsFact and dimension tablesExperience with data warehouse and/or data lake developmentStrong data profiling and data analysis skillsExperience creating and maintaining data documentationExperience with SQL-based data platforms (SQL Server, Oracle, Mainframe, or similar)Ability to collect, analyze, and translate business requirements into technical solutionsStrong interpersonal and stakeholder management skillsExperience working in banking or insurance environmentsPreferred Skills:Experience using Databricks on AzureAzure cloud experience (high priority)Experience with Gen AI tools as an end user to improve productivityExposure to private marketsExperience with Adobe Digital Platform / Customer Data Platform (CDP)Familiarity with trading and investment platforms such as...#J-18808-Ljbffr

📌 Lead Data Analyst (Toronto)
🏢 Compunnel
📍 Toronto