Business Intelligence Analyst

Ontario Northland; North Bay; On-site; CAD 84,000 - 98,000; Full time

Job summary

Ontario Northland Transportation Commission (ONTC) is seeking a Business Intelligence Analyst to join our North Bay team. Two positions are available to deliver data-driven insights for planning, compliance, efficiency, and customer project improvements.

You will build dashboards, KPIs, and forecasting models to support informed decisions. You will collaborate with Operations to translate business needs, develop actionable reports, and present findings to stakeholders, driving continuous

Qualifications

• University degree in a related discipline.
• Data and reporting certifications (Power BI, IIBA) are assets.
• Minimum 3 years in a Business/Data Analyst role supporting operational or corporate services.
• Experience translating business requirements into dashboards, reports, KPIs, and performance measures.
• Proficiency with Power BI, Microsoft Fabric, SQL, and advanced Excel.

Responsibilities

• Collect and manage data from internal and external sources for analysis.
• Analyze data to uncover trends informing planning, efficiency, and compliance.
• Design and develop reports and dashboards providing real-time insights to stakeholders.
• Track and analyze KPIs to support service delivery and continuous improvement.
• Collaborate with internal teams to tailor reporting solutions for objectives.
• Develop predictive forecasting models using historical and external data.
• Present analytical findings to stakeholders including customers, management, and executives.

Skills

Power BI

SQL

Forecasting

KPI Development

Data Visualization

Stakeholder Communication

Excel

Dashboards

Education

Bachelor's degree in Business Administration / Analytics

Tools

SQL

SharePoint

Microsoft Fabric

Visio

Job description

POSITION: Business Intelligence Analyst (2 Positions Available)

REPORTS TO: Sr. Project Manager Coach Projects

DEPARTMENT: Business Process

LOCATION: North Bay

REFERENCE: 390-96B-27

SALARY: $83,538 - $98,280

WHO WE ARE:

Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation services. We are a modern, forward-thinking organization focused on providing safe and reliable transportation services. ONTC has a rich history of over 120 years and strong connections to the communities we serve. With over 1200 skilled professionals, we work together to enhance transportation services and ensure that they are sustainable for future generations. We offer a dynamic workplace culture, along with a competitive salary, excellent benefit package, a defined benefit pension plan, paid vacation, paid personal leave days and discounted transportation on our bus and passenger rail services.

ACCOUNTABILITY STATEMENT:

The Business Analyst plays a critical role in delivering actionable, data-driven insights that support planning, compliance, efficiency, and customer project improvements at Ontario Northland. This role ensures that decisions are backed by comprehensive, accurate, and timely data, helping to optimize our services and align with contract requirements. The Analyst works closely with the Operations teams to develop KPIs, reports, predictive models, and forecasting tools that drive informed decision-making.

MAJOR DUTIES/ RESPONSIBILITIES:

• Collect and manage data from internal and external sources to ensure accurate, consistent, and comprehensive datasets for analysis.
• Analyze data to uncover trends, patterns, and insights that inform strategic planning, operational efficiency, and compliance.
• Design and develop reports and dashboards that provide real-time insights to stakeholders, ensuring solutions align with system data structures and support data-driven decision-making.
• Track and analyze key performance indicators (KPIs) to develop insights into service delivery and support continuous improvement.
• Support compliance and initiatives by ensuring data and reporting processes align with relevant standards and regulations.
• Identify opportunities to streamline data collection, reporting processes, and automation to improve efficiency.
• Document data handling processes, analysis methods, and reporting standards to ensure consistent practices and facilitate knowledge sharing.
• Collaborate with internal teams to understand data needs, provide ad hoc analysis, gather feedback on insights, and tailor reporting solutions to support strategic and operational objectives.
• Build, maintain, and refine predictive forecasting models leveraging historical and external data, validate predictions, and assess the impact of various operational scenarios.
• Present analytical findings, forecasts, and performance metrics to stakeholders including customers, management, and executives.
• Support special projects and other assigned initiatives through data analysis, reporting, and actionable recommendations.

REQUIREMENTS:

• University degree in Business Administration, Business Analytics, Information Systems, Mathematics, Statistics, Information Technology, Data Science, Computer Science, or a related discipline
• Data and reporting certifications such as Power BI certification or business analysis certification (e.g., IIBA) are considered an asset
• Minimum 3 years of recent experience in a Business Analyst or Data Analyst role supporting operational or corporate services functions including but not limited to:
  • translating business requirements into dashboards, reports, KPIs, and performance measures
  • using Power BI and Microsoft Fabric to support operational decision-making
  • facilitating discussions with stakeholders to define requirements and validate solutions
• Strong understanding of performance monitoring, forecasting, and predictive analytics
• Demonstrated knowledge of business analysis and process improvement, including requirements elicitation, documentation and validation, business process analysis and mapping (current and future state), stakeholder facilitation, and workshop delivery
• Familiarity with Agile or iterative solution design methodologies
• Experience supporting compliance, regulatory, or transportation-related reporting is considered an asset
• Proficiency with Microsoft Office applications and Visio
• Demonstrated knowledge of data and analytics tools, including Microsoft Power BI, Microsoft Fabric, SharePoint, SQL, and advanced Excel (formulas, pivot tables, and data modeling)
• Experience using R or Python for data analysis and automation is considered an asset
• Valid Class G Driver’s License
• Strong ability to analyze complex datasets, identify trends, and develop actionable business insights
• Ability to communicate complex analytical findings clearly to both technical and non-technical audiences
• Demonstrated problem-solving, critical-thinking, and attention-to-detail skills

APPLICATION PROCESS:

The successful candidate will need to pass the following clearances: criminal record check, employment references and education verification.

CLOSING DATE: October 25, 2026, no later than 11:59 p.m.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

If it is determined that any information provided in the application or during the recruitment process is false, misleading, or incomplete, Ontario Northland may discontinue your candidacy from further consideration.

At Ontario Northland, we are committed to employment equity. We value the unique skills and experiences each person brings to Ontario Northland and invite all interested individuals to apply and encourage applications from Indigenous peoples, racialized persons, women, persons with disabilities, and persons who identify as 2SLGBTQIA+.

Ontario Northland will provide accommodation to ensure barrier-free employment in accordance with the Canadian Human Rights Act and the Accessibility for Ontarians with Disabilities Act. You can request accommodation at any stage of the hiring process. If you require an accommodation, please contact Human Resources.

ONTC does not use artificial intelligence (AI) to make or inform hiring decisions. We do use an external applicant tracking system (ATS) to help manage applications efficiently. While the ATS may apply basic automated filters or sorting functions, all applications are reviewed and evaluated by human recruiters.

Les offres d'emploi sont également disponibles en français. Visitez notre site Web sur les carrières ou appelez le 1-800-363-7512, pour plus de renseignements.