Sharepoint Developer/analyst

Status: Regular Full time

Working Conditions: Hybrid Work Environment (3 days in office)

Education Level: 4 years of University degree in business administration or computer science, or by having the equivalent level of education.

Location: Pickering, Ontario

Shifts(s): Days

Travel: 10%

Deadline to Apply: April 29, 2024.

Electrify your career and help build a brighter tomorrow.

Every generation has a challenge that defines them. At OPG, we are calling on all innovators, disruptors, thought leaders and change-makers. Join us to electrify life in one generation and build a sustainable future powered by our electricity, our ideas, and our people. Join OPG and make history.

Whether you work in the skilled trades or are a business professional, a career at OPG is an opportunity to electrify your life on -- and off -- the job.

ACCOMMODATIONS

OPG is committed to fostering an inclusive, equitable, and accessible environment where all employees feel valued, respected, and supported. If you require accommodation during the application or interview process, please advise us as soon as possible so appropriate arrangements can be made.

If you require information in a format that is accessible to you, please contact AODA@opg.com

NEW CAMPUS: This position is moving to OPG Corporate Headquarters: In Summer 2025, OPG will officially welcome employees to our new Corporate Headquarters located at 1908 Colonel Sam Drive, Oshawa, Ontario. This new space will enable teamwork, collaboration and innovation that will help us to achieve our mission to electrify life in one generation.

JOB OVERVIEW

Ontario Power Generation (OPG) is looking for a dynamic, strategic, and results-driven professional to join our team in the role of SharePoint Developer/Analyst.

Reporting to the Section Head, Information Systems and Microsoft Apps, this role is responsible for design, development, and implementation of software solutions to meet business needs. Collaborate with clients to assess, provide, and support medium to complex information technology systems and products and related services to fulfill business needs. The scope of information technology may include software and operational processes related to any or all of computers, peripheral equipment, networks, data communications, and office equipment. Provide consultative, advisory, training, and educational services, and act as a team leader on complex activities. Assign work to technical staff assisting in the work.

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

• Conduct studies to assist users in defining and documenting functional requirements, data requirements, and operational constraints related to potential information technology solutions for simple to medium-complex problems. Define alternative solutions, within corporate architectures including options to make or buy, and to replace or modify. Analyze alternative solutions by identifying and estimating life-cycle costs and by assisting users to identify and quantify benefits. Make effective recommendations to clients to change their business processes and work methods in order to use information technology more effectively. Create pilot or prototype solutions. Prepare recommendations and business-case documentation to support the preferred alternatives. Review recommendations with other departments in the division. Conduct or participate in technical and economic studies requiring expert knowledge related to information technology services, methodologies, techniques, standards, and tools. Propose strategies for exploiting new technologies and techniques. For complex problems, assist in the above activities.
• Provide consultative services and specialized expertise in information-technology areas. Assist, and provide guidance to, users and line management, both within and outside of the division, in the availability and use of information technology. Provide information related to the availability and use of information technology services. 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 advice concerning program and database design, and the deployment and utilization of integrated information technology products and related services. Make effective recommendations on associated work methods and budgets. Assist information technology staff and open-shop users in resolving problems related to programming, program design, or production use of programs and data. Develop and maintain standards, procedures, methodologies, and tools for information-technology staff. Assure the quality of systems and databases developed within the division. Generally, perform these activities for complex products.
• Perform information technology product acquisition activities for products of low to medium impact. Perform market searches. Prepare tendering documents and evaluate vendor submissions. Prepare test plans and review test results for efficiency, effectiveness, and compliance with user requirements. Make effective recommendations on the acquisition of new products or product upgrades. Prepare purchase requisitions, contracts, and license agreements. Arrange for installation and commissioning of products and provision of related services. Communicate with vendors concerning problems encountered in the use of products or desired enhancements to products. For products of high impact, assist in the above activities. Prepare and maintain test data. Perform evaluation tests. Analyze and report test results and observations.
• Carry out design, development, and implementation activities for simple to medium-complex systems or databases. Construct system models or data models at the conceptual level, defining functional components, processes, data entities, and relationships with other systems or databases. Review models with users and other information-technology departments. Recommend the approaches to be followed in design, development, testing, and implementation, taking into account the need for interfaces with other systems or databases. Perform high-level design. Estimate processing costs, using simulators where appropriate. Review design with users and other departments in the division. Review test procedures and test results with users in order to verify compliance with user requirements. Assist in the above activities for complex systems, programs, or databases, and develop and demonstrate prototype systems or databases. Design data flows and logic flows. Determine level of auditing, controls, backup, and security procedures to be applied. Develop test plans and procedures. Design, develop, document, and test systems, programs, or databases. Develop operating procedures and arrange for commissioning and implementation in a production environment. Conduct post-implementation reviews with users.
• Maintain simple to complex systems or databases. Maintain library files for software in production use. Advise and assist users concerning the production use of systems, products, or databases. Implement and document enhancements and changes to meet new user needs. Analyze trouble reports and implement corrective actions. Resolve emergency problems under time constraints. Identify latent problems and implement changes to eliminate or bypass them. Assist in the assignment of priorities to maintenance tasks.
• Prepare major written reports and prepare and sign correspondence dealing with technical issues. For simple to medium-complex projects, prepare correspondence on financial issues, commitment of resources, work schedules, and proposals. Conduct or participate in planning and review meetings, involving technical staff and line management representing user departments and various information technology departments. Prepare and review specifications, proposals, investigative reports, business case documents, design documents, maintenance documentation, operating instructions, and user manuals.
• Administer products, systems, or databases in production. Monitor the effectiveness and efficiency of use of products, systems, or databases in production. Effect, guide, or recommend corrective actions. Manage program libraries, database and file directories, and storage and resource utilization. Perform password administration and monitor security violations. Apply corrections to databases or files, which cannot be handled by normal update procedures. Execute security procedures for integrity and recoverability and monitor the integrity of the system or database. Perform archiving procedures and recovery procedures. Identify, and effect the resolution of, problems which must be referred to other departments in the division, e.g., operating-system problems, or database-management-system malfunctions. Generally, perform these activities for complex products, systems, or databases.
• Provide training and education for simple to complex products, systems, or databases. Prepare user instructions in the form of written documentation (manuals and on-line user aids) and demonstrate usage. Demonstrate the usage of proposed development end products by means of prototyping or simulation tools. Identify the training needs of user staff and information-technology staff. Define training courses and formulate their content. Prepare training materials. Conduct classroom sessions. Provide individualized instruction and act as a resource person for self-instruction courses.
• Carry out project management responsibilities. Act as team leader on projects requiring complex technical knowledge. Assign work to staff assisting in the work and schedule their activities. Coordinate assigned project work activities including coordination with other departments. Monitor the progress and costs of assigned work. Recommend changes in resourcing. Maintain day-to-day contact with users to review progress. Prepare progress reports and conduct review meetings with users and line management. Assist in preparing project estimates. Provide input for departmental budgeting processes and work-program planning.
• Provide technical notes and guidelines on selection, acquisition, migration, usage, and application of all but the most complex information technology products and related services. Provide product and product usage and application assistance and problem resolution services.
• Assign work to staff assisting in the work and schedule their activities. Provide guidance in techniques and methods of programming, design, and documentation. Monitor the quality of work performed. Identify the training needs of staff and provide input to line supervisors for the preparation of training plans. Refer human resource matters to supervisor for resolution.
• Other duties as required.

While the above is representative of this job function broadly at OPG, the following capabilities are preferred for this posting specifically.

• In-depth understanding of the Microsoft O365 & Azure Platforms (including Active Directory, Azure AD, Logic Apps & Functions, PowerShell)
• Advanced experience in development and sustainment of SharePoint Framework (SPFx) solutions, including resolving incidents and issues according to business and IT priority.
• Advanced development experience of on-premises and Cloud based applications, including thorough knowledge and skills in SharePoint Framework, SharePoint Online, Power Platform (Power Apps, Power BI, Power Automate), Microsoft Teams, SharePoint Add-ins.
• Experience in tracking and managing incidents using ServiceNow as well as break/fix and enhancements within Azure DevOps and other Azure monitoring tools
• Strong analytical and reasoning skills that transfer seamlessly into effective technical execution.
• Excellent communication skills with both technical and non-technical stakeholders
• Strong ability to prioritize, self-direct, and execute using agile methodology
• Highly motivated to deliver top-quality work both individually and as part of a team
• Leadership & mentoring qualities to provide guidance and knowledge to junior developers/analysts
• Passion for continuous improvement and drive to learn new skills and grow competencies.

EDUCATION

• 4 years of University degree in business administration or computer science, or by having the equivalent level of education.

QUALIFICATIONS

• Requires a minimum of 6 years' experience and up to and including 8 years is considered necessary to gain this experience.
• Minimum 3 years of experience Microsoft Cloud Platform O365 and SharePoint Online, SharePoint Framework (SPFx) Development, Microsoft Power Platform (PowerApps, Power BI & Flow).

• Requires experience to be able to define users' information technology requirements for medium to complex problems, and to design, develop, acquire, and implement the required systems, databases, and information technology products and related services.
• Requires experience to understand new and existing information processing concepts, computer and communications equipment, and software.
• Requires experience to acquire a knowledge of the organization and a general knowledge of the operational characteristics and functions of the application systems, databases, products, computers, communications, and associated equipment serviced by the division.
• Requires additional experience to operate at a senior level, and to become familiar with responsibilities related to leadership.
• Requires a knowledge of the principles of computing equipment, methods, systems analysis and design, data management, work simplification, communications, and computer programming to enable creative logical reasoning in regard to the design and effective use of systems and databases, computer programming activities, and related matters.
• Requires a knowledge of computer science to gain an appreciation of design concepts related to computing equipment and software, in order to provide computerized solutions to varying OPG requirements.
• Requires good verbal and written communications skills, to coordinate the needs of clients, suppliers, and divisional staff.

Preferred Skills:

• Process/Methodology: Agile, Scrum, DevOps
• Scripting/Development: SharePoint Framework Development (SPFx), PowerShell, Azure PowerShell, SharePoint Add-ins, Microsoft Power Platform (PowerApps, Power Automate, Power BI), CSOM, Azure Logic Apps and Azure Functions, Web Apps, Service Fabric, Virtual Machines
• Platforms: Microsoft Azure, Office 365, SharePoint On-premises
• Data: AZURE SQL, MS SQL SERVER
• Languages: C#, SPFx, PowerShell, TypeScript, JavaScript, JSON,
• Identity: Active Directory, Azure AD, ADFS, Azure AD B2C
• Management & Governance: Backup, Automation, Monitor, Service Health, Resource Manager, Cloud Shell, Azure Insights
• Networking: DNS, Firewalls, Virtual Networks, Load Balancers, Application Gateways
• Security: Azure AD, Key Vaults, Security Center

The successful candidate will exhibit uncompromising integrity and commitment to upholding corporate values, and the OPG Code of Business Conduct.

What Makes a Career at OPG Different?

As Ontario's largest clean energy generator, we're building, expanding, and innovating the equipment and technology that keeps Ontario powered with clean, reliable energy.

At OPG, our values are our strengths. They are fundamental truths about our organization that don't change:

Safety - it's our business.

Integrity - always lead with integrity.

Excellence - never satisfied with good enough.

Inclusion - working together for powerful outcomes.

Innovation - creativity accelerates possibility.

Here's why OPG might just be the ideal workplace for you:

• Exceptional range of opportunities province-wide
• Long-term career growth and development opportunities
• Electricity is vital to the province and OPG's clean electricity is helping decarbonize other sectors.

Our promise to you:

• We care about the safety and the well-being of our employees. It is our utmost priority.
• A supportive work environment where you can be your best every day.
• Opportunities to stretch and develop.
• Offer different ways for you to give back to the communities where we operate.
• Partner with Indigenous communities and support local businesses.
• We support employment equity, diversity, and inclusion.

Are you ready to start a career that has the power to electrify life on and off the job? Apply now.

APPLICATION PROCESS

Please submit your application online at https://jobs.opg.com/ by 11:59 PM E.S.T. April 29, 2024. OPG thanks all those who apply; however, only candidates considered for an interview will be contacted.

#LI-Hybrid

.