At a Glance
- Tasks: Bridge business and data teams by translating requirements into analytics-ready datasets.
- Company: Join a leading firm in capital markets with a focus on innovation.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on career advancement and skill development.
- Why this job: Make an impact in capital markets while working with cutting-edge data technologies.
- Qualifications: 7+ years in capital markets with strong data analysis and SQL skills.
The predicted salary is between 103500 - 126500 $ per year.
- Senior Business Data Analyst Capital Markets Data Architecture
- 02/05/2026
- Contract
- Active
Job 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 stakeholders
- Perform data profiling, analysis, and curation activities
- Design and support data warehouse solutions for GWAM and ad-hoc analytics needs for marketing teams
• Collaborate with data modelers on
- Dimensional and star schema design
- Fact and dimension table structures
- Build, prepare, and validate datasets for downstream reporting and analytics
- Utilize Databricks on Azure as the primary data platform
- Act as a liaison between business users, developers, and QA teams
- Ensure data is well-documented, accurate, and aligned with business requirements
Required Skills
- 7+ years of experience in Capital Markets with strong understanding of public and private markets
• Strong hands-on data experience including
- Data warehouse design
- Dimensional/star schema concepts
- Fact and dimension tables
- Experience with data warehouse and/or data lake development
- Strong data profiling and data analysis skills
- Experience creating and maintaining data documentation
- Experience with SQL-based data platforms (SQL Server, Oracle, Mainframe, or similar)
- Ability to collect, analyze, and translate business requirements into technical solutions
- Strong interpersonal and stakeholder management skills
- Experience working in banking or insurance environments
Preferred Skills
- Experience using Databricks on Azure
- Azure cloud experience (high priority)
- Experience with Gen AI tools as an end user to improve productivity
- Exposure to private markets
- Experience with Adobe Digital Platform / Customer Data Platform (CDP)
- Familiarity with trading and investment platforms such as ...
- #J-18808-Ljbffr
Lead Data Analyst in Toronto employer: Compunnel Inc.
Join a forward-thinking company in Toronto that prioritizes innovation and employee development. As a Digital Banking Engineering Manager, you'll thrive in a collaborative work culture that values continuous improvement and offers ample opportunities for professional growth. With a focus on modern banking solutions, this role not only allows you to lead a talented team but also empowers you to make a meaningful impact in the digital banking landscape.
