Requisition ID: 21837
Department: Finance and Corporate Services Dept.
Service: Information Technology Services
Branch: Applications Management Branch
Employment Type: 1 or more Full Time Temporary Positions (Up to 1 Year or more)
Work Hours: 35.00 hours per week
Affiliation: CIPP
Salary Information: $93,764.58 - $114,097.62 annually (2025 rates of pay)
Location: 100 Constellation, Nepean
City: Ottawa, ON
Job Category: Information Technology
Application Close: 14/05/2026
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.
Senior Data Engineer:
ITS is seeking a Senior Data Engineer 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, PowerBI and IBM Cloud Pak for Data. The role includes building scalable data pipelines, designing data models, developing reports & dashabords 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.
Senior Automation Developer:
ITS is also seeking a Senior Automation Developer to provide technical leadership in business process automation and systems integration initiatives across the organization. The Senior Automation Developer will design, develop, implement, and optimize automation solutions using technologies such as Microsoft Power Platform, RPA, Azure DevOps, CI/CD, scritping/programming languages, Git, custom APIs, and databases systems. The role will support the delivery and continuous improvement of applications and integrations, and act as a subject matter expert across all phases of the solution lifecycle, while establishing best practices and ensuring alignment with the City’s enterprise standards and priorities.
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.
Completion of 3 year university degree or college diploma in information management, information technology, or related field
Data Engineer: Minimum of 5 years of progressively more responsible experience in development and/or integration, including experience with: Microsoft Fabric, Power BI. DataStage and IBM Cloud Pak for Data tools and underlying technologies using variety of data sources, PowerBI administration, Data Gateways ,designing and building dataflows. Experience with Extract Transform Load (ETL) and ELT capabilities.
Dimensional data modeling; providing technical support and guidance through prototyping, testing, build, and launching Power BI products.
Experience with Geo Analytics capabilities like PowerBI integration with ESRI ArcGIS , building location based visualizations.
Experience with SAP BW4HANA and DataSphere is an asset.
Automation Engineer: Minimum of 5 years of progressively responsible experience in automation development and systems integration, including experience with Microsoft Power Platform, RPA tools, and Azure DevOps using a variety of enterprise systems and data sources. Experience designing and building automated workflows, supporting applications and integrations, and implementing CI/CD pipelines with source control.
Experience with scripting and programming languages, integrating systems through APIs and web services, and working with relational and non-relational data sources. Experience providing technical guidance through design, development, testing, and deployment of automation solutions.
For Business Intelligence (BI) positions:
For Automation positions:
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. 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 Employee Service Centre at 613-580-2424 extension 12211 or via email at esc-cse@ottawa.ca.
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Whenever possible, reach out to a named contact rather than a general inbox - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at
The City of Ottawa: A place to grow your career.
We are proud to be an employer of choice, attracting talented individuals who reflect the community we serve. As an award-winning employer in the National Capital region and one of Canada’s best diversity employers, we foster a respectful and inclusive culture where every employee can feel a sense of belonging.
Your career can flourish across more than 110 diverse business lines all while enjoying the stability of a single employer. We champion continuous learning, value work-life balance and support every stage of your career journey. We are committed to investing in our people through competitive compensation, an employer-matched defined benefit pension plan and a suite of benefits that support both personal and professional well-being.
Join the City of Ottawa to experience making a meaningful difference and improving the quality of life in our community!