Data Analyst

Clear Destination Inc.; Vancouver; Hybrid; CAD 82,000 - 93,000; Full time

Benefits offered by this job

Four weeks paid vacation

Excellent benefits package

Pension plan

Training and development support

Employee Wellness programs

Hybrid work arrangement

Job summary

Legal Aid BC is seeking a Data Analyst in Vancouver to transform data into actionable insights. The role focuses on defining data elements, modeling data, and maintaining data architecture across systems, while producing value-add BI reports.

You will design dashboards, translate complex findings for non-technical stakeholders, and advance the centralized BI program with ongoing testing and improvements. A strong data background is required.

Qualifications

• Bachelor’s degree in computer science or equivalent.
• Minimum three (3) years’ related experience including data analytics and reporting.
• Advanced working knowledge of reporting systems (SQL Server Reporting Services, Crystal Reports and/or MicroStrategy).
• Advanced MS Excel.
• Minimum 2 years’ work experience using Power BI.
• Minimum 2 years’ experience with Data warehouse and ETL tools.
• Familiarity with Cloud technologies.
• Familiarity with Artificial Intelligence.
• Technical competencies:

Responsibilities

• Define and validate data elements and data structures; develop subject area models.
• Maintain data architecture artifacts for multiple systems and data lineage charts.
• Collect, process, and perform analyses on metadata; provide actionable insights.
• Define and maintain ETL scripts to load data into data warehouse.

Skills

Data analytics

Data visualization

Education

Bachelor’s degree in computer science or equivalent

Tools

SQL Server

Crystal Reports

MicroStrategy

Power BI

SSIS

Excel

HTML

Job description

LEGAL AID BC

POSTING

TO: LABC STAFF (cc: BCGEU)

FROM: HUMAN RESOURCES DEPARTMENT

POSITION: DATA ANALYST

ONE FULL-TIME TERM POSITION – VANCOUVER

(To October 1, 2029)

COMPETITION NO: B043-26

DATE POSTED: September 15, 2026

CLOSING DATE: September 29, 2026

STARTING DATE: ASAP

SALARY: Job Class 23 ($81,542 - $93,249) *market adjusted

HOURS OF WORK: 35 hours per week, Monday to Friday

This position has the option to participate in a modified work week schedule (37.5 hours/week) Monday to Friday, with the extra hours worked as one earned day off taken once every three-week scheduled cycle.

Legal Aid BC is in the early stages of, and committed to a transformative journey to embedding Truth and Reconciliation, and Equity, Diversity, and Inclusion in all aspects of our work. We seek talent from equity-seeking groups, including but not limited to individuals who self-identify as First Nations, Inuit, or Métis descent, persons with disabilities, gender diverse, racialized, and members of the 2SLGBTQIA+ community be a part of this exciting stage of Legal Aid BC’s growth. We care deeply about the culture we are building and are looking for staff members who not only excel in their respective areas but are also passionate about supporting the people we serve and each other. All interested and eligible applicants will be considered with due consideration to all protected grounds under the BC Human Rights Code. If we can do anything to make your application experience a positive and equitable one, we want to hear from you on what we can do better.

PRIMARY FUNCTION:

This position is pivotal in transforming data into actionable insights through interactive and visual representations. The responsibilities include defining and validating data elements and structures, developing subject area models, and maintaining data architecture across multiple systems. In addition, this role is responsible for producing and maintaining various value-add Business Intelligence reports.

The following job duties are illustrative examples and shall not be construed as an exhaustive description of all the work requirements that may be inherent in the job.

DUTIES:

1. DESIGN, DEVELOP AND MAINTAIN NEW AND EXISTING DATA ASSETS

1. Define and validate data elements and data structures;
2. Develop subject area models.
3. Maintain data architecture artifacts for multiple systems
4. Define and maintain data lineage charts for the organization.
5. Collect, process, and perform analyses on metadata
6. Analyzes data to provide actionable insights and support business decisions.
7. Define and maintain ETL scripts to load data into data warehouse.

2) DELIVER VALUE-ADD BUSINESS INTELLIGENCE REPORTS

1. Work with stakeholders to elicit requirements, and develop functional and technical specifications
2. Design, develop, test and maintain BI solutions, including dashboards and reports, using software lifecycle.
3. Work closely with various team members on multiple concurrent projects.
4. Use advanced analytics, artificial intelligence /machine learning, and statistical methods to extract insights from data.
5. Translate complex data findings into understandable insights for non-technical stakeholders.
6. Use statistical methods and tools to analyze data and identify trends, patterns, and correlations.
7. Gather data from various sources, including databases, spreadsheets, and external sources.
8. Create visualizations, dashboards, and reports to present findings in a clear and actionable manner.
9. Keeping up-to-date with industry trends and best practices in data analysis and visualization.

3) MAINTAIN AND AUGMENT LABC BUSINESS INTELLIGENCE PROGRAM AND, APPLY BUSINESS INTELLIGENCE SOFTWARE:

1. Provide input into and maintenance of the centralized reporting strategy for LABC;
2. Maintain and adjust existing reports as business requirements change;
3. Recommend system changes and identify data integrity issues to improve the quality and availability of data for management decision-making;
4. Use business intelligence tools to design and build reports, develop cubes and dashboards to support business initiatives;
5. Perform testing and document BI solutions.

QUALIFICATIONS:

Basic requirements

1. Bachelor’s degree in computer science or equivalent
2. Minimum three (3) years’ related experience as outlined in rated requirements including strategic initiative project management, process and performance improvement, data analytics and reporting metrics required.
3. Advanced working knowledge of reporting systems (such as SQL Server Reporting Services, Crystal Reports and/or Micro strategy)
4. Advanced level in MS Excel
5. Minimum 2 years’ work experience using Power BI
6. Minimum of 2 years’ experience with Data warehouse and ETL tools
7. Familiarity with Cloud technologies
8. Familiarity with Artificial Intelligence
9. Technical competencies:

• High proficiency with Microsoft Office products required.
• Excellent PowerPoint skills and design capability and high proficiency in Excel and data analysis.
• Proficiency with data visualization software, preferably Power BI as well as HTML skills preferred.
• Ability to apply data governance, data management, privacy and information security measures in various stages of the data lifecycle.
• Fluent in hybrid working environment and leveraging Zoom and Microsoft Teams to collaborate and engage with peers and develop initiatives.

1. OR an equivalent combination of education/experience

Rated requirements

1. Ability to write technical reports using standard writing procedures, techniques, and composition
2. Ability to write to build complex queries and use business intelligence software to create data reports
3. Ability to understand business requirements and apply them to existing and new reporting functions
4. Ability to communicate effectively orally and in writing
5. Ability to research collect, organize, and analyze data, and report on financial and statistical information
6. Ability to present data to users in ways that help users to understand the data, including using visualizations.
7. Ability to interview users and elicit information for business requirements
8. Ability to make sound decisions and demonstrate a high degree of trustworthiness in handling confidential and sensitive information.
9. Ability to strategically maintain financial/budgetary information.
10. Ability to prioritize and manage time effectively.
11. Experience working with labour market data, census data, demographic data and other related industry data.
12. Ability to apply data governance, data management, privacy and information security measures in various stages of the data lifecycle.
13. Ability to interpret, translate and visualize data and complex concepts into concise and engaging messaging, to inform business decisions.
14. Proven track record of defining new data collection and analysis processes to increase efficiencies or effectiveness of reporting.
15. Demonstrate a high degree of critical thinking, identifying patterns, trends or abnormalities.
16. Demonstrated commitment to respectful, inclusive, and ethical use of data, including openness to learning about Truth and Reconciliation, anti-racism, accessibility, and equity considerations in data analysis and reporting.
17. Experience or training in demographic data analysis, GBA Plus, Indigenous data governance or data sovereignty, privacy, and equity-informed reporting is considered an asset.
18. Understanding of current issues affecting Indigenous communities.
19. Proven track record with strong written and oral communication, analytical skills, presentation and project management skills; high level of attention to detail and accuracy; ability to routinely manage and integrate large data sets, required.
20. Strong interpersonal skills, self-motivated, and a demonstrated ability to multi-task and work independently while collaborating effectively at all levels of the organization.
21. Strong problem solving and exceptional client services both internal and external skills.
22. Excellent organizational and problem-solving skills, always looking for efficiencies and embedding continuous improvement throughout the work.
23. Proven ability to synthesize analyses from qualitative and quantitative data sets and design and generate impactful reports.
24. Genuine commitment to LABC’s mandate.
25. Working experience with Micro strategy and SSIS is an asset
26. Experience with MS SQL Server is an asset
27. Experience in Dimensional modelling is an asset
28. Knowledge of LABC policies and procedures an asset
29. Excellent organizational skills
30. Team player

We offer (based on your employment status and affiliation):

• Four weeks paid vacation to start that grows the longer you are with LABC
• An excellent employee benefits package, where premiums are 100% paid by LABC
• A generous defined benefit pension plan
• Support for training and development
• An Employee and Family Assistance program
• The opportunity to participate in various Employee programs (Employee Wellness, etc.)
• Support for a healthy work/life balance
• Generous leave provisions (sick time, special leaves)
• 13 paid statutory holidays
• An opportunity for a flexible hybrid work arrangement for some positions (LABC reserves the right to change this policy at any time)
• Transit friendly employer for eligible staff to have their commute subsidized
• Dog-friendly offices
• Dedicated Cultural Leave provisions for Indigenous employees
• An Equity, Diversity and Inclusion Council, and Indigenous employees Council and Accessibility Committee of employees from equity-seeking groups that advises on ongoing improvements and investments in Equity, Diversity and Inclusion at our workplace

VISIT OUR WEBSITE AT www.legalaid.bc.ca

Legal Aid BC is recognized as one of BC’s Top 100 Employers:

https://reviews.canadastop100.com/top-employer-legal-aid-bc

We would like to thank all external applicants for their interest but regret that only those shortlisted will be contacted.