SYSTEM ANALYST (Full Time)

Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh Úxwumixw (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. 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, reconciliation, equity and outstanding quality of life for all residents.
Working at the City of Vancouver and within the public service can be a rewarding career where you play a key role in ensuring impartial and equitable access to services, upholding ethical governance, and addressing the needs of citizens with integrity and dedication.

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; 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-implementation 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 required. Serve as subject matter expert on the Microsoft Power Platform. Deliver services and solutions using the Microsoft Power Platform suite Power Apps, Power Automate, custom development, and data integrations with MS Fabric and other 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.
Provide architecture designs, configurations, administration, and functional support
Responsible for providing full lifecycle Fabric 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 MS Fabric/Power BI services by designing and deploying workspaces, role security on PBI workspaces 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
Performs hands-on programming when required to support projects and technology pilots
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
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)
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 Fabric/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 with application development tools and standards as well as general programming principles and methodologies
• 5+ years of experience with server technology and software
• 5+ years of experience with system integration between business applications and across technical platforms
• 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
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
Combination of strong technical and business skills required
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
Continuous improvement and continuous learning mindset
Knowledge of municipal business processes would be an asset

Business Unit/Department : IT, Digital Strategy & 311 (1070)
Employment Type: Regular Full Time
At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders and persons with disabilities are encouraged to apply. Learn more about our commitment to diversity and inclusion.