Systems Analyst II

Requisition ID: 34978 


Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh), Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable cities and is working towards being the greenest city in the world. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, decolonization, equity and outstanding quality of life for all residents.

Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.


Main Purpose & Function 
The primary purpose of this position is to investigate IT and business requirements; design, develop, document and support solutions that allow you to automate processes, build solutions, & analyze data; and apply knowledge of the best-of-breed processes and procedures in business applications to recommend changes to business processes.  This position is to be a leader of software development projects through the preliminary investigation, analysis of requirements, business case and feasibility analysis, design, implementation, quality control, documentation, and post-implemenation review phases.  This position provides ongoing application, data, analytics and integration platform support and responsibilities may include performing changes to business application configuration and programs.  This position also performs hands-on programming when requried. The position has access to confidential information and makes recommendations for changes in methods, processes and procedures that may impact on financial and operational areas as well as staffing work loads, working conditions, changes in positions or staffing levels.


Specific Duties & Responsibilities

  • Serve as subject matter expert on the Microsoft Power Platform.  To work with team manager to develop the strategic plan on MS Power Platform adoption in the City
  • Deliver services and solutions using the Microsoft Power Platform suite Power BI, Power Apps, Power Automate, custom development, and data integrations with Azure Integrations
  • Designs, develops and sustains MS Power Platform applications and solutions (Power Automate, Power Apps, Power BI), O365 Teams and SharePoint Online
  • Manage configurations, integrations and deployments on various environments such as Development, Test and Production.
  • Maintain Dataverse in Power Platform
  • Create Custom components and connectors
  • Provide architecture designs, configurations, administration, and functional support
  • Responsible for providing full lifecycle Power BI administration (i.e. patches, updates, AD security, account management, capacity management, procedures documented) including the ability to work with data owners and report developers to support their needs in the best way possible
  • Knowledge and experience on how to grow and integrate Power BI services by designing and deploying workspaces, role security on PBI work spaces crossing multiple teams, data models, app tiers, gateways, report services, dashboard support, teams integration, and mobile app deployment is preferred
  • Ability to configure data gateways for access to multiple data sources across the enterprise
  • Standardize and optimize the ways data is stored and retrieved
  • Create and maintain documentation for the environment and solutions
  • Provide daily production system support and user support
  • Performs hands-on programming when requried to support projects and technology pilots
  • Researches, evaluates and recommends new tools and methodologies for development of business applications
  • Identifies opportunities to improve operational effectiveness through the use of technology and makes recommendations where appropriate (make changes to use of system, business process and/or add additional functionality)
  • Recommends changes in technology platforms and processes that may impact on financial and operational areas as well as staffing work loads, working conditions, changes in positions or staffing levels
  • Consults with customers to understand their requirements
  • Manages projects through all phases from planning, design, development, implementation and hand-over to operational support
  • Prepares documentation including project charters, business cases, statements of work, estimates, matrices of responsibility, training materials, system configuration documentation, etc.
  • Develops systems alternatives including work procedure changes, and recommends the most suitable alternative to assist customers in meeting their operational requirements
  • Develops technical specifications including diagrams and charts to provide the blueprints for developers to write or code programs
  • Reviews or develops test scripts and scenarios to ensure adequate testing of system configuration and integration
  • Performs testing, configuration changes, enhancements and new functionality in order to ensure system integrity and proper integration across various applications
  • Remains current with developments in applications and related technologies, including releases and enhancements/new functionality
  • Delivers presentations to customers (users, departments) and technical staff on systems solutions and specific technologies
  • Provides problem resolution for calls referred by Help Desk
  • Investigates and follows up on application system errors/problems, and liaises with IT staff or vendors as required to resolve these issues
  • Provides technical assistance to business applications upgrades and implementation of other modules, including integration to other applications
  • Provides support to corporate and departmental reporting, assists in the use of existing reports, and develops/documents additional reports, as required
  • Monitors applications performance, trouble shoots problems with technical specialists
  • Participates in training of customers and provides on-going training support and guidance
  • Participates in the development of new standards, and leads technical committees
  • Has access to highly sensitive and business critical data from all City departments (e.g. taxes and utilities owing, parking tickets outstanding, and vendor pricing)
  • Other duties/responsibilities as assigned



Education and Experience:

  • Related post-secondary degree, with preference for graduate degree in Computer Science, Analytics, or an equivalent combination of education, training and experience
  • Microsoft certificate on Power Platform, or Azure specific training or certifications are assets
  • At least 3 years working with MS Power BI Services including Power BI Premium
  • Demonstrable experience implementing and supporting Microsoft Power platforms, including use of Azure CLI to manage and support the services
  • 5+ years of experience in developing and implementing business applications
  • 5+ years of experience with application development tools and standards as well as general programming principles and methodologies
  • 5+ years of experience with application reporting tools
  • 5+ years of experience with server technology and software
  • 5+ years of experience with system integration between business applications and across technical platforms
  • Experience with API Management and Integration Platforms (API design, gateways, analytics)


Knowledge, Skills and Abilities:

  • Excellent oral, written and presentation skills with ability to communicate to all levels of the organization
  • Expert knowledge of data pipeline from ingestion to consumption, including working with in-memory analytics engine and dimensional modeling
  • Thorough knowledge of programming technologies: .NET Core, React, JavaScript, integration tools (SSIS, low code platform Azure Logic App and Power App), Microsoft Azure development including Azure DevOps, Logic Apps, Function Apps, Automation Runbooks, ARM Templates, SSRS, SSAS
  • Thorough knowledge of current trends, standards, and products in Information Technology,  (i.e. .NET and Object-Oriented Methodology, Mobile Computing, Cloud, Business Intelligence, Social Media)
  • Demonstrated operational and project management skills: results focused, team oriented
  • Broad knowledge across multiple aspects of the business (i.e. organizational structure, key players, current business processes and supporting systems and services, etc.)
  • Thorough knowledge of configuration of applications
  • Thorough knowledge of office productivity tools (e.g. Windows, MS Office, MS Project, MS Visio, etc.)
  • Thorough knowledge of related corporate applications and work procedures
  • Strong analytical and problem solving skills
  • Combination of strong technical and business skills required
  • Demonstrated ability to work both independently and as a member of a team
  • Ability to manage projects, multiple priorities and respond to requests in a timely manner
  • Ability to establish and maintain effective working relationships both internally and externally with technical and non-technical staff
  • Ability to handle business critical and sensitive information
  • Demonstrated ability to work under pressure, manage multiple priorities and respond to requests in a timely manner
  • Continuous improvement and continuous learning mindset
  • Knowledge of municipal business processes would be an asset


All City of Vancouver employees are required to be fully vaccinated as a condition of hire and ongoing employment.  Candidates may only be exempted from this requirement if they request and are approved for an accommodation based on a reason related to a Human Rights Code ground (such as disability). Such a request must be made during, not after, the recruitment process. 


Business Unit/Department: IT, Digital Strategy & 311 (1070) 

Affiliation: Exempt 

Employment Type: Regular Full Time 

Position Start Date: February, 2022 


Application Close: January 31, 2022

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous applicants, people of colour, all genders, LGBT2Q+ and persons with disabilities are encouraged to apply.  Accommodations will be provided upon request during the selection process. Learn more about our commitment to diversity and inclusion


Before you click Apply now

Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx.. 5-10mins. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a tailored summary of skills and experience related to the position.


Job Segment: Systems Analyst, Developer, Computer Science, Application Developer, Cloud, Technology