Digital Services Application Specialist

at  City of Pickering

EMPLOYMENT OPPORTUNITY

The City of Pickering is committed to creating an equitable, diverse and inclusive workplace and strives
to foster a sense of belonging, empowerment and respect among all employees and community
members. We recognize and value that diverse perspectives, skills, backgrounds, and lived
experiences contribute to the growth and strength of our organization and community. As such, we
welcome and encourage applications from Indigenous Peoples and equity-deserving communities
including women, persons with disabilities, racialized persons, persons who identify as 2SLGBTQI+,
and other diverse communities.

JOB SUMMARY

The City of Pickering is seeking a dedicated and motivated individual to join our team in the role of
Digital Services Application Specialist
The successful incumbent is responsible for maintaining and supporting Corporate ERP applications
for all users and business stakeholders. This includes support, configuration, technical and functional
design specifications, development, implementation of supporting technologies, and integration with
other systems.
Designs and develops workflows and processes to effectively use applications, databases and
related technologies to meet business requirements of all stakeholders, including those that are
hosted internally or in the Cloud for development, UAT and production environments.
Additional responsibilities include evaluating and advising on all technology components, such as
software, hardware, and networking capabilities related to system, including corresponding
databases.

KNOWLEDGE, SKILLS AND ABILITIES

• Demonstrated ability to develop, administer, support, and troubleshoot applications and
  databases. Must maintain a current working knowledge of applicable technology and

demonstrate an ability and willingness to adopt new technology and best practices as required.

• Ability to manage crisis situations, which may involve complex technical problems.
• Excellent communication skills, including the ability to clearly communicate technical/complex

information both verbally and in writing using lay terminology.

• Ability to exercise discretion, judgment and work independently on assigned duties with

minimum supervision.

• Demonstrated proficiency in the use of personal computers and Windows based computer

applications with an emphasis on computerized financial systems and software applications,

including advanced proficiency of MS Excel.

• Demonstrated strong interpersonal, leadership, and project management skills.
• Demonstrated ability to establish and maintain cooperation, understanding, trust and

credibility, performing multiple tasks concurrently, and responding to emergency situations

effectively.

• Ability to act in a professional manner and treat end-users with respect and courtesy.
• Strong interpersonal skills, with the ability collaborate and work effectively with a team.
• Must be able to recognize sensitive information and preserve confidentiality.
• Must be prepared to undergo a Criminal Reference Check as a condition of employment.

Compensation also includes the ability to work a hybrid remote schedule, a comprehensive benefits
package, and an OMERS pension plan.
Qualified candidates may complete an online application form where you will be required to upload
your resume and cover letter (PDFs only). We thank all applicants for their interest, however, only those
selected for an interview will be contacted. In accordance with the Municipal Freedom of Information
and Protection of Privacy Act, personal information is collected under the authority of the Municipal Act
and is used for the purpose of candidate selection.
The City of Pickering is committed to inclusive and barrier-free employment practices, and to creating
a workplace that reflects and supports the diversity of the community we serve. Accommodations are
available throughout the recruitment process in accordance with the Accessibility for Ontarians with
Disabilities Act. Accessible formats and supports can be requested. For assistance, please contact the
Human Resources Department at 905.420.4627 or hr@pickering.ca.

configuring, patching as per business/vendor requirements.

• Builds Oracle PL/SQL scripts for data automation tasks and reporting.
• Maintains the security of the system through monitoring, ensuring that appropriate personne

requirements, including creating workflows, forms, reports, dashboards, and integrations.

• Manages the change management and communication activities related to the solutions

best practices.

• Creates, develops, and deploys interfaces for mission critical Cloud/Internal applications.
• Additional secondary responsibilities may apply and will be outlined in the Job Description

Education and Experience

• University Degree in Computer Science or a related field.
• Microsoft Dynamics 365 Fundamentals CRM Certification; and/or
• Microsoft Dynamics 365 Customer Service Functional Consultant; and/or
• Microsoft Dynamics 365 Field Service Functional Consultant
• 4 years of related experience in a business environment working with ERP or Corporat

• Leads the functional analysis and design of Amanda and Dynamics 365 solutions, including

defining the scope, objectives, and deliverables of each project.

• Administers and configures entities, workflows, forms, and business processes.
• Customizes the Dynamics 365 platform through PowerApps, Flow, and Power Automate to

meet business needs.

• Manages user accounts, roles, and permissions, ensuring appropriate access control and

security.

• Provides training and technical support to users, addressing issues related to Dynamics

365performance, functionality, and system errors.

• Oversees the integration of Dynamics 365 with other systems (e.g., ERP, CRM, SharePoint,

Office 365).

• Maintains and manages APIs or other third-party integrations to ensure smooth data flow

between systems.

• Performs general and advanced system administration tasks including application deploying,

configuring, patching as per business/vendor requirements.

• Builds Oracle PL/SQL scripts for data automation tasks and reporting.
• Maintains the security of the system through monitoring, ensuring that appropriate personnel

receive early warnings of potential issues, providing timely corrective actions to

prevent/mitigate issues.

• Troubleshoots and resolves data errors and system errors by examining various Oracle SQL

procedures, triggers, functions, and vendor stored procedures.

• Designs, implements and supports Copilot for M365 to meet the client’s business

requirements, including creating workflows, forms, reports, dashboards, and integrations.

• Manages the change management and communication activities related to the solutions,

ensuring that the client’s stakeholders are informed and engaged throughout the project

lifecycle.

• Collaborates with the project manager, technical consultants, and other team members to

ensure the timely and successful delivery of the solutions, following the agile methodology and

best practices.

• Creates, develops, and deploys interfaces for mission critical Cloud/Internal applications.
• Additional secondary responsibilities may apply and will be outlined in the Job Description,

which will be provided to candidates selected for an interview.

Education and Experience

• University Degree in Computer Science or a related field.
• Microsoft Dynamics 365 Fundamentals CRM Certification; and/or
• Microsoft Dynamics 365 Customer Service Functional Consultant; and/or
• Microsoft Dynamics 365 Field Service Functional Consultant
• 4 years of related experience in a business environment working with ERP or Corporate

Applications, to include the following:
o Dynamic 365 and Power Platform (PowerApps, Power BI and Power Automate).
o Experience of SQL/SQL*Plus and PL/SQL.
o Experience working with Oracle relational databases
o Experience working with HTML5, XML, and JavaScript is an asset.
o Experience working with API is an asset.