In this role, you will have the opportunity to:- Own the development and maintenance of the finance and market risk data marts, optimizing for performance, data quality, reliability, and efficiency
- Design, build, and document robust data pipelines that generate critical financial reports and metrics for stakeholders across the organization
- Build, automate, and maintain brokerage reporting & monitoring systems, ensuring data integrity and accuracy across financial processes
- Partner closely with business stakeholders in brokerage and market risk to launch and support new financial products and model development initiatives
- Create insightful dashboards and visualizations to monitor brokerage KPIs, profitability metrics, and regulatory reporting requirements
- Provide business intelligence support for trade and collateral monitoring, financial reporting, product performance analysis, and forecasting initiatives
- Translate complex business requirements into scalable analytics solutions that address key financial and risk management needs
- Participate in code reviews and contribute to best practices for data engineering and analytics development
- Mentor junior team members and share knowledge to elevate the team's technical capabilities
What you bring:- 5+ years of experience in data engineering or analytics development, with demonstrated expertise in data mart architecture, design, and management
- Strong proficiency in SQL with the ability to write complex queries, optimize performance, and work with large-scale datasets
- Experience working at brokerage operations or financial services, with knowledge of accounting principles and market risk concepts (preferred)
- Familiarity with regulatory reporting requirements and financial product structures (a plus)
- Hands-on experience building and orchestrating data pipelines using modern tools such as dbt, Airflow, or similar workflow management platforms
- Working knowledge of cloud infrastructure, particularly AWS services (S3, Redshift, Snowflake or equivalent)
- Proficiency in Python for data manipulation, automation, and scripting
- Experience with version control systems, particularly Git and GitHub, including branching strategies, pull requests, and code reviews
- Proven ability to translate complex business requirements into scalable, data-driven solutions
- Strong data visualization skills with experience using tools such as Tableau, Looker, Power BI, or similar platforms
- Understanding of analytics engineering principles and best practices for building maintainable, well-documented data models
- Excellent communication and interpersonal skills, with the ability to explain technical concepts to non-technical stakeholders
- Demonstrated ability to collaborate effectively with cross-functional teams, including finance, risk, and product teams
🌸 Top-tier health benefits and life insurance
Long-term group savings with employer match, through Wealthsimple for Business
20 vacation days, 4 wellness days, and unlimited sick and mental health days per year*
90 days away: work outside Canada for up to 90 days per year*
Employee resource groups, including Rainbow (2SLGBTQ), Women of WS, and Black at WS
We are a hybrid team with over 1,500 employees across North America. The people are one of the best parts of working here: you'll collaborate with incredibly talented, curious, and driven teammates who are deeply committed to doing great work.
*Unlimited paid sick days, Wellness Days and the 90 day away program do not apply to certain roles.
