Posted 2 months ago
Data Analyst
@ Wellington Altus Branding
Toronto, Ontario
Overview
Wellington-Altus Private Wealth is hiring a full-time Data Analyst in its Toronto office to analyze capital markets, portfolio and transaction data. The role requires advanced SQL on AWS platforms and several years of data analysis and financial services experience. Compensation is stated as $100,000 to $120,000 annually, plus benefits.
Pay:
$100,000–$120,000 a year
Responsibilities:
- Analyser de grands ensembles de données financières
- Développer et maintenir des requêtes SQL sur plateformes cloud
- Soutenir les pipelines de données avec les ingénieurs de données
- Générer rapports, tableaux de bord et analyses
Requirements summary:
- Baccalauréat ou expérience équivalente
- 5 ans et plus en analyse de données
- 2 ans et plus dans les services financiers
- Expertise avancée en SQL et écosystème AWS
Tools & skills
Benefits mentioned
Source and dates
Employer career site / ATS feed · ultipro
- Employer posting date
- 2026-09-16
- First seen by our source
- 2026-10-30
- Source record updated
- 2026-10-30
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 5+ years |
| Hours per week | 40 (estimated) |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Background checks | criminal record |
| Encouraged to apply | Women, Racialized people, Indigenous peoples, People with disabilities, 2SLGBTQ+ |
| Education | Bachelor’s degree (required) |
| Fields of study | Business, Economics, Statistics, Data Science, Information Systems |
| Perks mentioned | Performance bonus |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Wellington Altus Branding
| Field | Value |
|---|---|
| Open jobs on Jobsy | 23 |
Data Analyst
Location: This position will be based in our Toronto office.
Our organization:
Founded in 2017, Wellington-Altus Private Wealth Inc. (Wellington-Altus) is Canada's top-rated* investment dealer and a subsidiary of Wellington-Altus Financial Inc., one of Canada’s Top Growing Companies**. With more than $55 billion in assets under administration and offices across the country, Wellington-Altus identifies with successful, entrepreneurial advisors, and their high-net-worth clients.
*Investment Executive 2026 Brokerage Report Card.
** Report on Business 2026 rankings.
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:
- Bachelor’s degree in Business, Economics, Statistics, Data Science, Information Systems, or a related discipline, or equivalent experience
- 5+ years of experience in data analysis, including business analysis responsibilities.
- Demonstrated expertise in data mining, evaluation, analysis, and visualization.
- 2+ years of experience in the financial services industry, with exposure to wealth management and/or capital markets.
- Strong analytical, problem-solving, and business analysis skills with experience in Agile and/or Waterfall environments.
- Proven expertise in requirements management, business process analysis, and data mapping.
- Ability to bridge business and financial domain knowledge with technical and data solutions.
- Knowledge of data modeling, database design, and data validation/testing practices.
- Excellent communication, facilitation, and stakeholder management skills across technical and business audiences.
- Effective collaboration with cross-functional teams in fast-paced, cloud-based environments.
- Experience with segmentation techniques and advanced data design concepts is an asset.
- Proficiency with the MSOffice suite, including Word, Excel, Powerpoint, Teams, and Outlook.
- Experience with data pipelines and ETL processes in cloud environments.
- Familiarity with Python for data analysis or scripting.
- Experience with BI tools (e.g., Power BI, Tableau).
- Understanding of data modeling and warehouse design.
- Exposure to Agile or data product environments.
- Advanced SQL expertise across:
- AWS Redshift
- AWS Athena
- PostgreSQL
- Hands-on experience with AWS ecosystem, including:
- AWS Glue (jobs, configurations)
- AWS Lambda
- AWS Secrets Manager / Parameter Store
- Workflow orchestration (DAGs – e.g., Airflow or similar)
- CloudWatch (log querying and monitoring)
Compensation & Benefits:
Range $100,000 - $120,000 annually.
This range represents Wellington-Altus' expected range of compensation for this position. Actual compensation will vary and will be based on various factors, such as location, skills, experience, and qualification for the role. Compensation for part-time roles will be pro-rated based on number of hours regularly worked.
Wellington-Altus' total compensation package for employees may also include discretionary bonuses as well as other perks and rewards. Wellington-Altus also offers health insurance, accident and life insurance, and other unique benefits per location.
Conditions of employment:
- Must be legally eligible to work in Canada.
• A background check, satisfactory to the employer, may be required of the successful applicant prior to commencing employment.
Wellington-Altus Private Wealth is strongly committed to equity and diversity within its community and welcomes applications from women, racialized persons, Indigenous peoples, persons with disabilities, and persons of all sexual orientations and genders. All qualified individuals who would contribute to the further diversification of our organization are encouraged to apply.
If you require accommodation for the recruitment process, please let us know at the point of application.
To apply:
Click the Apply for This Job button to submit your resume, cover letter and salary expectations. You will be contacted if you are selected for an interview. Artificial Intelligence (AI) will be used to screen and assess candidates for this process.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.