Data Analyst

Location

• This position will be based in Toronto, ON. Our organization:
• Founded in 2017, Wellington-Altus Financial Inc. (Wellington-Altus) is one of Canada’s Top Growing Companies* and the parent company to Wellington-Altus Private Counsel Inc., Wellington-Altus USA Inc., Wellington-Altus Insurance Inc., Wellington-Altus Group Solutions Inc., Independent Advisor Solutions Inc., and Wellington-Altus Private Wealth Inc.—the top-rated** investment dealer in Canada. With more than $50 billion in assets under administration and offices across the country, Wellington-Altus identifies with successful, entrepreneurial advisors and portfolio managers, and their high-net-worth clients.
• *Report on Business 2025 rankings.
• **Investment Executive 2026 Brokerage Report Card. The opportunity:
• We are seeking a detail-oriented and technically proficient Data Analyst with a strong foundation in capital markets and financial domain knowledge to support data analysis across the organization. The ideal candidate will have hands-on experience working with AWS-based data environments, strong SQL expertise, and the ability to translate business requirements into a functional spec. Key responsibilities include:
• Analyzing and interpreting large datasets related to capital markets, portfolios, and financial transactions
• Developing, optimizing, and maintaining SQL queries across cloud data platforms (Redshift, Athena, Postgres)
• Collaborating with Data Engineers to support data ingestion, ELT workflows & transformations
• Monitoring and troubleshooting data pipelines by querying CloudWatch logs
• Supporting data validation, reconciliation, and ensuring data accuracy and integrity
• Generating reports, dashboards, and insights for business stakeholders
• Documenting functional requirements, data processes, pipelines, and usage guidelines

The ideal candidate will possess