Application Specialist (Power BI)

at  Peterborough Utilities Group

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.

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.

Please refer the Job description for details