Application Specialist (Power BI)

We are hiring a full time Application Specialist (PowerBI) to join Peterborough Technology Services.

About Peterborough Utilities Group

Located 90 minutes from Toronto, Peterborough Utilities Group has been in business for 100+ years. We support the community by providing assistance with setting up water connections for construction and development projects, providing affordable electric water heater and meter solutions, monitoring water usage in the community, and ensuring Peterborough's water treatment plant is meeting or exceeding government requirements.

Our people are key to our success, and we are committed to providing a safe work environment, opportunities to grow professionally, and to being an inclusive workplace.

About the Benefits

As a member of our Technology team, you can look forward to the following benefits:

Union position (International Brotherhood of Electrical Workers)

Rate: $30.42 - $46.81 per hour

Comprehensive 100% employer-sponsored group benefits including extended group health, dental, and vision coverage, and life and long-term disability insurance

OMERs pension contribution matching

Relocation assistance

Social events including training and holiday lunches

Professional development

Join a company committed to diversity, equity, and inclusion

This is your chance to be part of an established organization with incredible room to make an impact and experience personal development.

Position Overview

As a member of the Peterborough Technology Services, (PTS), team, you will play a key role in providing the City of Peterborough and Peterborough Utilities Group, (PUG), with reliable, secure and cost effective Corporate Applications. The Application Specialist position will work with application users, information technology staff and various business unit staff in the procurement or development, implementation and support of software applications and technologies.

This position leads smaller scale projects and will participate in the review, analysis and evaluation of business systems and user needs. This position will work collaboratively and contribute to application management strategies.

This position will have responsibility for support and oversight of one or more applications deployed on a variety of technologies. These applications may include vendor delivered, custom off-the-shelf software, (COTTS) and in-house developed, corporate solutions.

This position will function as a strategic resource by providing robust technical and analytical support to project teams and application portfolios. This position will liaise with other information technology staff and outside technology vendors for effective resource management and problem resolution. This position uses industry standard desktop productivity and development tools with a focus on providing quality, value added applications throughout the PUG and City.

Main Accountabilities

Application Portfolio Management

For small to medium sized applications, the Application Specialist will work in partnership with our business partners, and provide advice or direction relating to architecture, design, development and deployment of new applications, and enhancements to existing applications, as assigned;

Seeks to understand business unit objectives; applies knowledge to projects and disseminates to other IT team members;

Works with Portfolio Teams and business partners to ensure a strategy/roadmap exists for applications within area of assignments;

Perform Application lifecycle management for software within the assigned portfolio. This position leads or participates in architecture and design sessions with team members and external suppliers for the purpose of enhancing performance, business processes, operations, and information process flow;

Conduct research and analysis for the purpose of presenting options and cost-benefit analyses to aid management in making implementation decisions for proposed systems;

Creates standard software development lifecycle documentation such as systems models, specifications, diagrams, and charts to provide direction to the team;

Lead or participate in all phases of the systems development lifecycle for smaller scale projects;

May perform software development, configuration, data manipulation / transformation and testing for any size of application initiative;

Consult with business units to optimize business solutions and processes using technologies to ensure the most efficient use of end-user applications and data;

Lead or participate in integrations of internal and external applications and their databases while maintaining data integrity, security and auditability for small scale projects independently or participate as part of a project team if project is across multiple platforms and databases while ensuring compatibility and interoperability with corporate systems;

Provide secondary support for applications outside of assigned area of responsibility with assistance from vendor or key stakeholders as required; and

Contribute to the creation of corporate standards for project management documentation, change management, release management, requirements analysis, solution design and IT Security following the system development lifecycle. Adhere to these standards.

Project Management and Leadership

Provide project management skills to meet project deliverables by agreed to targets (budget, timelines, etc.) for small or less complex IT related projects; and

Advisor to Portfolio Teams, business partners and IT / corporate leadership regarding project status, risks and issues.

Data Analysis and Support

Knowledge of database structures within area of assigned responsibility and their relationship to other applications to avoid duplication, redundancy, etc. and to ensure data integrity;

Develop / work with vendors to provide input on the development of data extracts, reporting and business intelligence, (BI) or business analytics;

Maintains a good working knowledge of industry standard query reporting solutions and report writing tools to maximize the value of corporate data; and

Knowledge of database architecture, analysis, design and development.

Backup, Recovery and Business Continuity

Prepare Disaster Recovery documentation and test plans for software within area of assigned responsibilities;

Participate in system recovery and restoration initiatives for applications;

Prepares roll-back plans for all implementations and upgrades within assigned area of responsibility; and

Backs up and/or restores databases to departmental standards within the scope of Departmental “best practice” guidelines. Will provide back-up resource to the Database Application Specialist.

IT Strategy and Continuous Improvement

Participate in IT strategy projects;

Contribute to the creation of corporate IT standards; and

Research new and emerging technologies to provide input on technology direction.

Safety and General

Responsible for personal safety and the safety of others that is dependent upon their actions;

Report hazards and unsafe acts or conditions encountered on the job to fellow workers and supervisors; and

Other duties as assigned.

Experience:

Successful completion of a 3-year college diploma or degree in a related computer discipline along with formal business training, or the equivalent combination of education and work experience.

Systems or business analyst training and/or a minimum of 2 years experience in a related IT role with proven experience in supporting enterprise software applications. Programming experience in multiple software development languages is required.

Programming experience using languages like PowerApps, SQL, Java and JavaScript is required. Technical experience supporting applications such as Microsoft SQL Server or Oracle database environment and a Microsoft Windows and Linux server environment is required.

This position requires strong working knowledge of Microsoft 365 including SharePoint Online, Power BI, Teams, and OneDrive. Experience with SAP, S/4 HANA and AMANDA would considered be an asset.

Skills (Technical Skills):

Experience with SAP Basis, SAP reporting & SAP Configuration.

Programming experience using languages like ABAP, Java, JavaScript, PowerApps, and SQL is required.

Formal training (or equivalent experience) with data retrieval methodologies and Query/Reporting tools;

Knowledge of industry standard software development tools and methodologies;

General technical knowledge of computer hardware including desktop and network servers and how they inter-relate with information systems and databases, including a general knowledge of network connectivity, integration, and protocols;

Technical knowledge and experience with a variety of network and PC operating system software (e.g. Windows, MS SQL Server, UNIX, Linux, MS Windows Servers, etc.);

Extensive experience with core software applications, including Microsoft Office Productivity Suite;

Knowledge of object oriented and relational database concepts, theories and principles, for the efficient design and development of applications;

Good working knowledge of Java programming language, JavaScript and XML; modern W3C Standard technology and mobile technology;

Good working knowledge and experience with virtual machines / servers as well as physical servers in hybrid environments, with the ability to troubleshoot applications on personal computers, servers, LAN/WAN and handheld devices;

Available to work overtime and non-standard hours as required. Travel required. Shift work may be required in accordance with Section 8.1 of the collective agreement to complete assigned duties; and

Demonstrated work as part of a project team, time management, presentation and communications skills (both oral and written).

Skills (Non Technical):

Possess personal qualities (initiative, stability, etc.) required for suitable performance of duties;

Demonstrated commitment to safety and excellent attendance record;

Demonstrated high personal integrity;

Demonstrated understanding of the municipal and utility environment would be an asset;

Proven ability to integrate and collaborate within a senior technical team;

A strong Business Acumen; and

Must hold a valid drivers license and have access to a vehicle.

APPLICATIONS STATING QUALIFICATIONS IN AN ATTACHED RESUME AND COVER LETTER, MAY BE SUBMITTED BY APRIL 29, 2024.