Geospatial Data Analyst (Computer Programmer/Analyst)

Requisition ID: 40651 

Group

Positioned on the standard, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a dedication to changing into a Metropolis of Reconciliation. Vancouver persistently ranks as one of many world’s most habitable cities and is working in direction of being the greenest metropolis on the planet. Named amongst Canada’s High 100 Employers, BC’s High Employers, and Canada’s Greenest Employers, the Metropolis of Vancouver seeks colleagues who may help form and embody our core commitments to sustainability, decolonization, fairness and excellent high quality of life for all residents.

Contemplate becoming a member of our dedicated workforce of workers and being a part of an revolutionary, inclusive and rewarding office.

 

Major Goal and Perform

The objective of the GIS & CADD Companies Department on the Metropolis of Vancouver is to empower Metropolis workers and residents to successfully use geospatial data to enhance resolution making, evaluation, metropolis providers and total operations. We’re presently implementing a strategic plan to resume the Geographic Data Programs (GIS) platforms and associated purposes. Main goals are to create a sturdy governance and help mannequin, strengthen and renew the geospatial expertise platform, preserve top quality geospatial information, present information discovery and entry, and develop excessive worth geospatial purposes.

 

The Geospatial Information Analyst will carry out advanced analytical and programming work largely targeted on database modeling and geodata administration however could embody all phases of laptop initiatives together with laptop programming, testing and implementation; techniques evaluation and feasibility evaluation; documentation and coaching. The incumbent analyzes current and proposed information, techniques and procedures, designs and develops advanced scripts to create and preserve subtle information fashions and information loading procedures. The place requires creating in a networked surroundings utilizing quite a lot of programming languages, working techniques, database and different applied sciences.

Particular Duties/Obligations

• Consults with consumer division workers in analyzing current and proposed information mannequin, system procedures and necessities; recommends, designs and develops laptop system options for issues of various complexity
• Prepares detailed specs for and writes new geodata administration course of and applications and revises current information fashions and applications using all accessible and relevant software program aids and languages
• Supplies technical help for and coordinates the event and integration of information and applications; prepares check information and conducts program testing and debugs applications; identifies the necessity for extra testing
• Prepares and maintains detailed consumer, techniques and operations documentation; prepares and supplies displays, workers orientation, coaching and sensible steerage on using new or modified laptop techniques and software program
• Evaluates the necessity for and develops basic function, reusable information fashions, applications and processes to facilitate laptop system and expertise implementations
• Estimates time and value of system improvement actions primarily based on prevailing undertaking administration requirements and stories progress towards these estimates
• Manages and administers databases, information, software program and technical platforms akin to servers and working techniques.  This might embody advising workers on performance, helping workers to find and extract wanted information, creating applicable queries, creating SQL execution plans and creating customized applications for extra advanced evaluation wants
• Participates in planning and implementations of enterprise information administration and information custodianship modeling  
• Supplies spatial information administration required to help Enterprise Intelligence, Open Information and information analytics applications and processes
• Supplies technical advice and course to managers, programmers or junior technical workers, shoppers or consultants because the course of enterprise requires
• Assists within the improvement of laptop techniques requirements for system help and upkeep of assorted enterprise capabilities
• Retains up-to-date with developments in programming strategies and languages, working techniques, database administration, software program, computing {hardware}, the present state of the Data Expertise trade and trade developments, and associated issues
• Conducts technical and Data Expertise trade analysis.  Advises on trade developments; feasibility of applied sciences, merchandise and expertise options related to the Engineering Companies Division
• Leverages trade greatest practices to design, check, implement and help options 
• Assures high quality, safety and compliance necessities together with privateness impression evaluation necessities are met 
• Different duties/duties as assigned

 

Minimal Place Necessities
Schooling and Expertise:

• Completion of a two 12 months diploma course in laptop programming, database administration, or techniques improvement at a technical institute or group school plus appreciable associated work expertise or an equal mixture of coaching and expertise
• Completion of ESRI certification (Enterprise Geodata Administration Skilled) or an equal mixture of coaching and expertise most well-liked
• A minimal of three years expertise (ideally in a municipal and/or GIS surroundings) within the improvement and upkeep of laptop techniques in a networked surroundings; integration of purposes and databases throughout platforms; utilizing quite a lot of the programming languages, DBMS and different software program instruments

 

Data, Abilities and Talents:

• Thorough information of data expertise particularly internet, client-server, relational, object-oriented, database and community ideas; Microsoft working techniques; workplace productiveness software program
• Thorough information of relational database ideas ideally associated to Oracle 19c and above and SQL Server 2019 and above, and their integrations 
• Thorough information and understanding of using an ESRI Geodatabase v 10.x and above with the demonstrated means to carry out the next duties:   
  • Create and configure a geodatabase
  • Design a geodatabase primarily based on enterprise necessities
  • Perceive using workflows and the impression of every on the database
  • Handle the info inside a geodatabase or database
  • Metadata administration
  • Carry out geodatabase upkeep
  • Design versioning workflows
  • Troubleshoot geodatabase associated points
  • Implement distributed information workflows
  • Handle the ArcGIS Information Retailer
  • Create views and SQL statements to entry databases instantly
  • Implement and handle geodatabase archiving
• Carry out migrations and/or upgrades to a geodatabase
• Robust working information of Python 2.x and three.x
• Appreciable information of the programming languages and software program improvement instruments in prevailing use of the GIS and CADD Companies Department
• Appreciable information of Geographical Data Programs (GIS) and/or Laptop-Aided Drafting and Design (CADD), their use in a municipal surroundings and of their interplay with enterprise processes and different techniques
• Working information of Enterprise Intelligence, cloud storage and integration, Open Information and information analytics ideas and practices
• Some information of the operations, procedures and insurance policies of assorted metropolis departments
• Glorious organizational, time administration and self-starting abilities
• Capability to gather, analyze and consider data required for evaluation and programming functions, to develop logical options for assigned issues and implement them
• Glorious management abilities and skill to develop and mentor others
• Capability to speak successfully each orally and in writing on technical and non-technical issues with all ranges within the group, and with exterior shoppers
• Capability to develop and preserve efficient working relationships in any respect ranges within the group, and with exterior shoppers
• Capability to work successfully with altering and competing priorities with frequent interruptions inside a a number of job surroundings

 

The place operationally applicable and topic to vary, the Metropolis of Vancouver has a Versatile Work Program. This program permits workers to work remotely 1 – 4 days every week from places which might be a each day commutable distance from their work at a Metropolis worksite.  At the moment this place is eligible to be a part of the Versatile Work Program.

 

Enterprise Unit/Division: IT, Digital Technique & 311 (1070) 

Affiliation: CUPE 15 Non Pks 

Employment Kind: Common Full Time 

Place Begin Date: Could, 2024  

Wage Data: Pay Grade GR-027: $47.62 to $56.27 per hour

 

Software Shut: March 29, 2024

On the Metropolis of Vancouver, we’re dedicated to recruiting a various workforce that represents the group we so proudly serve. Indigenous peoples, individuals of color, 2SLGBTQ+ individuals together with all genders and individuals with disabilities are inspired to use.  Lodging shall be offered upon request throughout the choice course of. Learn more about our commitment to diversity and inclusion. 

 

Earlier than you click on Apply now

When you begin your utility it can save you your work and go away the purposes web page, nevertheless please keep in mind to submit your profile to the particular job requisition earlier than the posting deadline.

Along with importing your cowl letter and resume, a part of the appliance course of could embody answering utility questions associated to the popular necessities of the function which can take approx. 5-10 minutes. Cowl letters ought to categorical curiosity and spotlight further data related to the place and resumes ought to embody a abstract of abilities and expertise associated to the place.