Senior Systems Developer​/Integrator

Requisition
Department:
Finance and Corporate Services Dept.
Service:
Information Technology Services
Branch:
Applications Management Branch

Employment Type:

1 Full Time Temporary Position (Up to 1 Year) 

Work Hours:

35.00 hours per week
Affiliation: CIPP 
Salary Information: $93,764.58 - $ annually (2025 rates of pay)

Location:

100 Constellation, Nepean
City:
Ottawa, ON
Job Category:
Information Technology 
Application Close: 08/01/2026

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.

ITS is seeking a Senior BI Developer to provide technical leadership in Business Intelligence, analytics, and data integration initiatives across the organization.

The Senior BI Developer will lead the design, development, administration, and optimization of enterprise BI and ETL solutions using Microsoft Fabric / Power BI, and Cognos. The role includes developing reports and dashboards, designing data models, performing data transformation, and building scalable data pipelines to support enterprise-wide analytics. The incumbent will act as a subject matter expert across all phases of BI solution design, development, maintenance, and support, while contributing to the establishment and sustainability of the City’s Enterprise Data Management capabilities.

You are also responsible for: writing and maintaining systems documentation; ensuring all code is managed appropriately by using software configuration management tools; following the approved project lifecycle (PLC), as appropriate; ensuring solutions are made bilingual and comply with the Accessibility for Ontarians with Disabilities Act (AODA) Web Content Accessibility Guidelines 2.0 AA (WCAG 2.0 AA); mentoring/coaching of other developers; and performing tests on enhancements/new development.

EDUCATION AND EXPERIENCE

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

Minimum of 5 years of progressively more responsible experience in applications development and/or integration, including experience writing and supporting applications with databases with a focus on Business Intelligence reporting tools like Power BI using variety of data sources, Power BI administration, Power BI Geo Analytics capabilities , Data Gateways; designing and building dataflows;
Dimensional data modeling and ETL using Dataflows; and providing technical support and guidance through prototyping, testing, build, and launching Power BI products.

KNOWLEDGE

For all positions:

For Business Intelligence (BI) positions:

COMPETENCIES,

SKILLS AND ABILITIES