Business Intelligence Architect – Data Strategy & Analytics

Solen Software Group; Toronto; Hybrid; CAD 80,000 - 110,000; Part time

Job summary

A technology services firm in Toronto is looking for a Business Intelligence Architect to lead data strategy and analytics initiatives. The ideal candidate will have at least 3 years of experience with Power BI and SQL, enabling them to develop data-driven insights for operations and finance. This position offers a hybrid working option and focuses on collaboration and analytics in a fast-paced environment.

Benefits

Career growth opportunities

Collaborative work environment

Impactful analytics projects

Qualifications

• 3+ years of experience with Power BI, DAX, and dashboard development.
• Strong SQL skills with data extraction, transformation, and loading.
• Experience with big data tools and scripting languages.

Responsibilities

• Lead the company's data strategy and governance.
• Design and maintain data models for accurate business representation.
• Perform deep analysis to uncover actionable insights.

Skills

Power BI

SQL

Data Governance

Data Modeling

Stakeholder Management

Tools

Python

ETL Tools

Sage Intacct

Job description

Business Intelligence Architect – Data Strategy & Analytics

Business Intelligence Architect – Data Strategy & Analytics

Job Title : Business Intelligence Architect – Data Strategy & Analytics

Company : Solen Software Group

Location : Toronto, Canada

Employment Type : Contract

About Solen Software Group : Solen Software Group is an evergreen holding company that acquires and operates proven software businesses that have significant growth potential in a variety of vertical markets, enabling them to be market leaders in their niche industry. Solen owns several software companies in various market spaces : Human Resource Technology, Fleet Telematics, Asset Management, E-Health, Document Management, and other innovative software solutions in a variety of industries. Solen is backed by a group of advisors and investors that have built software businesses of material scale (10-100M in ARR) and advised many.

About the role : We’re seeking a highly skilled Business Intelligence Architect to lead our data strategy and analytics initiatives. This role bridges the gap between raw data and strategic insights, helping the company make data-driven decisions across operations, finance, and portfolio management. You'll collaborate with stakeholders, design scalable data solutions, and develop compelling dashboards and models to visualize business performance—especially within a private equity operating context.

The successful candidate will work from close to our offices in Toronto / Hybrid.

Key Responsibilities

Lead Data Strategy & Governance

• Act as the strategic liaison for aligning enterprise data strategy with business objectives.
• Create and centralize data connections across platforms (e.g., Sage Intacct), within a governed and standardized data framework.
• Champion DRY (Don’t Repeat Yourself) development principles and scalable data infrastructure.
• Define and implement data governance policies to ensure consistency, accuracy, and security across systems.
• Build reusable routines for collaborative reporting and company-wide analytics enablement.

Build and Optimize Data Solutions

Design and maintain robust data models for consistent and accurate representation across business domains.

Transform raw data into structured datasets using ETL tools and best practices.

Develop and optimize Power BI dashboards and reports to visualize key performance indicators (KPIs), trends, and insights.

Ensure ongoing optimization and performance tuning of Power BI solutions.

Data Analysis & Business Insight Delivery

Perform deep data analysis to uncover trends, patterns, and actionable insights.

Construct predictive and descriptive analytics models to support strategic initiatives.

Translate technical findings into business-friendly insights to drive value creation and efficiency.

Partner with Finance, Operations, and leadership to deliver visibility into company and portfolio-level performance.

Stakeholder Collaboration & Training

Work closely with business users, portfolio company teams, and internal departments to gather and translate data needs into technical solutions.

Train and support end-users in navigating and utilizing Power BI dashboards and analytics tools.

Support deal execution teams by contributing to financial modeling, diligence activities, and performance tracking of portfolio companies.

Support Private Equity-Specific Data Needs

Understand the private equity investment lifecycle, from deal sourcing to post-investment monitoring.

Provide analytics support for investment decisions, deal execution, and operational improvements across portfolio companies.

Drive insights to support value creation planning, portfolio monitoring, and board reporting.

Key Requirements

3+ years of experience with Power BI (desktop and service), including DAX, data modeling, and dashboard development are mandatory.

Strong SQL skills and experience with data extraction, transformation, and loading (ETL).

Experience with big data tools and scripting languages (e.g., Python, Teradata).

Experience with Sage Intacct is an asset.

Solid understanding of data governance, architecture, and best practices.

Proven track record in building data models and delivering actionable insights to stakeholders.

Ability to communicate complex data concepts to both technical and non-technical audiences.

Experience in project and stakeholder management.

Nice-to-Have Skills

Experience with Datameer, Tableau, or other BI tools.

Familiarity with private equity (PE) or venture capital (VC) operations.

Background in financial modeling or deal analysis.

Automation skills using Python or PySpark.

Experience with implementing enterprise data platforms and analytics strategies.

What’s In It For You

Play a pivotal role in shaping the company’s data strategy and analytics maturity.

Work within a collaborative, high-performance environment at the intersection of operations, finance, and investment.

Make a measurable impact through the delivery of real-time, data-driven insights.

Opportunities for career growth and continuous learning in a forward-thinking, analytics-first culture.

We thank all applicants for their interest; however, only those selected for an interview will be contacted.

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Contract

Job function

Job function

Business Development and Sales

Industries

Venture Capital and Private Equity Principals

Referrals increase your chances of interviewing at Solen Software Group by 2x

Get notified about new Business Intelligence Architect jobs in Toronto, Ontario, Canada .

Revenue Operations Lead, Business Intelligence

Greater Toronto Area, Canada 15 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr