Description:
This is an exciting opportunity to work in an environment where you will contribute to OPG’s public outreach, engagement, and education efforts as part of the company’s commitment to growing its social license.
KEY ACCOUNTABILITIES
- Provide support for project management, technical leadership and system expertise to projects and teams involved in the design, development, deployment, and support of advanced information systems or tools.
- Design and implement project management and controls reports tracking key performance indicators across the project lifecycle.
- Develop, maintain and troubleshoot automated reports using Microsoft Reporting Services (SSRS), Power BI and other reporting software as required.
- Determine vulnerabilities or areas of poor performance to boost productivity, efficiency and accuracy in current systems.
- Provide specialized expertise in the use of facility software, including compilers, utilities, program libraries, operating-system facilities, data-transfer and Data storage facilities, and database management system facilities.
- Provide specialized expert program and database design, and the deployment and utilization of integrated information technology products and related services.
- Carry out design, development, implementation and maintenance activities for complex systems and databases.
- Maintain library files for software in production. Advise and assist concerning the production of systems, products, or databases.
- Implement and document enhancements and changes to meet new user needs.
- Other Duties as Required.
EDUCATION
- 4 years of University education in an appropriate field such as Business, Finance or Engineering, or by having the equivalent level of education.
QUALIFICATIONS
- A period of over 6 years and up to and including 8 years is considered necessary in project reporting, planning, scheduling, risk management, and control service needs of the division.
- Requires experience to become familiar with project controls principles, theories, and concepts such as project scoping, risk management, estimating, budgeting, and scheduling.
- Requires experience to become familiar with the development and operation of various computerized systems and databases, including business unit financial and work management systems.
- Requires experience to become familiar with corporate financial processes.
- Requires strong interpersonal and communication skills, including relevant business and computer applications knowledge, to develop and maintain computerized project information, costs, and forecasts.
- Professional experience as a Systems or Reporting Analyst in a Project Controls Environment
- Demonstrated experience developing, documenting, testing and providing on-going support in MS based databases primarily SQL Server and related technologies.
- Experience working with various table structures within complex relational databases.
- Experience reporting from data warehouse sources.
- Developing advanced T-SQL queries and scripts for management of an integrated MSBI data warehouse Building and maintaining automated reports using Power BI and SQL Server Reporting Services (SSRS).
- Hands-on experience with the following technologies and databases is highly preferred:
- Microsoft SQL Server Reporting Services (SSRS)
- T-SQL (Microsoft SQL Server 2019+)
- Microsoft PowerBI
- Microsoft DevOps, Microsoft Visual Studio and Git
- Master Data Management (MDM), specifically TIBCO EBX5
- C#/ VB.NET, Visual Studio .NET
- Project controls/management in large construction projects or the nuclear industry