Business Intelligence Engineer

Picton Mahoney; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading investment firm in Toronto is seeking a Business Intelligence Engineer to build and optimize BI solutions that enable data-driven decision-making. In this hands-on role, you will design dashboards and reports while collaborating with various teams to translate business needs into actionable insights. The ideal candidate has approximately 5 years of experience in BI, strong SQL skills, and is familiar with BI tools like Tableau and Power BI. Enjoy a dynamic workplace that values creativity and collaboration.

Benefits

Competitive total rewards

Performance-based bonuses

Training and development reimbursement

Health and dental benefits

Qualifications

• Approximately 5 years of experience in business intelligence, analytics, or data-focused roles.
• Strong hands-on experience with BI tools.
• Advanced SQL skills and understanding of data modeling principles.

Responsibilities

• Build, maintain, and optimize BI solutions for data-driven decision-making.
• Design, build, and maintain dashboards and reports.
• Partner with data engineers and stakeholders to translate business requirements.

Skills

BI tools (e.g., Tableau, Power BI)

SQL

Data Modeling

Communication skills

Education

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

Tools

Tableau

Power BI

SQL

Snowflake

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 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.5 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 seeking a 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.

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.
• 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 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!

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. 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.