Business Intelligence Analyst

NextGenEnergyJobs; Toronto; Hybrid; CAD 70,000 - 95,000; Full time

Job summary

Metergy is seeking a data analytics professional to extract, clean and analyze large data sets, delivering insights to optimize operations and revenue drivers.

You will partner with stakeholders across teams, develop actionable BI reports using Power BI and SQL, and contribute to cost reduction and performance opportunities. 2+ years in a fast-growing utility environment is preferred.

Qualifications

• Degree in quantitative field such as statistics, CS, math, economics or business.
• Strong data modelling and analysis using Excel, Power BI, SQL.
• Python knowledge is a plus.
• 2+ years in data analytics/operations at a fast-growing utility company preferred.
• Experience with data visualization tools.
• Excellent collaboration with stakeholders.
• Understanding revenue and costing data to reduce costs.
• Strong ability to mine large data volumes.

Responsibilities

• Extract, clean, and analyze large data sets to identify trends.
• Conduct deep dive BI analysis into operations to reveal KPI relationships.
• Collaborate with stakeholders to develop insights for leadership.
• Provide monthly management insight for performance opportunities.
• Accountable for understanding regulations and launching projects.
• Plan, develop and approve operational policies and quality systems.
• Monitor daily performance against key metrics and identify anomalies.
• Review processes and propose improvements with strategic impact.
• Support lead-to-cash processes across revenue streams.
• Stay updated on BI trends and new tools.

Skills

Data modelling

Power BI

SQL

Excel

Python (basic)

Stakeholder collaboration

Revenue/cost analysis

Education

Degree in Statistics, Computer Science, Math, Economics, Business or related quantitative field

Tools

Python

Job description

Metergy has the energy, rapid growth and excitement of a startup, together with a rock-solid, recession-proof business that has a 45 year track record.

Key Responsibilities

• Extract, clean, and analyze large volumes of data to identify trends, patterns, and insights.
• Conduct deep dive business intelligence analysis into operational areas within Operations to provide analysis and insight on the interplay between the various key performance indicators (e.g., workforce performance & management, Revenue Assurance, productivity, cost and quality drivers).
• Effectively collaborate with stakeholders to develop insights and recommendations to enable strategic discussions among leadership.
• Provided monthly management insight for performance opportunities, financial Rate and Volume variance analysis to help identify resource allocation opportunities
• Accountable for understanding regulation changes and launching organizational projects to implement changes in all impacted areas in submetering (includes non-responsible departments)
• Plans, develops and approves all operational policies in all functional areas, with standard operating procedures, and quality management systems for revenue assurance
• Monitor daily performance against key metrics to identify opportunities and anomalies
• Constantly review current operational processes and be a strategic partner in making recommendations for improvements
• Work with all departmental owners to implement and ensure controls are in place to support the lead to cash process for all (billing model) revenue streams
• Develop and champion revenue leakage issues across organization by engaging key stakeholders on activity and resource requirements necessary to drive revenue maximization
• Stay updated on the latest trends in Business Intelligence, data analytics and emerging technologies
• Evaluate and incorporate new tools or techniques that could enhance BI capabilities.

Requirements

• Degree in Statistics, Computer Science, Math, Economics, Business or other quantitative fields.
• High proficiency in data modelling and analysis with demonstrated acumen using the following tools Excel, PowerBI (Power Query) & SQL
• Basic knowledge of Python is an asset
• 2+ years of experience in Data Analytics, Operations, or relevant work experience at a fast-growing utility company is preferred.
• Preference to additional training with Data Analytics / IT
• Preference for experience with data visualization tools
• Excellent collaboration skills to build strong working partnerships with stakeholders.
• Understanding and experience working with statistical revenue and costing information to provide business insight and opportunities to reduce cost.
• Strong technical skills to mine large volumes of data.
• Ability to apply superior data knowledge & discovery skills into building effective analysis.
• Ability to conduct basic statistical and correlation analysis to identify patterns and trends.
• Industry or working experience with customer billing environments with large transaction volumes such as Utility or Telecommunications
• Attention to detail and quality, strong time management and project/work planning skills.
• Proven ability to work with and deliver Industry Leading Best-in-Class reporting and analytical solutions.
• Excellent interpersonal and customer interaction skills to include communications, presentation and conflict resolution skills.