Senior Systems Developer/Integrator

City of Ottawa / Ville d’Ottawa

full-time

Posted on:

Location Type: Office

Location: Ottawa • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Salary

💰 CA$93,764 - CA$114,098 per year

Job Level

Senior

Tech Stack

CognosETLJavaOracle

About the role

  • Lead the design, development, administration, and optimization of enterprise BI and ETL solutions using Microsoft Fabric / Power BI, and Cognos.
  • Develop reports and dashboards, designing data models, performing data transformation, and building scalable data pipelines to support enterprise-wide analytics.
  • Act as a subject matter expert across all phases of BI solution design, development, maintenance, and support.
  • Contribute to the establishment and sustainability of the City’s Enterprise Data Management capabilities.
  • Write and maintain systems documentation.
  • Ensure all code is managed appropriately by using software configuration management tools.
  • Follow the approved project lifecycle (PLC), as appropriate.
  • Ensure 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).
  • Mentor/coaching of other developers.
  • Perform tests on enhancements/new development.

Requirements

  • 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.
  • 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)
  • Business intelligence tools and reporting with Cognos Analytics, Power BI
  • Power BI 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.
  • Designing and building data flows including Transformations and Data Sources
  • Knowledge of Geo Analytics capabilities, integration with ESRI-ArcGIS
  • Dimensional data modeling and Extract Transform Load (ETL) using Dataflows
  • Knowledge of Data Governance platform integration with Power BI for data lineage
  • IBM Cognos BI, IBM Cognos Analytics are desirable

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Microsoft FabricPower BICognosETLData modelingData transformationData pipelinesM codeDAX codeDimensional data modeling
Soft skills
MentoringCoachingCommunicationProblem-solvingCollaboration