Job Description

Position Information

Title

Data Analyst

Job Status

Regular Full Time

Position Overview

The City of North Vancouver is the urban core of the beautiful North Shore and has a long-term vision to be "The Healthiest Small City in the World", with five key priorities to be a City for People, a Resilient City, a Vibrant City, a Connected City and a Prosperous City.

The Corporate Services Department - Information Technology Division requires a highly driven and innovative Data Analyst to support data initiatives that enhance decision-making and operational effectiveness across municipal services. This role will play a key part in shaping the City's data strategy by developing and implementing business intelligence solutions, ensuring data integrity, and promoting a data-driven culture. The ideal candidate will leverage their expertise in data wrangling, analytics, and visualization to support strategic priorities and drive innovation within municipal operations.

Responsibilities

Reporting to the Manager of Data Services, you will research, identify, and compile datasets from diverse sources to support business needs. You will develop and implement ETL (Extract, Transform, Load) workflows to validate, process, and integrate structured data, leveraging statistical analysis, data modeling techniques, and business intelligence tools to uncover key patterns, trends, and anomalies. Additionally, you will design and develop interactive dashboards, reports, and data visualizations that effectively communicate performance metrics and insights to stakeholders, enabling data-driven decision-making.

Collaboration with cross-functional teams will be essential to understand data requirements and maintain data accuracy, consistency, and integrity. As a subject matter expert in data analytics, you will provide guidance on best practices for data management and analytics while actively exploring emerging technologies in data science to recommend innovative tools that enhance the City's data analytics and reporting capabilities.

Requirements

Reporting to the Manager of Data Services, you will research, identify, and compile datasets from diverse sources to support business needs. You will develop and implement ETL (Extract, Transform, Load) workflows to validate, process, and integrate structured data, leveraging statistical analysis, data modeling techniques, and business intelligence tools to uncover key patterns, trends, and anomalies. Additionally, you will design and develop interactive dashboards, reports, and data visualizations that effectively communicate performance metrics and insights to stakeholders, enabling data-driven decision-making.

Collaboration with cross-functional teams will be essential to understand data requirements and maintain data accuracy, consistency, and integrity. As a subject matter expert in data analytics, you will provide guidance on best practices for data management and analytics while actively exploring emerging technologies in data science to recommend innovative tools that enhance the City's data analytics and reporting capabilities.

Proficiency in SQL and relational databases, particularly SQL Server, is essential, along with experience in ETL processes and building data pipelines to process and integrate structured data. Strong Python skills for data manipulation, analysis, and automation are important, complemented by a solid foundation in statistical analysis and data modeling techniques.

Expertise in SSRS and Power BI--including DAX and Power BI Service administration--is essential for developing and sharing insightful reports, dashboards, and visualizations that support data-driven decision-making. Strong communication skills are crucial for translating complex data into clear, actionable insights for non-technical stakeholders. Familiarity with spatial data, ArcGIS applications within a municipal setting is also a significant asset.

The ideal candidate will have a Bachelor's degree in computer science, mathematics, statistics, data science, or a related field, plus sound related experience in quantitative data analytics, business intelligence, and data modeling. An equivalent combination of education, training, and experience will also be considered.

Compensation

$46.07 to $54.44 per hour (January 2024 rates)
Pay Grade 26 (Provisional)

Hours of Work

Required hours may consist of any 7 consecutive hours between 7:00am and 11:00pm, Monday to Friday, and may also include an occasional shift on weekends or evenings. The City of North Vancouver currently works on a compressed work schedule with one scheduled day off (Monday or Friday) in approximately each three-week scheduling cycle.

Additional Information

How to Apply

If you are passionate about making the City of North Vancouver an even greater place to live, work and play, apply on-line through the Career Portal at

www.cnv.org

by October 1, 2025.

We are committed to being an inclusive employer--one that reflects the diversity of our community and values the unique contributions of each person.

Guided by our core values and Council's vision for an open and inclusive city, we work to create respectful, safe, and accessible workplaces. We regularly review and improve our hiring practices
to help identify and remove barriers. Through ongoing learning, we continue to address any that remain.

We welcome applications from all qualified candidates. If you need an accommodation during the selection process, or are having trouble completing or submitting your application, please contact us at

hr@cnv.org

. We're here to support your full participation.

Thank you for your interest in the City of North Vancouver.
We respectfully acknowledge that we live and work on the traditional and unceded territories of the S?wx? wu7mesh Uxwumixw (Squamish Nation) and s?lilw?ta? (Tsleil-Waututh Nation). The City of North Vancouver is committed to Reconciliation with these Nations, who have lived on these lands since time immemorial.