Senior Systems Developer/Integrator, Business Intelligence

at  City of Ottawa

Requisition ID: 13509
Department: Finance and Corporate Services Dept.
Service: Information Technology Services
Branch: Technology Modernization Branch
Employment Type: 1 Full-time Temporary - Up to 1 year
Work Hours: 35.00 hours per week
Affiliation: CIPP
Salary Information: $91,476.84 - $111,314.84 annually (2024 rates of pay)
Location: 100 Constellation, Nepean
City: Ottawa, ON
Job Category: Information Technology
Application Close: 02/07/2024

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 Business Intelligence Reporting you are responsible for: developing Business Intelligence reports and data visualizations using Microsoft Power BI, which includes data modeling and data transformations using variety of data sources; Leading Analytics / ETL activities for large scale projects; actively participate in establishing and sustaining the Enterprise Data Management capabilities; act as a key subject matter expert in all levels of BI design, creation, and maintenance.; researching, architecting, designing, developing, customizing, enhancing and/or integrating large-scale applications/solutions for assigned clients in response to new or changing business requirements and/or for assigned projects; maintaining these applications/solutions; and providing client technical support.
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

• 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:
• 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

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

Please refer the Job description for details