City of Toronto SENIOR SPATIAL SPECIALIST in Toronto, Ontario
SENIOR SPATIAL SPECIALIST
Job ID: 37810
Job Category: Information & Technology
Division & Section: Technology Services, Technology Services Delivery
Work Location: 18 Dyas Rd, Toronto, M3B 1V5
Job Type & Duration: Full-time, Temporary Vacancy (12 months)
Hourly Rate and Wage Grade: $52.92 - $58.00
Shift Information: Monday to Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 2
Posting Period: 19-Sept-2023 to 03-Oct-2023
Coordinates, designs, develops, implements, configures, sustains, documents and reviews geospatial information systems.
Provides day to day support of geospatial information initiatives including unit and integration testing, documentation, installation, support and archival of project environments.
Undertakes quality reviews for geospatial solutions and information assets.
Participates in design and evaluation sessions of spatial data structures and spatially enabled applications with objectives to promote integration with existing geospatial information assets and tools and to ensure adherence to standards.
Assists business units in selecting and implementing appropriate geospatial technology and procedures to best serve their needs by researching and recommending viable options.
Reviews current applications and "off the shelf" software products and makes recommendations for usage.
Analyzes business and Information Technology issues as they pertain to the use of geospatial information and technology. Provides integration options as appropriate.
Transfers geospatial technology knowledge to groups well versed in the field and to groups new to the field.
Maintains an up to date knowledge of both the current and planned GIS platforms and development environments.
Maintains an up to date understanding of City information and technology platforms and applies this understanding to enhance geospatial information and technology usage for various business units.
Promotes geospatial information and technology through presentations and/or written descriptions to groups with varying levels of technical expertise.
Participates in geospatial information and technology project teams as requested and provides advice to team members.
Extensive experience in database design, including creating data models, schemas, and optimizing database structures for performance and scalability.
Extensive experience in database administration tasks, such as installation, configuration, backup and recovery, performance tuning, and security management.
Experience with spatial database systems such as PostGIS, Esri geodatabase, or Oracle Spatial for storing, managing, and querying geospatial data.
Post-secondary education in Software Engineering, Computer Science or an equivalent combination of educations and experience.
You must also have:
Strong SQL skills and the ability to optimize complex queries for efficient data retrieval and analysis in Postgres, Oracle, or other database technologies.
Proficient in designing and developing automation and integration tools using Python, SQL, Java, or other programming languages
Understanding of data governance principles, including data quality, metadata management, and data lineage.
Understanding of data security best practices, including encryption, access controls, and compliance with data privacy regulations.
NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:
City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment toemployment equity (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .
The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request . Learn more about the City’sHiring Policies and Accommodation Process (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .