Data and Analytics Analyst

Data and Analytics Analyst 

 

Posting Id 2940 Department Corporate and Financial Services Division Information Technology Section Geospatial Information System (GIS)  Job Grade Contract SEA Grade 06  Rate of Pay $42.88 - $50.45 Hourly Job Type Temporary Full Time - Contract Contract Length/End Date 9 months Replacement/New Position          New Hire Posting Type Internal and External Posting Date 04/01/2025  Application Deadline 04/14/2025 

 

Shape Tomorrow, Today: Be Our City's Data Alchemist and Transform our data to gold!

Are you a passionate and multi-faceted data enthusiast looking for your next big adventure? Dive in, stand out and lead the way to govern, analyze and elevate the data ecosystem at the City of Richmond Hill. The City’s Data & Analytics team is seeking a talented Data Analyst to advance the data management landscape, build data solutions, communicate data stories, and shape our digital future with a human-centered design perspective.

 

You will collaborate with a forward-thinking team to enhance data governance, elevate data quality, and build a comprehensive data catalog. By developing a robust business glossary and fostering data literacy, you will mine meaningful insights, craft compelling data narratives, and inspire actionable intelligence. Your contributions will inform policies, drive informed decisions, and propel the community toward greater data maturity.

 

If you're ready to take on exciting challenges, drive innovation, and be at the forefront of urban data analytics, apply now and become an integral part of a small but dedicated team where your skills will make a tangible impact every day.

 

Shape a city. Shape a legacy. Shape your future. Join our Mission!

Position Summary

The Data Analyst will oversee, maintain, and assess data frameworks from numerous sources and systems, identifying patterns to assist divisions throughout the corporation in making strategic, informed business decisions. The Data Analyst will closely collaborate with departments and divisions to design solutions that streamline, automate, and support everyday data operations. This includes creating and managing data catalogs, improving data quality, ensuring consistency in Business Glossary terms, and fostering data literacy across the organization. Moreover, this role will deliver comprehensive reports, dashboards, and visualizations to encapsulate insights from data analysis and processing. Operating under and advocating for IT's Data Governance framework, this role will emphasize data architecture, management best practices, tools, software platforms, and reporting standards. The Data Analyst will undertake professional assignments in researching and analyzing operational processes and business requirements while leading projects and project teams.

Key Duties and Responsibilities

Data Management and Project Management Functions:

• Advance and enhance Data Governance as part of IT Work Plan for 2025
• Develop a Data Quality framework, metrics and help define the policies, procedures and standards for managing data effectively.
• Develop a functional light-weight Data Catalog to build an inventory of commonly used data tables from multiple enterprise systems, along with the business glossary and other associated metadata.
• Help build a Data Literacy framework to advance the staff’s understanding of the various facets of data management based on their day-to-day business / operational requirements.
• Lead, innovate, create, and support corporate data quality assessment, data modeling methodologies, data integration best practices, process models and data flows
• Develop and implement databases, data collection systems, surveys, data analytics and other strategies that optimize efficiency and quality
• Consult with business partners to conduct needs requirements, assess functional and system and data requirements
• Lead projects using project management principles and methodologies including the development of charters, objectives, and schedules
• Lead spatial and non-spatial application development activities including design, development, and implementation

Data, Analytics and Reporting & Visualization Functions:

• Lead, innovate, create, and support corporate reporting initiatives such as visualizations through reports, mapping, and dashboard best practices including documentation of governance and process
• Identify, analyze, and interpret trends or patterns in complex 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 business process, targets, compliance, and opportunities for improvement.
• Work with business partners to develop queries for, and automation, of monthly reporting, as well as perform ad hoc queries, data extracts, and data analysis to produce actionable information around key decision making

Duties and Responsibilities Cont'd

Quality Assurance and Due Diligence Functions:

• Ensure quality control within spatial and non-spatial data through implementation of QA/QC procedures, development of standards, and performance monitoring as per the data governance framework.
• Monitor data related systems, applications, databases, and websites to ensure conformance to corporate standards and guidelines.
• Promote and ensures user community understands and adheres to corporate data governance for data and products.

Liaison, Communication and Customer Service:

• Liaise with business partners, consultants, regional partnership, and vendors to ensure needs and requirements are met, and provide advice and support to user community on standards, models, and applications.
• Participate on committees, work groups, task forces and special projects as needed.
• Promote corporate data governance for spatial and non-spatial data through projects, presentations, and report authoring.
• Deliver user knowledge transfer and education as required.

Education and Experience

• University Degree in Information Technology, Computer Science, or related discipline with an emphasis on data management and analytics
• Minimum 3 years of experience in data and analytics, GIS, data management and data visualization
• Experience in implementing DAMA-DMBOK, GISP, PMO, CDMP and Data Analytics Certifications considered an asset

Required Skills/Knowledge

• Minimum of 3 years of progressively responsible and practical experience in data management, analytics and application of visualization tools with spatial and non-spatial data.
• Experience working with relational and non-relational database systems including database standards, design, data models, creation methods and techniques.
• Experience working with industry data management, analytics, and visualization platforms and tools including R, Python, ArcGIS, PowerBI or Tableau, Microsoft Fabric, Power Apps, Power Automate, Azure Data Factory and Azure Synapse Analytics.
• Demonstrated knowledge to effectively use Project Management suite such as Microsoft Tasks, Microsoft Planner, Microsoft Project for the Web, and Microsoft Project Desktop App.
• Experience in development with web-based technologies, APIs, automation suites and extract-transform-load (ETL) processes; working with Safe Software's FME.
• Experience in SQL scripting to develop, implement and optimize queries, stored procedures and functions within the Microsoft Data Management platform; Querying SQL/NoSQL databases.
• Strong analytical, data visualization and presentation skills.
• Demonstrated understanding and implementation of ideation, process mapping, requirements gathering, and project planning, research, and documentation.
• Demonstrated ability to establish and build effective working relationships with customer base and project stakeholders.
• Demonstrated organizational skills and ability to prioritize workload.
• 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

 

Attention Internal Candidates:  All current City of Richmond Hill employees are required to apply via the ‘View Jobs for Current Employees’ link on the City’s Careers Page.

 

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.