Apply now »

Reporting and Database Analyst

Job ID: 908

Position Type: Union Temporary

Department: Technology & Cyber Security

Salary Grade: 6 ($86,210 - $101,349) 

Job Posting Close Date:  

 

The Ontario Energy Board is proud to be recognized as one of Greater Toronto’s Top Employers for four years running.  

Our success resides with our people and we take great pride in fostering a workplace culture that attracts top-tier professionals passionate about shaping Ontario’s energy future. Our reputation as a preferred employer reflects our commitment to helping deliver clean, reliable, affordable and secure energy that enables economic growth across the province.

Our One OEB culture promotes a values-driven, collaborative workplace where diverse perspectives come together to deliver regulatory excellence, and where we encourage curiosity and agility in an environment that is grounded in mental health, wellbeing and a foundational commitment to Diversity, Equity and Inclusion.   
 

We are the ONTARIO ENERGY BOARD.

 

Overview

Under the direction of the Director, the Reporting and Database Analyst will be responsible for the design, development, implementation, and ongoing support of the enterprise information repositories, including databases, data warehouse, and related applications. 

This position will assess database and reporting requirements, develop, and implement data/document management and reporting solutions.  The Reporting and Database Analyst will ensure users and clients are supported with best practices in data management, reporting, and business intelligence. 

Responsibilities

Database Development:

  • Analyze department requirements to design and develop database, reporting and document management solutions.
  • Develop databases and related applications ensuring client/user requirements are addressed.
  • Maintain and monitor the data warehouse.
  • Develop and support data collection and data entry/import solutions, such as input forms and packages.

Database Maintenance:

  • Support the development of information repository and business application systems enhancement projects.
  • Provide information repository expertise on larger, more complex integrated projects.
  • Provide project expertise on application design and architecture.
  • Collaborate with IT team to review and recommend system enhancements to meet corporate objectives.
  • Support business users and provide expertise with technical issues.
  • Maintain appropriate authorization in database systems.
  • Support indexing and other database maintenance work to ensure high performance.
  • Support the Data Governance Framework, as needed.
  • Develop and maintain documentation.
  • Monitor database and server performance, and complete tuning if needed.

Reporting Development:

  • Complete data validation and data cleaning to prepare data for reporting.
  • Generate metrics related to critical information, such as performance, variance, and analyses strategic, operational and resource allocation decisions and actions.
  • Interpret high level business needs into functional needs by understanding issue and determining data requirements.
  • Prepare reports synthesizing analytical results, highlighting implications of findings.
  • Maintain and update current reports and dashboards.
  • Collaborate with business areas to define new reporting requirements.
  • Develop new reporting based on identified business needs.
  • Develop automated reports and reporting tools using programming.
  • Develop and maintain data models and data repositories.
  • Maintain appropriate authorization in business intelligence environments.

Qualifications

  • University degree in Computer Science, Information Technology, Business Intelligence, Information Management, or related discipline.
  • Degree in Computer Science with specialty in related field.
  • 2 years’ experience in Information Technology design and system implementation, working in a regulated industry and/or public utility.
  • 3 years’ progressive experience in Information Technology design and system implementation in a regulated industry or public utility setting.
  • Advanced knowledge in Microsoft Office (Word, Excel, Dynamics, PowerAutomate, PowerPoint, Access, Teams, SharePoint).
  • Working knowledge of SQL, Python, JavaScript, Visual Basic, Visual Basic for Applications to assist with the querying of data.
  • Proficient with programs and tools such as Microsoft SQL Server and Microsoft Reporting Services Tools, as well as Business Intelligence solutions such as Oracle BI, PowerBI, Tableau or Sisense.
  • Completion of Azure Services and PowerBI Training/Courses, with a Microsoft Learning Partner is preferred.

This job posting represents an existing vacancy. 

Pursuant to the Accessibility for Ontarians with Disabilities Act, the Ontario Energy Board will make reasonable efforts to provide accommodation to candidates with disabilities in the course of the recruitment process upon written request. We request that candidates seeking accommodation identify their particular accommodation needs as soon as possible in the job selection process. Questions concerning the availability of accommodation in the recruitment process may be forwarded by email to hr@oeb.ca.

Apply now »