Intermediate Systems Dev / Integrator

Requisition ID : 20487

Department : Community & Social Services Dept.

Service : Comm Saf, Well-Being,Pol & Anlt Services

Branch :  Soc Pol, Research & Analytics Branch

Employment Type : 1 Full-time Temporary - Up to 1 year

Work Hours : 35.00 hours per week

Affiliation : CIPP

Salary Information : $80,325.70 - $97,739.46 annually (2025 rates of pay)

Location : 100 Constellation, Nepean

City : Ottawa, ON

Job Category : Community and Social Services

Application Close :  23 / 01 / 2026

JOB SUMMARY

The Community and Social Services Department supports Ottawa’s most vulnerable residents by delivering essential social programs across housing, employment and social services, children’s services, long-term care, and gender, race, Indigenous, and community development. Our team improves service delivery by treating data as a core asset and enabling smarter, more efficient use of information.

The Intermediate Systems Developer / Integrator designs, builds, and supports data-driven applications and workflow automation using Microsoft Power Platform and Microsoft Fabric. The role focuses on developing Power Apps, Power Automate workflows, and semantic models to streamline business processes, improve data availability, and support enterprise reporting and analytics used for operational and policy decision-making.

This position works across the full solution lifecycle (ALM), including analysis of existing applications and processes, solution design, development, testing, deployment, and ongoing support. The role contributes to application modernization, integrates data across systems, and applies data governance and low code development best practices. This position collaborates closely with technical teams, policy staff, and business stakeholders in an enterprise public-sector environment. The position also supports Dataverse and Dynamics 365 solutions where required, and uses Azure DevOps for source control, work tracking and delivery.

EDUCATION AND EXPERIENCE

Completion of 3 year university degree or college diploma in information management, information technology, or related field.

Minimum of 3 years of progressively more responsible experience in applications development and / or integration.

Microsoft ASP .Net version 2003, 2005 Web or higher versions and .Net Framework 1.1 and higher is desirable

VB and C# .Net programming languages is desirable

Oracle RDBMS 9i and higher is desirable

Oracle Internet Developer Suite is desirable

Oracle Application Server Technologies is desirable

Oracle SOA Suite is desirable

PL / SQL for creation of procedures and packages is desirable

XML is desirable

Development using Microsoft Office Suite tools is desirable

Development using SharePoint tools is desirable

PowerBuilder version 6.5 to 8.0 is desirable

MS Access 97 and higher is desirable

ColdFusion is desirable

System Development Life Cycle is desirable

n-tier Architecture Design is desirable

Unit, regression and load testing is desirable

Test plan creation is desirable

Configuration management is desirable

Creation of technical and non-technical documentation is desirable

KNOWLEDGE

• Application development best practices
• IT security best practices and standards relating to application development and / or integration
• In-depth knowledge of the current City of Ottawa development toolset
• Event-driven / object-oriented program design techniques
• Structured systems analyses and design techniques
• City network environment
• SQL Server and / or Oracle DBMS at an intermediate level
• System testing techniques

COMPETENCIES, SKILLS AND ABILITIES

WHAT YOU NEED TO KNOW

We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.

The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions.

Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.

The City of Ottawa provides accommodation to applicants during all parts of the hiring process, upon request.