Data Analyst

Legal Aid BC; Vancouver; On-site; CAD 82,000 - 93,000; Full time

Benefits offered by this job

Four weeks paid vacation

Comprehensive benefits package

Training and development support

Employee & Family Assistance program

Flexible hybrid work arrangement

Transit-friendly employer

Job summary

Legal Aid BC is seeking an IT Data Analyst in Vancouver to turn data into actionable insights across multiple systems. Responsibilities include defining data elements, building models, and sustaining data architecture while delivering BI reports and dashboards.

You bring at least 3 years in data analytics with SSRS, Crystal Reports, MicroStrategy, and strong Excel/Power BI skills. A hybrid, impact-driven role supports Truth and Reconciliation and inclusive values.

Qualifications

• Bachelor’s degree in Computer Science or equivalent.
• Minimum three years’ experience in data analytics, reporting and data management.
• Advanced reporting: SSRS, Crystal Reports, MicroStrategy.
• Advanced MS Excel skills and data visualization capability.
• Experience with Power BI, data warehouses and ETL tools.
• Familiarity with cloud technologies and AI concepts.

Responsibilities

• Define and validate data elements and structures.
• Develop subject area models and maintain data architecture across systems.
• Produce and maintain BI reports and dashboards.
• Elicit requirements and write functional/technical specs.
• Design, develop, test and maintain BI solutions end-to-end.
• Collaborate across teams on multiple projects.
• Support centralized reporting strategy and adapt reports as needed.
• Identify data quality issues and suggest improvements.

Skills

Data analytics

Power BI

SQL SSRS

Crystal Reports

MicroStrategy

ETL

Data warehouse

Excel

HTML

Data governance

Privacy & security

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Power BI

Job description

Status: Full-Time Term – until October 1, 2029

Affiliation: BC General Employees Union (BCGEU)

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

Competition #: B043-26

Application Deadline: September 29, 2026

VALUES STATEMENT:

Our commitment to the principles of fundamental justice embedded in the Charter of Rights and Freedoms, and to Truth and Reconciliation, and Equity, Diversity, and Inclusion is ambitious and foundational. It informs everything we do, as we defend liberty, equality, autonomy, and dignity; as we dismantle colonization, racism, sexism, ableism, transphobia and homophobia, and all discrimination. These are our values, and they inform our hiring practices too. Our business is aiding people in severe legal distress and necessitates internal and external alignment of practicing these values. Integrating Truth and Reconciliation, and Equity, Diversity, and Inclusion throughout every aspect of Legal Aid BC is critical to building that culture, and we prioritize ongoing resources to achieve that goal.

The Opportunity

As an IT Data Analyst, your primary function is to play a pivotal role 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.

Key accountabilities include, but aren't limited to:

• Define and validate data elements and data structures;
• Develop subject area models.
• Maintain data architecture artifacts for multiple systems
• Work with stakeholders to elicit requirements, and develop functional and technical specifications
• Design, develop, test and maintain BI solutions, including dashboards and reports, using software life cycle.
• Work closely with various team members on multiple concurrent projects.
• Provide input into and maintenance of the centralized reporting strategy for LABC;
• Maintain and adjust existing reports as business requirements change;
• Recommend system changes and identify data integrity issues to improve the quality and availability of data for management decision-making;

Who We Are

Legal Aid BC (LABC) is a non-profit organization established by the Legal Services Society Act in 1979. Our mission is to provide legal information, advice, and representation services to BC's most vulnerable and marginalized citizens who lack the necessary resources to effectively access the justice system when their families, freedom, or safety are at risk. Our vision is to see BC’s legal system transformed, by the way LABC represents our clients, into one more equitable and inclusive with a mission to strengthen client-centred legal help for British Columbians experiencing barriers accessing the legal system.

At LABC, we know that our continued ability to help the people who need us is due to the hardworking individuals who make up our team, dedicated to making a difference in the lives of people in need. We foster a positive culture of open communication for our team to thrive within, underpinned by our values of client focus, advancing Truth and Reconciliation, and Equity, Diversity and Inclusion, and change through leadership.

Legal Aid BC is in the early stages of, and committed to a transformative journey of 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 Metis descent, persons with diverse abilities, 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. If this resonates with you, we encourage you to apply. 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.

To understand why legal aid matters, and our commitments to Truth and Reconciliation, and Equity, Diversity and Inclusion, please explore our website, planning and guiding documents at https://legalaid.bc.ca/.

The Ideal Candidate

You have:

• Bachelor’s degree in Computer Science or equivalent
• 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.
• Advanced working knowledge of reporting systems (such as SQL Server Reporting Services, Crystal Reports and/or Micro strategy)
• Advanced level in MS Excel
• Minimum 2 years’ work experience using Power BI
• Minimum of 2 years’ experience with Data warehouse and ETL toolsFamiliarity with Cloud technologies
• Familiarity with Artificial Intelligence
• 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.
• OR an equivalent combination of education/experience

We Offer

A competitive annual salary, as well as a comprehensive benefits package (based on your employment status and affiliation including:

• 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
• 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

For additional information regarding our extensive benefits package, please explore our careers page at: https://legalaid.bc.ca/about/careers/why-work-here.

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

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