Senior Business Intelligence Engineer

Picton Mahoney Asset Management; Toronto; On-site; CAD 115,000 - 135,000; Full time

Job summary

A leading investment management company in Toronto is seeking a Senior Business Intelligence Engineer to build and optimize BI solutions for data-driven decision-making. This hands-on engineering role involves creating dashboards and reports using tools such as Tableau or Power BI. The expected salary ranges from $115,000 to $135,000, with bonuses and an employee ownership program. We value innovative thinking and offer a dynamic workplace culture designed for ambitious professionals looking to make an impact.

Benefits

Full benefits package

Profit sharing

Health and wellness coverage

Paid time off and holidays

Learning and development programs

Qualifications

• Approximately 5-10 years of experience in business intelligence or data-focused roles.
• Experience working with data warehouses like Snowflake.
• Strong understanding of data modeling principles.

Responsibilities

• Build, maintain, and optimize BI solutions.
• Partner with teams to translate business questions into insights.
• Ensure BI outputs are accurate and performant.

Skills

Strong hands-on experience with BI tools

Advanced SQL skills

Effective communication skills

Familiarity with ETL/ELT processes

Experience in financial services

Education

Bachelor’s degree in Data Analytics, Computer Science, Business, or related field

Tools

Tableau

Power BI

SQL

Job description

Best Workplaces™ in Canada 2020 - 2025 | Best Workplaces™ with Most Trusted Executive Teams 2024, 2025 | Best Workplaces™ in Financial Services & Insurance 2020 - 2025 | Best Workplaces™ for Mental Wellness 2023 - 2025 | Best Workplaces™ for Giving Back 2022, 2024 | Best Workplaces™ for Inclusion 2021, 2024 | Best Workplaces™ for Women 2021 | Best Workplaces™ in Ontario™ 2020, 2021, 2024 | 2025 Best Workplaces™ for Professional Development

One of Canada’s Most Trusted Investment Brands.

At Picton Mahoney Asset Management (PICTON Investments), being alternative isn’t just what we do—it’s who we are.

Founded by industry pioneer David Picton, we’ve spent 20 years challenging conventional wisdom and redefining the investing landscape. As one of Canada’s most trusted investment brands, we are proudly independent—privately run, 100% employee-owned, and deeply committed to delivering results for our clients.

Thinking Alternatively is in Our DNA.

With a team of 203 bold thinkers—one-third dedicated solely to investment management—we are specialists, not generalists. Managing $16.6 billion for institutional and retail clients, we navigate markets with conviction, resilience, and a forward-thinking approach.

We’re more than investors — we’re innovators. We challenge traditional investment mindsets, constantly pushing the boundaries to achieve our mission: To bring greater certainty to investors.

Our success is built on four guiding principles:

• Treat investors’ money like our own.
• Redefine the way investors invest.
• Be human—always approachable.
• Succeed together, one investment at a time.

These aren’t just words—they define how we think, how we invest, and how we work.

Now, we’re entering our next chapter. We’re transforming our brand and reshaping the way the world invests. If you think alternatively, embrace an entrepreneurial spirit, and thrive in a dynamic, bureaucracy-free environment, join us and be part of what’s next.

Thriving in Our Entrepreneurial Culture

At PICTON Investments, you’ll thrive in our creative and dynamic workplace, where collaboration and support are at the core of everything we do. At our firm, you’ll have the opportunity to take on significant responsibilities, work in a flexible environment, and tackle challenging projects from the outset. Our culture is designed for ambitious professionals who want to make an immediate impact while continuing to push boundaries and achieve our greater mission. You’ll be empowered with a high level of responsibility, trust, and flexibility, providing an exciting and creative space for you to help reshape how the world views alternative investments. With competitive total rewards, performance‑based bonuses, and a clear path for career growth, you’ll have everything you need to develop both now and over the longer term.

The Opportunity

We are currently seeking a Senior Business Intelligence Engineer to join our team. This role is responsible for building, maintaining, and optimizing BI solutions that enable data‑driven decision‑making across PICTON Investments.

This is a hands‑on engineering role focused on delivering high‑quality dashboards, reports, and data models. You will partner closely with data engineers, data scientists, and business stakeholders to translate business questions into reliable, scalable insights.

The expected annual base salary for this role is $115,000 – $135,000, with the final number depending on your experience, skills, and education. On top of that, you’ll be eligible for our discretionary bonus program.

At Picton, being employee‑owned means we take care of our team and offer opportunities for top performers to participate in our equity ownership program over time. Eligible employees get access to a full benefits package, including profit sharing, health and wellness coverage, life and disability insurance, paid time off and holidays, learning and development programs, and more, many of which are fully covered or subsidized by us.

You’ll Have the Opportunity to Learn and Lead

BI Development & Reporting

• Design, build, and maintain dashboards, reports, and self‑service analytics using BI tools such as Tableau or Power BI.
• Design intuitive, visually compelling dashboards grounded in strong data visualization and UX principles, enabling fast, confident decision‑making.
• Translate business requirements into clear metrics, KPIs, and visualizations.
• Ensure BI outputs are accurate, performant, and easy for stakeholders to use.

Data Modeling & Analytics

• Develop and maintain data models and semantic layers to support reporting and analytics needs.
• Write optimized SQL queries for ad‑hoc analysis and production BI assets.
• Partner with data engineering to improve data availability, reliability, and structure.

Stakeholder Collaboration

• Work with teams across Investments, Sales, Marketing, Operations, and Finance to understand reporting needs and define KPIs.
• Present insights in a clear, practical manner to both technical and non‑technical audiences.

Data Quality & Governance

• Support data quality and governance initiatives by identifying data gaps, inconsistencies, and improvement opportunities.
• Adhere to data security, privacy, and compliance standards.

Continuous Improvement

• Contribute to BI standards, documentation, and best practices.
• Stay current on BI tools, visualization techniques, and analytics trends to continuously improve BI outputs.

What We’re Looking For

• Bachelor’s degree in Data Analytics, Computer Science, Business, or a related field.
• Approximately 5‑10 years of experience in business intelligence, analytics, or data‑focused roles.
• Strong hands‑on experience with BI tools (e.g., Tableau, Power BI, Qlik).
• Advanced SQL skills and a solid understanding of data modeling principles.
• Experience working with data warehouses (e.g., Snowflake or similar platforms).
• Familiarity with ETL/ELT processes and modern analytics workflows.
• Strong communication skills and the ability to translate data into actionable insights.
• Experience in financial services or investment management is an asset.
• Exposure to cloud platforms (AWS, Azure, or GCP) is a plus.

Our Commitment to Employees

At PICTON Investments, we take pride in enhancing our employees’ experiences through a comprehensive suite of exceptional perks and programs. Our benefits include corporate fitness reimbursement and discounts, VersaFi memberships (formerly Women in Capital Markets), Picton investment counseling and portfolio management services, volunteer and charitable donation matching, maternity and parental leave top‑up, recognition awards, semi‑annual performance bonuses, a generous annual vacation entitlement (minimum of 15 days per year), training and development reimbursement, extensive health and dental benefits, a healthcare spending account, and more.

These offerings are designed to support your career growth, well‑being, and overall success. Join us and thrive in an environment that values and invests in you!

Equity, Diversity & Inclusion

PICTON Investments is committed to providing an equitable and fair work environment for everyone and all hiring and other personnel actions will be taken without regard to race, colour, creed, religion, sex, disability, gender identity, gender expression, family status, age, language or national origin. We welcome applications from candidates with diverse experiences globally. Canadian experience is not required. If you require an accommodation at any point in time throughout the application and hiring process, please contact Human Resources at (416) 955‑4108 or at [e-mail].

PICTON Investments does not accept unsolicited resumes, emails, calls, or any other form of communication from third‑party recruitment agencies. Any unsolicited outreach, including commercial electronic messages, will neither be acknowledged nor considered.

Please note: We use AI‑assisted tools to support parts of our recruitment process, including summarizing interview notes and aligning candidate profiles with job requirements. All decisions are made by our hiring team.