Digital Services Application Specialist

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 systems, including corresponding databases.

Primary Responsibilities

• 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 365 performance, 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 deployment, configuration, and 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, 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 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:

- Dynamics 365 and Power Platform (PowerApps, Power BI, and Power Automate).

- Experience of SQL/SQL*Plus and PL/SQL.

- Experience working with Oracle relational databases.

- Experience working with HTML5, XML, and JavaScript is an asset.

- Experience working with API is an asset.

Knowledge, Skills and Abilities

• Demonstrated ability to develop, administer, support, and troubleshoot applications and databases.
• Ability to manage crisis situations involving complex technical problems.
• Excellent communication skills, able to clearly communicate technical/complex information in lay terminology.
• Ability to exercise discretion, judgment, and work independently with minimum supervision.
• Demonstrated proficiency in personal computers and Windows applications, emphasizing computerized financial systems and software applications, including advanced proficiency in MS Excel.
• Demonstrated strong interpersonal, leadership, and project management skills.
• Ability to establish and maintain cooperation, understanding, trust and credibility in concurrent tasks and emergency situations.
• Ability to act professionally and treat end-users with respect and courtesy.
• Strong interpersonal skills, with the ability to 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 includes 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.