Business Intelligence & Reporting Analyst
Business Intelligence & Reporting Analyst
Posted on :
03-08-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
POSITION: Business Intelligence & Reporting Analyst
REPORTS TO: Lead Business Intelligence
DEPARTMENT: Business Planning & Intelligence
LOCATION: North Bay
REFERENCE:
SALARY: $81900 - $96356
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 1000 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 is responsible for delivering actionable data-driven insights that support network planning regulatory compliance operational efficiency and customer experience. This role ensures decisions are informed by accurate timely data and works closely with Network Planning Operations and Compliance teams to develop reports predictive models and forecasting tools aligned with strategic goals.
MAJOR DUTIES/ RESPONSIBILITIES:
REQUIREMENTS:
BACKGROUND INVESTIGATION: The successful candidate will need to pass the following clearances: criminal record check employment references and education verification.
CLOSING DATE: August 11 2025 no later than 11:59 p.m. We thank all applicants for their interest; however only those selected for an interview will be contacted. 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: 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.
Les offres demploi sont galement disponibles en franais. Visitez notre site Web sur les carrires ou appelez le 1- poste 394 pour plus de renseignements.
REPORTS TO: Lead Business Intelligence
DEPARTMENT: Business Planning & Intelligence
LOCATION: North Bay
REFERENCE:
SALARY: $81900 - $96356
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 1000 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 is responsible for delivering actionable data-driven insights that support network planning regulatory compliance operational efficiency and customer experience. This role ensures decisions are informed by accurate timely data and works closely with Network Planning Operations and Compliance teams to develop reports predictive models and forecasting tools aligned with strategic goals.
MAJOR DUTIES/ RESPONSIBILITIES:
- Collect manage and validate internal and external data to ensure accuracy and consistency.
- Analyze data to uncover insights that support strategic planning operational efficiency and compliance.
- Design reports and dashboards that deliver real-time actionable insights to stakeholders.
- Track KPIs and evaluate internal service delivery to drive continuous improvement.
- Ensure data practices and reporting align with compliance and regulatory standards.
- Identify and implement opportunities to streamline data collection reporting and automation.
- Document data processes and standards to support consistency and knowledge sharing.
- Collaborate with teams to understand data needs and tailor insights accordingly.
- Design dashboards scorecards and analytics tools to support decision-making.
- Track KPIs to evaluate efficiency compliance and service delivery.
- Ensure reporting solutions align with system structures and project objectives.
- Build maintain and refine predictive models using historical and external data relevant to Corporate Services.
- Conduct ad hoc analyses support special projects and run forecasting scenarios to assess operational impacts.
- Forecast internal service demand (e.g. IT procurement) to optimize resource allocation.
- Continuously validate and improve model accuracy based on new data.
- Present forecast metrics and strategic insights to Lead Business Intelligence.
- Collaborate with stakeholders to tailor reports to department-specific needs.
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 mandatory.
- 3 years experience as a data 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.
- Proficiency in data analysis techniques to interpret large datasets identify trends and extract actionable insights.
- Experience with SQL for data querying and analysis and business process analysis is preferred.
- 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 preferred.
- 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.
BACKGROUND INVESTIGATION: The successful candidate will need to pass the following clearances: criminal record check employment references and education verification.
CLOSING DATE: August 11 2025 no later than 11:59 p.m. We thank all applicants for their interest; however only those selected for an interview will be contacted. 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: 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.
Les offres demploi sont galement disponibles en franais. Visitez notre site Web sur les carrires ou appelez le 1- poste 394 pour plus de renseignements.
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
