Go

Intermediate Systems Dev/Integrator

at City of Ottawa in Ottawa, CA

Work Type: On Premise | Employment Type: Full Time

Experience Level: Mid Level | Posted Date: 2025-04-12

Apply for job

Description

 

 

Requisition ID: 17092  
Department: Finance and Corporate Services Dept.  
Service: Information Technology Services  
Branch: Technology Modernization Branch 
Employment Type: 1 Full-time Temporary - Up to 2 years 
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: Information Technology 
Application Close: 

JOB SUMMARY

The mandate of Information Technology Services is to create business value by providing innovative and strategic technology solutions for the business operations of the City of Ottawa.

With a focus on data governance and  Extract/Transform/Load capabilities, you are responsible for the design and  implementation of data pipelines, data extraction and validation, data cataloging, and metadata management. You work on projects that involve cleaning, reshaping, exploring, and visualizing data in various formats, building data pipelines for BI reporting needs, and setting up data catalogs for the various clients within the City. 

You also: write and maintain systems documentation; ensure all code is managed appropriately by using software configuration management tools; follow the approved PLC as appropriate; perform tests on enhancements and new development; and train clients on business applications and/or solutions.

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.

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
  For Business Intelligence (BI) positions: 
  •    Business intelligence tools and reporting with at least one of these - Cognos Analytics, PowerBI and SAC (SAP Analytics Cloud).   
  •    Data Governance platforms such as Azure Purview or Watson Knowledge Catalog (IBM Cloud Pak for Data).
  •    ETL platforms like IBM Datastage
  •    Knowledge of Data Cleansing, exploring and visualizing methods and techniques
  •    Knowledge of data structures, data models and data patterns,data wrangling methods
  •    Knowledge of Python or/and R programming
  
  Desirable Qualifications:
  Experience:
  •    PL/SQL for creation of procedures and packages 
  •    XML
  •    Development using Microsoft Office Suite tools
  •    Development using SharePoint tools
  •    System Development Life Cycle
  •    n-tier Architecture Design 
  •    Unit, regression and load testing 
  •    Test plan creation
  •    Configuration management
  •    Creation of technical and non-technical documentation

COMPETENCIES, SKILLS AND ABILITIES

• Develop applications (or components thereof) using current development toolset
• Install, customize and configure COTS applications
• Integrate hardware and software
• Liaise effectively with clients, all levels of ITS staff, vendors and consultants
• Gather and document user requirements
• Organize work and meet deadlines
• Demonstrate effective written and oral communication skills
• Work independently and as a team member
• Use effective judgment when immediate supervision is unavailable
• Research and analytical skills
• Collaborative approach in working with others
• Converse effectively using both technical and general business terminology
• Diplomacy and tact
• Demonstrates initiative and self-motivation
• Work effectively under pressure
• Work with minimum supervision
• Flexible
• Able to meet deadlines
• Client-focussed

WHAT YOU NEED TO KNOW

• Language Requirement: English oral, reading, writing       
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements. 
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available. 

 

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 during all parts of the hiring process, upon request, to applicants with disabilities. If contacted to proceed to the selection process, please advise us if you require any accommodation.

 

Accessible formats and communication supports are available upon request. Please contact the HR Service Centre at 613-580-2424, extension 47411.