Data & AnalyticsData Science, Business Intelligence
About the job
Requirements
A university degree in Business Administration, Business Analytics, Information Systems, Mathematics, Statistics, Information Technology, Data Science, Computer Science, or a related discipline is required.
Data and reporting certifications such as Power BI certification or business analysis certification (e.g., IIBA) are considered an asset.
A minimum of 3 years of recent experience in a Business Analyst or Data Analyst role supporting operational or corporate services functions, including translating business requirements into dashboards, reports, KPIs, and performance measures; using Power BI and Microsoft Fabric to support operational decision-making; and facilitating stakeholder discussions to define requirements and validate solutions.
Strong understanding of performance monitoring, forecasting, and predictive analytics.
Knowledge of business analysis and process improvement, including requirements elicitation, documentation and validation, business process analysis and mapping of current and future states, 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.
Knowledge of data and analytics tools, including Microsoft Power BI, Microsoft Fabric, SharePoint, SQL, and advanced Excel, including formulas, pivot tables, and data modeling.
Experience using R or Python for data analysis and automation is considered an asset.
A valid Class G Driver’s License is required.
Ability to analyze complex datasets, identify trends, and develop actionable business insights.
Ability to communicate complex analytical findings clearly to technical and non-technical audiences.
Problem-solving, critical-thinking, and attention-to-detail skills.
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 to develop insights into service delivery and support continuous improvement.
Support compliance 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 using historical and external data, validate predictions, and assess the impact of operational scenarios.
Present analytical findings, forecasts, and performance metrics to customers, management, and executives.
Support special projects and other assigned initiatives through data analysis, reporting, and actionable recommendations.
Desired Qualifications
Data and reporting certifications such as Power BI certification or business analysis certification (e.g., IIBA).
Experience supporting compliance, regulatory, or transportation-related reporting.
Experience using R or Python for data analysis and automation.
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 26, 2026, no later than 11:59 p.m. Qualified individuals are invited to apply in writing with a current covering letter and resume (provided in one document), stating reference name and number. Visit our career website to apply: https://www.ontarionorthland.ca/en/careers
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.