Business Intelligence & Reporting Analyst

POSITION: Business Intelligence & Reporting Analyst REPORTS TO: Manager Business Intelligence DEPARTMENT: Planning & Development LOCATION: North Bay REFERENCE: 800-111-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 Intelligence & Reporting Analyst plays a critical role in delivering actionable, data-driven insights that support network planning, regulatory compliance, operational efficiency, and customer experience improvements at Ontario Northland. This role ensures that decisions are backed by comprehensive, accurate, and timely data, helping to optimize transportation services and align with strategic objectives. The Analyst works closely with Network Planning, Operations, and Compliance teams to develop reports, predictive models, and forecasting tools that drive informed decision-making. MAJOR DUTIES/ RESPONSIBILITIES: Collect, integrate, validate, and maintain internal and external data sources to ensure data accuracy, consistency, and reliability. Analyze complex datasets to identify trends, patterns, risks, and opportunities that support strategic planning, operational performance, and informed decision-making. Design, develop, and maintain reports, dashboards and scorecards that provide timely and actionable insights to stakeholders. Monitor, measure, and report on key performance indicators (KPIs) to evaluate operational effectiveness, service delivery, compliance, and business performance. Conduct ad-hoc analyses, forecasting, scenario modeling, and performance assessments to support business initiatives and operational planning. Collaborate with business stakeholders to understand reporting requirements, define success measures, and deliver data-driven solutions that meet departmental objectives. Translate complex analytical findings into clear, meaningful insights and recommendations for both technical and non-technical audiences. Ensure reporting processes, methodologies, and outputs comply with organizational policies, regulatory requirements, and data governance standards. Identify, recommend, and implement opportunities to improve data quality, automate reporting processes, and enhance operational efficiency. Develop and maintain documentation, including data definitions, reporting methodologies, business rules, and process standards to support consistency and knowledge sharing. Partner with cross-functional teams to support system enhancements, reporting initiatives, data integration projects, and continuous improvement efforts. Ensure analytics and reporting solutions align with organizational priorities, project objectives, and underlying system structures Promote a culture of data literacy, continuous improvement, and evidence-based decision-making across the organization. Adhere to organizational health, safety, and compliance requirements while performing all responsibilities REQUIREMENTS: College diploma in Mathematics, Statistics, Information Technology, Business Analytics, Transportation Planning, Data Science, or Computer Science Certification in data and reporting tools such as Power BI is required 3+ years’ experience as a data analyst or business intelligence analyst Minimum of 3 years of experience and demonstrated proficiency with the following tools: R or Python, Microsoft Power BI, Microsoft Fabric, SharePoint, Excel, and Google Analytics Experience using SQL for data querying and analysis is preferred Proficiency in data analysis techniques to interpret large datasets, identify trends, and extract actionable insights Experience with marketing campaign analysis and performance measurement Familiarity with agile methodologies and solution design practices Solid understanding of predictive modeling, demand forecasting, and performance analytics. Experience with regulatory compliance and transportation policy reporting is an asset Ability to translate complex data into actionable business insights and communicate findings clearly to both technical and non-technical audiences Focus on process automation and improving operational efficiency Strong analytical, problem-solving, and critical-thinking skills with attention to detail Commitment to health and safety. APPLICATION PROCESS: The successful candidate will need to pass the following clearances: criminal record check, employment references and education verification. CLOSING DATE: August 27, 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. 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.

The analyst is responsible for delivering data-driven insights to support network planning, operational efficiency, and regulatory compliance. This includes developing dashboards, predictive models, and KPIs to optimize transportation services and inform strategic decision-making.

Requires a college diploma in a quantitative or technical field and a certification in Power BI, along with 3+ years of experience in data or BI analysis. Proficiency in R, Python, Microsoft Fabric, and SQL is required or preferred for interpreting large datasets.

• Competitive salary • Excellent benefit package • Defined benefit pension plan • Paid vacation • Paid personal leave days • Discounted transportation on bus and passenger rail services

• Power BIPreferred
• SQLPreferred
• Data analysisPreferred
• PythonPreferred

Identified from the job description. Confirm important requirements above.

• Data Analysis
• Business Intelligence
• Power BI
• R
• Python
• Microsoft Fabric
• SQL
• Predictive Modeling
• Demand Forecasting
• KPI Reporting
• Data Integration
• Scenario Modeling
• Google Analytics
• Agile Methodologies
• Data Governance
• Stakeholder Management

• Data & Analytics
• Transportation
• Technology
• Government & Public Sector
• Logistics

Minimum education

Professional degree

Minimum experience

3+ years

Apply by

Sep 16, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available