Data and Analytics Technologist – IT

Job title: Data and Analytics Technologist – IT

Job description: Data and Analytics Technologist – IT

Posting Id 1204
Department Corporate and Financial Services
Division Information Technology
Section Geospatial Information System (GIS)
Job Grade Contract SEA Grade 05
Rate of Pay $68,521.00 – $80,597.00 Annual
Job Type Full-time – Contract
Contract Length/End Date 8 Months
Replacement/New Position Replacement
Posting Type Internal and External
Posting Date 12/16/2021
Application Deadline 01/07/2022

Position Summary

The Data and Analytics Technologist, will examine data sets from various sources and systems and identify trends to help divisions across the corporation make strategic and informed business decisions. In addition to creating and maintaining data (spatial and non-spatial) this role will deliver reports, dashboards, mapping and visualizations to summarize insights from data mining, processing, and analysis.

This role will operate under and promote IT’s Data Governance framework, including data/database architecture, data management best practice, tools and software platforms, and reporting templates. This contracted position will be primarily focused on GIS and Mapping. Including digitizing, asset data entry, and quality evaluation. A secondary focus is on Drawing Management including drawing intake, processing, cataloguing, and asset extraction. As such the ideal candidate will have strong abilities in GIS Fundamentals and be proficient in ArcMap & ArcGIS Pro. You will also be able to assess and interpret engineering Drawings typically in CAD format.

Key Duties and Responsibilities

• Advance and enhance data governance as part of IT’s Data Framework. The Data And Analytics Technologist advises, implements and supports corporate data quality assessment, data modeling methodologies, data integration best practices, and reporting initiatives such as visualizations through reports, mapping, and dashboards.
• Identify, analyze, and interpret trends or patterns in data sets against key performance indicators and industry benchmarks.
• Interpret data using statistical modelling to provide ongoing reports and data visualization dashboards that expands an understanding of performance.
• Become knowledgeable in the business workflow and process of business systems use, including data acquisition, data creation, data management practice, data flow, data source, and products.
• Work with IT to develop queries for and automation of cyclical reporting and perform ad hoc queries, data extracts, and data analysis to produce actionable information around key decision making.
• Develop and implement databases, data collection systems, surveys, data analytics and other strategies that optimize efficiency and quality standards & tools as described by the Information Technology division.

Education and Experience

• Diploma in Data Science, Statistics or Mathematics, Engineering, Computer Science, or a combination of education and experience in a related field
• A minimum of 2 years of experience in data management, analytics, GIS, data visualization and application of visualization tools with spatial and non-spatial data
• Municipal experience is considered an asset
• Degree in Data Science, Statistics or Mathematics, Engineering, Computer Science is considered an asset
• Courses in any of the following preferred: data analysis and design, business intelligence analytics, data management, data modelling, statistics and statistical analysis is considered an asset

Required Skills/Knowledge

• Demonstrated data reporting, analytical, visualization and presentation skills using platforms such as PowerBI or Tableau
• Experience improving existing data recording and reporting systems including experience working with relational database systems, spatial and non-spatial databases, including standards, design and modeling
• Good Analytical and Problem Solving skills, and experience of QA/QC principles and data integrity issues
• Working knowledge of scripting, ETL (Extract Transform Load), and programming (JavaScript, Python, HTML5, CSS, XML, JSON, FME)
• Knowledge of database systems, data creation methods and techniques (spatial and non-spatial), querying SQL/NoSQL databases and RESTful API’s
• Working knowledge of SQL scripting to develop, implement and optimize queries, stored procedures and functions within the Microsoft Data Management platform (SQL Server, SSIS, SSAS, SSRS, PowerBI)
• Experience with GIS Technologies and GIS data/databases; working with ESRI’s GIS Suite
• Demonstrated organizational skills and ability to prioritize workload
• Demonstrated ability to establish and build effective working relationships
• Demonstrated ability to work independently, in small groups, and in team environments

Leadership Competencies

• Builds people and culture
• Cultivates open communication
• Demonstrates personal leadership
• Navigates and leads through complexity and change
• Shapes the future

We thank all candidates for their interest, however, only those under consideration will be contacted.

The City of Richmond Hill is committed to inclusive, barrier-free recruitment and selection processes. If contacted to participate in the recruitment and selection process, please advise Human Resources if you require an accommodation.

Please note, to be considered for a career opportunity at the City of Richmond Hill you must have received the full series of a COVID-19 vaccine approved by Health Canada (or the World Health Organization). You may also be required to receive any COVID-19 boosters recommended by public health authorities. The City of Richmond Hill will consider cases requiring accommodation as stipulated by relevant employment standards legislation or regulation and/or the Ontario Human Rights Code.

Company: Richmond Hill

Expected salary: $68521 – 80597 per year

Location: Richmond Hill, ON

Job date: Sat, 18 Dec 2021 04:41:14 GMT

Job Source: Careerjet.ca

Click Here to Apply