Analyst, Reporting And Database

This Division is responsible for all aspects of corporate financial management and reporting, information technology strategies and plans as well as other organizational service functions including procurement, risk management, internal audit, emergency/contingency planning, and facilities management.

Under the direction of the Director, the Analyst will develop, implement, and provide technical support of the enterprise information repositories, including databases, data warehouse, and related applications. In this role you will responsible for assessing database and reporting requirements, develop, and implement data/document management and reporting solutions. The Analyst will ensure users and clients are advised of data and document management techniques and technologies.

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 customers we serve. We are the ONTARIO ENERGY BOARD (OEB).

Responsibilities:

• Collaborate with IT team to review and recommend system enhancements to meet corporate objectives
• Analyze department requirements and recommend updates in database systems, reporting and document management strategies
• Interpret high level business needs into functional needs by understanding issue and determining data requirements
• Advise, develop, test, and maintain specialized information repositories and related applications on the production system
• Generate metrics related to critical information, such as performance, variance, and analyses strategic, operational and resource allocation decisions and actions
• Lead projects related to new systems/applications (focused on data collection, Business Intelligence, etc.)
• Prepare reports synthesizing analytical results, highlighting implications of findings
• Maintain and update current reports
• Support business users and provide expertise with technical issues
• Work closely with Business Units to understand business needs and requirements to design and build solutions

Qualifications:

• Strong working knowledge of Azure Database and Power BI. Completion of Azure Database and Power BI Training/Courses, with a Microsoft Learning Partner is an asset
• 5 years’ progressive experience in Information Technology design and system implementation in a regulated industry or public utility setting
• Strong knowledge of the Project Management Framework. Project Management Professional Designation is an asset
• Advanced knowledge in Microsoft Office (Word, Excel, Dynamics, PowerPoint, Access, Team)
• University degree in Computer Science, Information Technology, Business Intelligence, Information Management, or related discipline
• Strong working knowledge of Python, JavaScript, VB, VBA Design, implement, and maintain tooling to assist with the querying of data
• 3 years’ experience in Information Technology design and system implementation, working in a regulated industry and/or public utility
• 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, Power BI, Tableau or Sisense
• Degree in Computer Science with specialty in related field