Business Intelligence Engineer

Best Workplaces in Canada 2020 - 2025 Best Workplaces with Most Trusted Executive TeamsBest Workplaces in Financial Services & Insurance 2020 - 2025 Best Workplaces for Mental Wellness 2023 - 2025 Best Workplaces for Giving BackBest Workplaces for InclusionBest Workplaces for Women 2021 Best Workplaces in OntarioBest Workplaces for Professional Development

One of Canadas Most Trusted Investment Brands.

AtPicton Mahoney Asset Management (PICTON Investments)being alternative isnt just what we doits who we are.

Founded by industry pioneer David Picton weve spent 20 years challenging conventional wisdom and redefining the investing landscape. As one of Canadas most trusted investment brands we are proudly independentprivately 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 thinkersone-third dedicated solely to investment managementwe are specialists not generalists. Managing $16.5 billion for institutional and retail clients we navigate markets with conviction resilience and a forward-thinking approach.

Were more than investors were 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 humanalways approachable.
• Succeed together one investment at a time.

These arent just wordsthey define how we think how we invest and how we work.

Now were entering our next chapter. Were 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 whats next.

Thriving in Our Entrepreneurial Culture

AtPICTON Investments youll thrive in our creative and dynamic workplace where collaboration and support are at the core of everything we do. At our firm youll 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. Youll 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 youll 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.

Youll 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 Were Looking For

• Bachelors 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

AtPICTON 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 Investmentsis 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 or at.

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

Required Experience:

Manager