Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data and Solutions Analyst

Full-time

Onit Energy

Ontario Wholesale Energy (OWE) is a leading provider of Natural Gas & Electricity Supply across North America. Alongside our sister divisions Canadian Water SavingsandCanadian Energy Savings Corp. we deliver innovative cost-effective energy and water conservation solutions to over44000 businesses. With over65 years of combined industry experience were not just shaping the future of utility management were leading it

We currently have an opening for a proactive and detail-oriented Data & Solutions Analyst to join our team.

As part of our Business Solutions Excellence team youll partner with leaders across operations finance sales and IT to design scalable reporting automate business processes and implement technology solutions that improve efficiency and drive better decision-making.

If youre someone who enjoys digging into data building elegant solutions and taking ownership of projects with minimal supervision wed love to hear from you.

What Youll Do

Drive Data-Driven Decision Making

  • Design build and maintain interactive dashboards and reports in Power BI and Excel .
  • Develop and optimize complex SQL queries to extract transform and analyze business data.
  • Create scalable data models using Power BI (DAX relationships calculated measures) and Power Query .
  • Analyze business performance identify trends and root causes and deliver actionable insights.
  • Establish data governance documentation and reporting standards that improve consistency and quality.

Build Automation & Modern Data Solutions

  • Develop automation and data workflows using Azure Functions and related Azure services.
  • Create automated business processes with Power Automate and the Microsoft Power Platform.
  • Design integrations between SQL databases cloud applications APIs and Excel.
  • Identify manual processes that can be automated and independently deliver scalable improvements.

Lead Business & Solution Analysis

  • Partner with stakeholders to understand business challenges and define solution requirements.
  • Document current and future-state business processes using process maps and workflow diagrams.
  • Translate business needs into user stories functional requirements and technical documentation.
  • Lead User Acceptance Testing (UAT) including test planning execution and validation.

Evaluate & Deliver New Solutions

  • Research evaluate and recommend software platforms and third-party solutions.
  • Conduct product evaluations and pilot programs.
  • Lead initiatives from evaluation through implementation and user adoption.

Collaborate & Influence

  • Serve as a trusted advisor to business stakeholders by translating data into meaningful business solutions.
  • Develop user documentation and deliver training for new reports tools and processes.
  • Partner with IT vendors and business leaders to implement enhancements and new technologies.
  • Mentor junior team members and contribute to best practices across the Business Solutions Excellence team.

Required Qualifications

  • 35 years of experience in Data Analytics Business Analysis Solutions Analysis or a related role.
  • Advanced SQL skills including complex queries optimization and data transformation.
  • Advanced experience with Power BI including DAX data modeling and interactive dashboard development.
  • Advanced Excel skills including Power Query complex formulas and automation.
  • Hands-on experience building automation and data workflows using Azure Functions and/or Azure data services.
  • Experience developing workflows using Power Automate or similar automation platforms.
  • Strong analytical and problem-solving skills with the ability to manage multiple priorities independently.
  • Excellent communication and stakeholder management skills.

Nice to Have

  • Experience in the energy retail industry (natural gas and electricity).
  • Knowledge of energy pricing billing and contract management systems.
  • Experience with Azure Data Factory Azure Synapse or similar cloud data platforms.
  • Experience with Python or other scripting languages.
  • Familiarity with API integrations and low-code application platforms.

At ONIT we are dedicated to fostering diversity equity and inclusion believing that all employees play a role in upholding our values. We encourage individuals from various backgrounds perspectives and life experiences to join us in addressing the worlds toughest challenges. Ensuring accessibility throughout the job application process is a priority for us at ONIT. If you require reasonable accommodations due to a disability whether visible or not please reach out to us at and we will gladly assist you

Required Experience:

IC

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data and Solutions Analyst in Toronto, ON vacancy
  •  ...Description Must Have ~6+ years of Business domain experience as a Data Analyst, including experience with client-facing products. ~ Strong...  ...points across services. ~ Working understanding of technical solution architecture from a product delivery perspective. What's... 
    Data
    Permanent employment
    Full time
    Local area

    Capgemini

    Toronto, ON
    4 hours ago
  • $86.34k per year

     ...institutional awards and honours. Your opportunity: As a Data Analyst, you will support the collection, management, analysis, and reporting...  ...to the continuous improvement of data processes and reporting solutions. You will play an important role in supporting data quality,... 
    Data
    Full time

    University of Toronto

    Toronto, ON
    14 days ago
  • $65k - $115k per year

    Data Analyst Position Description This role is hybrid and requires you to be at our downtown Toronto and/or Client office at a minimum...  ...design, develop, and deliver dashboards and reporting solutions, including Power BI dashboards. Analyze and interpret data from... 
    Data
    Work at office
    2 days per week
    Toronto, ON
    15 days ago
  •  ...Remote Data Analyst Company: IT Niche Location: Remote Employment Type: Full-time/ Part-time Job Overview IT Niche...  ...be central to our mission of delivering results-driven digital solutions by analysing performance across web design, SEO, and digital marketing... 
    Data
    Full time
    Part time
    Remote work

    Burjline Builders

    Toronto, ON
    8 days ago
  •  ...operations. We offer customized, flexible and integrated supply chain solutions, supported by a global technology platform and a dedicated,...  ...documents, costing analysis, pricing increase tracking, consolidating data from supply chain risk reviews and tracking part qualifications... 
    Data
    Work at office
    Local area
    Remote work
    Worldwide
    Flexible hours
    Shift work

    Celestica International LP

    Toronto, ON
    8 days ago
  •  ...their time to helping our clients transform their business, from strategy through implementation and business transformation.  Data Solutions Architect We are looking for a Data Solutions Architect to join our Data Solutions team!  As a Data Solutions Architect, you... 
    Data

    Spaulding Ridge

    Toronto, ON
    15 days ago
  • $110k - $140k per year

     ...We are  TRADER , a Canadian leader in digital automotive solutions. Our flagship brands - AutoTrader.ca, AutoSync, Dealertrack Canada...  ...future of automotive retail in Canada and beyond.   As  Senior Data Analyst you will join our Seller & Listing Analytics team. You will partner... 
    Data

    AutoTrader.ca

    Toronto, ON
    21 days ago
  • $50k per year

     ...contractor. Position Summary We are seeking a motivated Data Analyst (Co-op) to support the Quality Team in maintaining and enhancing...  ...to gather reporting requirements and translate them into data solutions Prepare and present clear, concise reports to support operational... 
    Data
    Full time
    Contract work
    For contractors

    FCC Construcción

    Toronto, ON
    22 days ago
  •  ...program specific requirements. ~Researches, collects and analyses data for reporting the effectiveness and efficiency of operations. ~...  ...team staff regarding data requirements for the future state solution, data analysis of the existing data in the City that requires cleansing... 
    Data
    Full time
    Temporary work
    Internship
    Work at office
    Shift work

    City of Toronto

    Toronto, ON
    7 days ago
  • $100k - $120k per year

     ...new phase of modernization and growth, with a focus on stronger data visibility, better decision-making, practical AI adoption, smarter...  .... About the Role Big Viking Games is hiring a Senior Data Analyst to support our live games, including YoWorld and FishWorld.... 
    Data
    Long term contract
    Full time
    Casual work
    Work at office
    3 days per week

    Big Viking Games

    Toronto, ON
    2 days ago
  •  ...About Metergy Solutions Inc. (“Metergy”)     Metergy has the energy, rapid growth and excitement of a startup, together with a rock-solid...  ...of infrastructure assets across the utilities, transport, energy, data and sustainable resources sectors. This sponsorship provides... 
    Data
    Long term contract
    Permanent employment
    Work at office
    Remote work

    metergysolutions

    Toronto, ON
    23 days ago
  •  ...public and private funds, providing asset servicing and operational solutions built for alternatives. With over $1 trillion in client assets...  ...translating business requirements into scalable reports, ensuring data integrity, improving reporting efficiency and enabling... 
    Data
    Full time
    Internship
    Worldwide

    MUFG Investor Services

    Toronto, ON
    18 days ago
  • $76k - $90k per year

     ...advertising and marketing channels. StackAdapt’s Solutions team focuses on developing and leading...  ...advertising products. As a Senior Analyst within the team, you will work on projects...  ...performance capabilities and roadmap. Utilize data analysis to inform and make strategic... 
    Data
    Local area
    Remote work
    Work from home
    Home office

    StackAdapt

    Toronto, ON
    23 days ago
  •  ...be responsible for supporting and building end-to-end technical solutions to support regulatory reporting of Scotia Capital Markets transactions...  ...root cause and business requirements analysis, aided by strong data and technical system analysis, to solutioning, development,... 
    Data
    Permanent employment

    Scotiabank

    Toronto, ON
    7 days ago
  • $94.8k - $144.8k per year

     ...Permanent Full Time - Enterprise Automation Technology is hiring a Solutions Architect within the Data Automation & Platforms team reporting to the Director of Technology Solutions. The Solutions Architect will collaborate with Portfolio & Technology teams as... 
    Data
    Permanent employment
    Full time
    Part time
    Internship
    Flexible hours

    Canada Life

    Toronto, ON
    1 day ago
  •  ...Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data...  ...value and leadership. We are seeking a highly motivated Data Analyst with strong data engineering and analytics experience to support... 
    Data
    Full time
    Manual labor
    Local area

    Tiger Analytics Inc.

    Toronto, ON
    9 days ago
  •  ...analytics stack and central tools. Zynga’s Data Science and Analytics team uses our...  ...identify critical data dependencies, and devise solutions for them in the form of efficient data...  ...internal costs. Collaborate with game analysts and product managers to better quantify... 
    Data
    Local area

    Zynga

    Toronto, ON
    more than 2 months ago
  •  ...evaluation, and consumer behaviour analysis. By leveraging data-driven insights and strategic solutions, they help businesses and top-tier brands optimize...  ...drive growth.   The Role  As a Consumer Insights Analyst, you will play a key role in a dynamic team, providing... 
    Data
    Permanent employment
    Full time

    aipconnect

    Toronto, ON
    a month ago
  • $118k - $152k per year

     ...Help shape modern data platforms and analytics solutions that enable smarter business decisions. Join Capco to bridge business needs with innovative data...  ...clients. The Role We're looking for a Business Systems Analyst / Data Engineer to combine strong business analysis... 
    Data
    Internship
    Immediate start

    Capco

    Toronto, ON
    20 days ago
  • $20 per hour

     ...decisions . Our platform ingests and reasons over large, messy data to surface evidence with hard constraints around fairness, auditability...  ...of the largest carriers in North America. As a Data Quality Analyst, you will play a pivotal role in leveraging data to ensure the... 
    Data
    Hourly pay
    Part time
    Remote work

    Owl.co

    Toronto, ON
    16 days ago
  •  ...operating system for Canadian businesses corporate cards business bank accounts bill payments all in one place. Reporting to the Head of Data this role is embedded inside the product teams behind two of those core pillars: banking infrastructure and payments. Both are... 
    Data
    Full time
    Work at office

    Float

    Toronto, ON
    1 day ago
  • $67 per hour

    Our client, a Top 5 bank in Canada is looking to hire a Business Analyst - Data Governance team for an initial 6-month contract with a high possibility of extension and conversion. This role is 2 days a week in the office in downtown Toronto. Requirements gathering: Collaborate... 
    Data
    Contract work
    Work at office
    2 days per week
    Toronto, ON
    a month ago
  •  ...Looking for a new team member to help us continue to provide quality data service and support our clients come to rely on. This position...  ...programs on behalf of our client. The Data Support Analyst position is ideal for someone looking to gain experience with program... 
    Data
    Contract work
    Work at office

    CMG Marketing

    Toronto, ON
    9 days ago
  • $80k - $120k per year

     ...No two days are the same at Agoda. Data and technology are at the heart of our culture...  ...Opportunity:   As a Data Scientist/Senior Analyst, you will report directly to either the Senior...  ...to build simple but clever and elegant solutions to new problems within significant resource... 
    Data
    Long term contract
    Work at office
    Worldwide
    Afternoon shift

    Agoda

    Toronto, ON
    8 days ago
  • $110k - $160k per year

     ...Continued growth has created an exciting opportunity for a  Data Engineering Solutions Architect (Manager/Senior Manager Level) to join our Technology Services Group.   In this role, you will design and build modern data solutions that combine robust data engineering practices... 
    Data
    Full time
    Shift work

    optimussbr

    Toronto, ON
    13 days ago
  • $67 per hour

    Our client, a top banking client in Canada is looking to hire a Business Analyst - Data Governance role for their team with a contract of 6 months which is renewable. This role 2 days a week in the office for their Toronto office. Data Governance Framework Development - Support... 
    Data
    Contract work
    Work at office
    2 days per week
    Toronto, ON
    more than 2 months ago
  •  ...Caseware, we are at the forefront of this transformation, defining and building the future of accounting technology. We seek a Product Analyst, Data Platform and Analytics to play a critical role in  advancing our metric driven culture  within our Product Organization.   You... 
    Data
    Permanent employment
    Full time
    Work at office
    3 days per week

    caseware

    Toronto, ON
    a month ago
  •  ...effectively leveraging SAP and other enterprise technology. The Master Data Analyst is responsible for managing and maintaining the quality and...  ...with Business Process owners, to provide end-to-end technology solutions implementation and Master Data enablement. Data Maintenance... 
    Data
    Long term contract
    Contract work
    Work at office

    Riverside Natural Foods Ltd.

    Toronto, ON
    2 days ago
  •  ...important work of your career. About the team Data Science at Stripe is a vibrant community where data analysts, data scientists, and engineers learn and grow...  ...drive business impact through rigorous analytical solutions Apply machine learning, causal inference, or... 
    Data
    Summer work
    Internship
    Immediate start

    Stripe

    Toronto, ON
    more than 2 months ago
  •  ...Technical Solution Lead - GCP Data Integration (Business Banking) Role Description Act as the end-to-end technical owner for business banking initiatives. Strong knowledge of business banking data. Lead solution design for real-time and batch integrations... 
    Data
    Full time

    Astra North Infoteck Inc.

    Toronto, ON
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data and Solutions Analyst. Be the first to apply!