Senior Systems Developer/Integrator, Data and Automation

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: 19/05/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.

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.

EDUCATION AND EXPERIENCE

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.

KNOWLEDGE

For all positions:

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
Understanding of database concepts relating to application and database security
System testing techniques
Knowledge of and experience with COTS system installation, configuration, administration and support
A combination of knowledge and experience working with Oracle, .Net and/or Java development tool sets
Troubleshooting application issues
Good understanding of system failover and recovery strategies
Applicable legislation (e.g. MFIPPA, AODA)

For Business Intelligence (BI) positions:

Proven expert knowledge of business intelligence reporting with MS Fabric / PowerBI
Knowledge of IBM Data stack
Knowledge of PowerBI administration, Data Gateways
Ingesting data from a variety of corporate data sources and performing required transformations in the Power BI query editor using a mixture of utilizing the UI and writing M code, DAX code. 
Dimensional data modeling and Extract Transform Load (ETL) using Dataflows
Knowledge of Extract Transform Load (ETL) tools such as DataStage.
Designing and building data flows including Transformations and Data Sources
Knowledge of Geo Analytics capabilities , PowerBI integration with ESRI ArcGIS
Knowledge of Data Governance platform, integration with PowerBI for data lineage 
Knowledge of BW4HANA, SAP DataSphere and SAC (SAP Analytics Cloud)

Knowledge Continued

For Automation positions:

Proven knowledge of enterprise automation platforms, including Microsoft Power Platform (Power Automate, Power Apps, Dataverse)
Knowledge of Robotic Process Automation (RPA) concepts, tools, and implementation approaches (Power Automate Desktop, UiPath)
Knowledge of application lifecycle management (ALM) practices, including CI/CD pipelines, source control (Git), and Azure DevOps
Knowledge of scripting and programming languages (PowerShell, Python, GoLang) for automation and integration purposes
Knowledge of system integration techniques, including RESTful APIs, web services, authentication methods, and data exchange patterns
Knowledge of relational and non-relational databases (SQL Server, Dataverse) and their use in automation solutions
Knowledge of cloud-based platforms and services (Azure) as they relate to automation and integration solutions

COMPETENCIES, SKILLS AND ABILITIES

Develop applications 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
Good oral and written communication skills
Mentor junior staff (where applicable) Organize, develop and document procedures
Good organization and prioritization skills to handle multi-tasking
Enterprise scale application deployments
Development techniques for optimal performance and scalability
Collaborative approach in working with others
Converse effectively using both technical and general business terminology
Diplomacy and tact
Demonstrate initiative and self-motivation
Work effectively under pressure
Work with minimum supervision
Flexible
Able to meet deadlines
Client-focussed and service-oriented
High degree of interpersonal skills

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 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.

Apply now »