Analyst, Reporting and Database - Toronto, Canada - Ontario Energy Board

Ontario Energy Board

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Overview:

Recognized as one of Greater Toronto's Top Employers for 2023, we are Ontario's independent regulator of the electricity and natural gas sectors.

We are compelled by our desire to become a globally recognized top tier regulatory agency. We are passionate about the environment and motivated by our want to enable innovation within the energy sector.

We are committed to the economic and social development of Ontario and work every single day to deliver public value to Ontarians.

We are a diverse, driven, transparent and thoughtful team, and are accountable to each other, the sector, and the customers we serve.

Responsibilities:

Analyze department requirements to design and develop database, reporting and document management
Maintain and monitor the data warehouse
Develop and support data collection and data entry/import solutions, such as input forms and packages
Provide information repository expertise on larger, more complex integrated projects
Collaborate with IT team to review and recommend system enhancements to meet corporate objectives
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

Qualifications:

University degree in Computer Science, Information Technology, Business Intelligence, Information Management, or related discipline
2 years' experience in Information Technology design and system implementation, working in a regulated industry and/or public utility
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