Application & Integration Technical Analyst

City of Saint John; New Brunswick; Presencial; CAD 83.000 - 92.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible time options program

Descripción de la vacante

City of Saint John is seeking an Application and Integration Technical Analyst to lead system architecture, data strategy, and integrations across SaaS and on-premise platforms. You will design, implement, and support modern ERP and reporting solutions to enable robust BI capabilities and secure operations.

Responsibilities include building hybrid integrations, maintaining data infrastructure, and ensuring reliability, security, and governance while collaborating with IT teams and stakeholders.

Formación

• Experience administering production business applications in ITSM/ticketing environments.
• Knowledge of identity, access management and security concepts (RBAC, SSO/MFA).
• Experience with modern ERP environments (e.g., Dynamics 365, Oracle Fusion, Workday, SAP).
• Proficiency with BI/analytics tools (Power BI/Tableau).
• Experience with web services/integrations (REST, SOAP, JSON) and middleware/iPaaS.
• Strong problem solving and communication skills.
• Ability to document solutions and map business processes.

Responsabilidades

• Create solution architectures, technical plans, and execute application/IT service changes.
• Architect and maintain SaaS and on-premise applications and ERP platforms.
• Maintain a hybrid integration platform using RESTful APIs and web services.
• Develop data infrastructure for BI reports and dashboards.
• Monitor service health, incidents, and performance; ensure security and governance.

Conocimientos

SaaS administration

Identity & access management

ERP platforms

Data analytics & BI

Web services & API integrations

Security concepts

Software delivery & lifecycle

Communication & collaboration

Problem solving & troubleshooting

Educación

Degree in Information Technology / Computer Science

Herramientas

Dynamics 365

Oracle Fusion

Workday

SAP

Power BI

Tableau

Descripción del empleo

Position Overview

This posting will remain open until filled.

Competition Number

26-072

Salary

$83,074.00 - $91,646.00/Year

Job Type

Permanent Full Time

Closing Date

November 1, 2026

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. This role champions a portfolio of SaaS (i.e., cloud-based) and on-premise applications, modern ERP solutions, integrations, data management, and reporting platforms. This role reinforces the organization’s transition to modern 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
• Architect, build and maintain SaaS and on-premise applications and modern platforms (e.g., ERP), including configuration, troubleshooting, vendor escalation, and application lifecycle activities (e.g., upgrades, releases, deprecations)
• 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 identity, access, and licensing for applications (e.g., roles and permissions, provisioning) in alignment with governance and audit requirements
• 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
• Maintain solution integrity through clear documentation, knowledge sharing, and operational readiness practices
• 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

Essential Qualifications

Must be Security Cleared. Must take Oath of Confidentiality. 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)
• Proficient knowledge in identity, access management and modern security concepts (RBAC, SSO/MFA concepts, provisioning/deprovisioning)
• 5+ year demonstrable experience working with modern ERP environments and related business process domains (e.g. 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
• Spreadsheet analytics: 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)

5+ year demonstrable experience in analytics and reporting skills, including:

• Building dashboards, KPIs, scorecards
• Ad hoc and scheduled report development
• Data visualization
• Descriptive, diagnostic, and predictive analytics

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
• RESTful API design and development
• MVC patterns
• 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 problem-solving, analytical, and troubleshooting skills
• 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; build and maintain productive working relationships
• Ability to work with a high degree of independence, judgment, and initiative while managing competing priorities and deadlines
• Ability to respond effectively in emergency situations; remain calm and coordinate response activities as needed
• Demonstrable continuous learning mindset and curiosity regarding current technological trends relevant to the role

Assets

• M365 administration and/or Microsoft Purview implementation experience and administration (information governance / document management)
• Microsoft identity implementation (e.g., Entra ID, SSO integrations, provisioning patterns)
• Experience with document/content repository systems (e.g., Laserfiche, eScribe, or similar)
• Mobile application development and support experience (iOS/Android)
• Solution monitoring/observability practices (alerts, logs, dashboards) and experience using application/integration monitoring tools (e.g. Splunk, Datadog, Dynatrace or similar)
• Experience participating in software/project implementations and familiarity with project management methodologies
• Experience in a municipal or broader public sector environment is strongly preferred.

Education, Training & Experience

• Degree in Information Technology, Computer Science, Information Systems, or a related field.
• Over 5 years of technical and operational acumen gained through progressive training and experience working with IT SaaS, modern ERP platforms and on-premise applications, databases, integrations and reports/dashboards.
• Demonstrated experience leading complex data migration and system implementation projects.
• Number of years of IT field experience combined with education and certifications will be considered in the hiring process.
• A technical assessment will be administered to evaluate proficiency in the required skills.

The successful applicant may be eligible to participate in a Flexible Time Options Program which includes the option of working a 4 or 5-day work week, subject to business requirements.

We are an Equal Opportunity Employer. We are committed to building a workforce that reflects the diversity of the communities in which we live and which we serve. We encourage and support applications from Indigenous persons, persons with disabilities, and members of visible minority groups. Candidates who belong to such groups, who are qualified, will be given preference at the time of selection.