Data Analyst

City of North Vancouver; North Vancouver; On-site; CAD 80,000 - 100,000; Full time

Job summary

A local government entity in Metro Vancouver seeks a Data Analyst to support data initiatives that enhance decision-making across municipal services. The ideal candidate will develop business intelligence solutions, ensuring data integrity, and promote a data-driven culture. Proficiency in SQL, Python, and data visualization tools like Power BI is essential. This position offers $46.07 to $54.44 per hour, with opportunities for ongoing professional development.

Qualifications

• Proficiency in SQL and relational databases is essential.
• Strong Python skills for data manipulation and analysis.
• Expertise in developing reports and dashboards using SSRS and Power BI.
• Ability to communicate complex data insights to non-technical stakeholders.
• Familiarity with spatial data is a significant asset.

Responsibilities

• Research, compile datasets to support business needs.
• Develop ETL workflows to validate and integrate data.
• Design interactive dashboards that communicate insights.
• Collaborate with teams to maintain data integrity.
• Recommend innovative tools for enhanced data analytics.

Skills

SQL

Python

Data Visualization

Statistical Analysis

Communication

Education

Bachelor’s degree in computer science, mathematics, statistics, data science, or related field

Tools

SQL Server

Power BI

ArcGIS

Job description

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.
• 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.
• Design and develop interactive dashboards, reports, and data visualizations that effectively communicate performance metrics and insights to stakeholders, enabling data-driven decision-making.
• Collaborate with cross-functional teams to understand data requirements and maintain data accuracy, consistency, and integrity.
• Provide guidance on best practices for data management and analytics; actively explore emerging technologies in data science to recommend innovative tools that enhance the City’s data analytics and reporting capabilities.

Requirements

• 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; 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 for translating complex data into clear, actionable insights for non-technical stakeholders.
• Familiarity with spatial data, ArcGIS applications within a municipal setting is 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.

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 [e-mail]. 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̱ wú7mesh Úxwumixw (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.

Posting Detail Information

Posting Number 2025-0111; Job Open Date 09/17/2025; Job Close Date 10/01/2025; Special Instructions to Applicants