GIS Analyst - Jobs in Vancouver, BC

Job Description

Requisition ID: 26104CompanyLocated 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 and FunctionThe Geospatial Data Analyst will perform complex analytical and programming work mostly focused on database modeling and geodata management but may include all phases of computer projects including computer programming, testing and implementation; systems analysis and feasibility analysis; documentation and training. The incumbent analyzes existing and proposed data, systems and procedures, designs and develops complex scripts to create and maintain sophisticated data models and data loading procedures. The position requires developing in a networked environment using a variety of programming languages, operating systems, database and other technologies.Specific Duties/ResponsibilitiesConsults with user department staff in analyzing existing and proposed data model, system procedures and requirements; recommends, designs and develops computer system solutions for problems of varying complexityPrepares detailed specifications for and writes new geodata management process and programs and revises existing data models and programs utilizing all available and applicable software aids and languagesProvides technical assistance for and coordinates the development and integration of data and programs; prepares test data and conducts program testing and debugs programs; identifies the need for additional testingPrepares and maintains detailed user, systems and operations documentation; prepares and provides presentations, staff orientation, training and practical guidance on the use of new or changed computer systems and softwareEvaluates the need for and develops general purpose, reusable data models, programs and processes to facilitate computer system and technology implementationsEstimates time and cost of system development activities based on prevailing project management standards and reports progress against those estimatesManages and administers databases, data, software and technical platforms such as servers and operating systems. This could include advising staff on functionality, assisting staff to locate and extract needed data, developing appropriate queries, creating SQL execution plans and creating custom programs for more complex analysis needsParticipates in planning and implementations of enterprise data management and data custodianship modelingProvide spatial data management required to support Business Intelligence, Open Data and data analytics programs and processesProvides technical recommendation and direction to managers, programmers or junior technical staff, clients or consultants as the course of business requiresAssists in the development of computer systems standards for system support and maintenance of various business functionsKeeps up-to-date with developments in programming techniques and languages, operating systems, database management, software, computing hardware, the current state of the Information Technology industry and industry trends, and related mattersConducts technical and Information Technology industry research. Advises on industry trends; feasibility of technologies, products and technology alternatives relevant to the Engineering Services DepartmentLeverages industry best practices to design, test, implement and support solutionsAssures quality, security and compliance requirements including privacy impact assessment requirements are metOther duties/responsibilities as assignedMinimum Position RequirementsEducation and Experience:Completion of a two year diploma course in computer programming, database administration, or systems development at a technical institute or community college plus considerable related work experience or an equivalent combination of training and experienceCompletion of ESRI certification (Enterprise Geodata Management Professional 10.5) or an equivalent combination of training and experience preferredA minimum of 3 years experience (preferably in a municipal and/or GIS environment) in the development and maintenance of computer systems in a networked environment; integration of applications and databases across platforms; using a variety of the programming languages, DBMS and other software toolsKnowledge, Skills and Abilities:Thorough knowledge of information technology specifically web, client-server, relational, object-oriented, database and network concepts; Microsoft operating systems; office productivity softwareThorough knowledge of relational database concepts preferably related to Oracle 11g and above and SQL Server 2008 and aboveThorough knowledge and understanding of the use of an ESRI Geodatabase v 10.x and above with the demonstrated ability to perform the following duties:Create and configure a geodatabaseDesign a geodatabase based on business requirementsUnderstand the use of workflows and the impact of each on the databaseManage the data within a geodatabase or databasePerform geodatabase maintenanceDesign versioning workflowsTroubleshoot geodatabase related issuesImplement distributed data workflowsManage the ArcGIS Data StoreCreate views and SQL statements to access databases directlyImplement and manage geodatabase archivingPerform migrations and/or upgrades to a geodatabaseStrong working knowledge of Python 2.7 and 3.5Considerable knowledge of the programming languages and software development tools in prevailing use in the GIS and CADD Services BranchConsiderable knowledge of Geographical Information Systems (GIS) and/or Computer-Aided Drafting and Design (CADD), their use in a municipal environment and of their interaction with business processes and other systemsWorking knowledge of Business Intelligence, Open Data and data analytics concepts and practicesSome knowledge of the operations, procedures and policies of various city departmentsExcellent organizational, time management and self-starting skillsAbility to collect, analyze and evaluate information required for analysis and programming purposes, to develop logical solutions for assigned problems and implement themExcellent leadership skills and ability to develop and mentor othersAbility to communicate effectively both orally and in writing on technical and non-technical matters with all levels in the organization, and with external clientsAbility to develop and maintain effective working relationships at all levels in the organization, and with external clientsAbility to work effectively with changing and competing priorities with frequent interruptions within a multiple task environmentBusiness Unit/Department: IT, Digital Strategy & 311 (1070)Affiliation: CUPE 15 Non PksEmployment Type: Temporary Full TimePosition Start Date: June, 2021Position End Date: June, 2022Salary Information: Pay Grade GR-027: $41.29 to $48.78 per hourApplication Close: May 14, 2021At 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.To be considered for this exciting and impactful career opportunity with a generous benefits package, please apply on our careers site.Apply hereOrganization: Vancouver (City)Region: Lower MainlandProfessional Categories: Geographic Information SystemsPosted: May 5, 2021, 3:09 pmExpires: May 14, 2021, 11:59 pmEmployment Type: Full TimeEmployment Length: TemporaryEducation Requirement: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 yearsJob Experience: 3 years to less than 5 yearsRate: $41.29 to $41.29 Hour