Junior Business Data Analyst - Winter 2027 Co-op

Nexus Energy Inc.; Toronto; On-site; CAD 28,000 - 30,000; Part time

Job summary

Nexus Energy Inc. in Toronto, Ontario, invites a Junior Business Data Analyst co-op for Winter 2027 to bridge IT and business teams.

You will analyze data, improve processes, and develop solutions using MySQL, Python, and automation while supporting Settlements, Accounting, Sales and Trading. As part of a key internship project, you will build an energy market forecasting model using real-world data, collect and clean data, test approaches, backtest, and document methodology.

Qualifications

• Currently enrolled in a university or college program in Business Analytics, Computer Science, Data Science, Engineering, Mathematics, Finance, Economics, or a related field.
• Working knowledge of MySQL, including joins, aggregations, subqueries, and data validation.
• Working knowledge of Python for data analysis and automation.
• Strong analytical and quantitative problem-solving skills.
• Ability to translate business questions into clear data or system requirements.
• Close attention to detail and a commitment to data accuracy.
• Strong written and verbal communication skills.
• Ability to manage multiple requests, organize priorities, and meet deadlines.
• Self‑motivated, adaptable, and eager to learn unfamiliar business processes and technologies.
• Comfortable working collaboratively with both technical teams and business users.

Responsibilities

• Serve as a bridge between the IT team and business users across Settlements, Accounting, Sales, and Trading.
• Gather, clarify, document, and prioritize business and technical requirements for backend requests, system enhancements, reports, and data investigations.
• Use MySQL to retrieve, validate, reconcile, and analyze operational and financial data.
• Develop Python scripts and tools to automate recurring tasks, data checks, reporting workflows, and file-processing activities.
• Investigate data discrepancies and system issues, identify root causes, and work with team members to implement practical solutions.
• Support daily and ad hoc requests involving data extraction, database updates, reporting, troubleshooting, and internal applications.
• Assist with testing system changes, including preparing test cases, validating results, documenting defects, and supporting user acceptance testing.
• Create and maintain process documentation, data definitions, business requirements, and user guides.
• Help improve data quality, operational controls, and the reliability of business-critical workflows.
• Communicate progress, findings, risks, and recommendations clearly to both technical and non-technical stakeholders.
• Handle sensitive business and financial information with accuracy, care, and confidentiality.
• Key internship project involves developing a forecasting model for a predefined energy market rate.

Skills

Student status

MySQL

Python

Analytical skills

Communication

Education

Relevant degree area

Tools

MySQL

Python

Job description

Job Title: Junior Business Data Analyst - Winter 2027 Co-op

Department: IT Operations

Location: Toronto, ON (On-Site)

Wage: $20.00–$22.00 per hour

The final hourly rate will be determined based on the candidate’s year of study, relevant experience, previous co-op/internship experience, and specialized skills.

Job Type & Duration: Co-op, Winter Term

Note: This is a supervised, entry-level student placement designed to provide practical experience.

Company Overview

Nexus Energy Inc. is a privately held energy company headquartered in Toronto, Ontario, active in trading electricity across Eastern Canada, the Northeastern U.S., and Western markets, as well as providing power price risk management solutions to large commercial and industrial loads in Ontario. In addition, Nexus is actively working to develop a pipeline of renewable energy projects.

At Nexus, we foster a culture that values high performance, collaboration, and continuous development. You will join a passionate team that drives the business forward through innovation, accountability, and open communication.

This co-op offers hands‑on experience at the intersection of business, data, and technology within Nexus Energy. You will support teams across Settlements, Accounting, Sales, and Trading by analyzing data, improving processes, and developing solutions using MySQL, Python, and automation. As a key project, you will develop an energy market forecasting model using real-world data, gaining practical experience in forecasting and energy market applications.

What You Will Do

• Serve as a bridge between the IT team and business users across Settlements, Accounting, Sales, and Trading.
• Gather, clarify, document, and prioritize business and technical requirements for backend requests, system enhancements, reports, and data investigations.
• Use MySQL to retrieve, validate, reconcile, and analyze operational and financial data.
• Develop Python scripts and tools to automate recurring tasks, data checks, reporting workflows, and file-processing activities.
• Investigate data discrepancies and system issues, identify root causes, and work with team members to implement practical solutions.
• Support daily and ad hoc requests involving data extraction, database updates, reporting, troubleshooting, and internal applications.
• Assist with testing system changes, including preparing test cases, validating results, documenting defects, and supporting user acceptance testing.
• Create and maintain process documentation, data definitions, business requirements, and user guides.
• Help improve data quality, operational controls, and the reliability of business-critical workflows.
• Communicate progress, findings, risks, and recommendations clearly to both technical and non-technical stakeholders.
• Handle sensitive business and financial information with accuracy, care, and confidentiality.

Key Internship Project

During the internship, you will develop a forecasting model for a predefined energy market rate. With guidance from business and technical stakeholders, you will:

• Translate the established business objective into data and modeling requirements.
• Collect, clean, validate, and explore relevant historical market data.
• Analyze trends, seasonality, and other potential market drivers.
• Develop and compare forecasting approaches.
• Backtest the model and evaluate its performance using appropriate accuracy metrics.
• Create a repeatable process for updating forecasts as new data becomes available.
• Document the methodology, assumptions, limitations, and data requirements.
• Present the model, findings, and recommendations to stakeholders at the end of the term.

What You Will Bring

Minimum Skills & Qualifications

• Currently enrolled in a university or college program in Business Analytics, Computer Science, Data Science, Engineering, Mathematics, Finance, Economics, or a related field.
• Working knowledge of MySQL, including joins, aggregations, subqueries, and data validation.
• Working knowledge of Python for data analysis and automation.
• Strong analytical and quantitative problem-solving skills.
• Ability to translate business questions into clear data or system requirements.
• Close attention to detail and a commitment to data accuracy.
• Strong written and verbal communication skills.
• Ability to manage multiple requests, organize priorities, and meet deadlines.
• Self‑motivated, adaptable, and eager to learn unfamiliar business processes and technologies.
• Comfortable working collaboratively with both technical teams and business users.

Nice to Have

• Experience with forecasting, time-series analysis, statistics, or machine learning.
• Familiarity with Git, APIs, ETL processes, cloud platforms, or software development practices.
• Familiarity with the North American energy market is considered an asset but is not required.

What We Offer

• Hands‑on experience supporting multiple teams within a fast‑moving energy business.
• Mentorship from experienced data, IT, and business professionals.
• Opportunities to strengthen your skills in MySQL, Python, forecasting, automation, and business analysis.
• Exposure to energy‑market operations, settlements, accounting, sales, and trading.
• Team‑building and recreational events.

Accommodations

Nexus Energy Inc. is committed to fostering an inclusive and accessible work environment. We are committed to providing equitable treatment and accommodation to ensure barrier‑free employment by the Ontario Human Rights Code and Accessibility for Ontarians with Disabilities Act (AODA). If you require Code‑protected accommodations due to disability during the recruitment process, please communicate them when contacted, and we will ensure your needs are met.

AI Disclosure

Nexus Energy does not rely on artificial intelligence (AI) to evaluate or select candidates. Any AI features involved in the recruitment process are limited to external platforms we use (e.g., LinkedIn Recruiter) and are not used to make decisions about candidate suitability.

Nexus Energy Inc. would like to thank all applicants; however, only those who qualify will be contacted for an interview.