This posting will remain open until filled.

Job Type
Permanent Full Time Under the direction of the designated IT Manager, the Application and Integration Technical Analyst is a technical lead responsible for system architecture, data strategy, and integration frameworks, ensuring the reliability, scalability, and security of critical business systems. cloud-based) and on-premise applications, modern ERP solutions, integrations, data management, and reporting platforms. This role reinforces the organization's transition to up-to-date platforms by assisting in establishing support processes, knowledge, and controls. Create solution architecture and designs, technical plans, and execute application and IT service changes and enhancements to address business needs and deliver required capabilities ERP), including configuration, troubleshooting, vendor escalation, and application lifecycle activities (e.g., Architect, build and maintain a hybrid integration platform, utilizing web services or RESTful-based integrations and APIs Architect, build, and maintain data infrastructure and data management frameworks, to enable the City's business intelligence reports and dashboards Monitor assigned application, integration, data and business intelligence service health and usage; resolve incidents, track service levels, and drive improvements to stability, performance, and user experience Administer and monitor security configurations and controls to ensure compliance with applicable policies and standard operating procedures Produce production-ready solutions with appropriate test planning and coverage; identify and mitigate delivery and operational risks throughout the solution lifecycle Contribute to the development and implementation of relevant IT policies, standards,



and operating procedures within the team's technical domain Collaborate effectively with IT team members, customers, vendors, and other stakeholders Adapt quickly to new platforms and translate vendor/product concepts into internal support practices Contribute to roadmaps for solutions within this role's technical domain Participate in an after-hours support rotation; additional after-hours work may be required for planned maintenance and releases Must have Class 5 driver's license. Demonstrable ability to support and administer production business applications (triage, troubleshooting, root-cause analysis, and resolution) within an ITSM/ticketing environment, including effective vendor coordination/escalation ~ Proficient with Windows 11+ and Microsoft productivity tools: Microsoft 365 and Teams ~5+ year working knowledge of SaaS application administration concepts (configuration, releases/changes, access management, user support) ~ Dynamics 365, Oracle Fusion, Workday, SAP) 5+ year demonstrable experience with data and analytics tools, including: BI/Reporting platforms: Power BI, Tableau, Looker, SSRS, Cognos, Crystal Reports Advanced Excel (pivot tables, VLOOKUP, Power Query, macros) Database querying and transformation: dbt, SQL (writing queries, joins, stored procedures) 5+ year demonstrable experience in data concepts such as: Data warehousing and ETL/ELT processes Data modeling Data governance, quality,



and integrity principles Master data management (MDM) Building dashboards, KPIs, scorecards Data visualization 5+ year demonstrable experience in web services/integrations (e.g., REST, SOAP, JSON) and/or middleware/iPaaS API data extraction and transformation Data mapping and field-level transformation between systems Integration monitoring and log analysis 5+ year demonstrable working knowledge of web application development

skills:
HTML5, CSS3, JavaScript Front-end frameworks: React, Angular Server-side languages: C#/.
NET, Java, Python, PHP Relational and NOSQL DBs: SQL Server, PostgreSQL, MySQL, Oracle, MongoDB Version control and CI/CD frameworks Demonstrable working knowledge of cybersecurity best practices relevant to applications, integrations, and reporting Ability to map business processes and document solutions (process mapping and architecture drawing tools such as Visio or ArchiMate) Proficient working knowledge in software delivery/change practices: requirements clarification, testing/UAT support, release/change coordination, application lifecycle management, development methodologies Strong written and verbal communication skills, including the ability to explain technical concepts to non-technical stakeholders Proven ability to collaborate effectively with IT teams, customers, vendors, and outside agencies; Assets M365 administration and/or Microsoft Purview implementation experience and administration (information governance / document management) Microsoft identity implementation (e.g., Experience with document/content repository systems (e.g., Mobile application development and support experience (iOS/Android) Solution monitoring/observability practic

📌 Application Support Technical Analyst (Ottawa)
🏢 City of Saint John
📍 Ottawa