Business Intelligence (BI) Developer

Chartered Professional Accountants of British Columbia; Vancouver; On-site; CAD 66,000 - 79,000; Full time

Job summary

A professional accounting association is seeking a detail-oriented Business Intelligence (BI) Developer to support data-driven initiatives in Vancouver. The role involves data modeling, reporting, and ensuring data quality. Ideal candidates will have a post-secondary degree and expertise in BI tools, particularly MS Power BI. The position offers a starting salary between $66,550 and $79,000 annually, plus a competitive compensation package.

Benefits

Competitive compensation package

Collaborative work environment

Qualifications

• Two to four years of experience in Business and/or Data Analysis.
• Previous experience with MS Power BI required.
• Strong knowledge of reporting packages like Microsoft, Business Objects.

Responsibilities

• Prepare, clean, and transform data for analysis.
• Create dashboards, reports, and visualizations.
• Assist in gathering and documenting business data and analytics requirements.

Skills

Data Modeling

Data Analysis

Reporting

Problem-solving

Communication

Education

Post-secondary degree in Computer Science, Mathematics, Economics, Statistics, or equivalent

Tools

MS Power BI

MS SQL Server

Job description

Position: Business Intelligence (BI) Developer

Reports To: Director, Analytics

Contract Type: Indefinite, Full Time

The Chartered Professional Accountants of British Columbia (CPABC) is seeking a detail oriented, collaborative and results-driven individual for the position of Business Intelligence (BI) Developer. We are proud and honoured to have been recognized as one of BC’s Top Employers for a sixth consecutive year in 2025. Come join a collaborative network of like-minded professionals and take the first step towards an exciting opportunity by applying to the position.

Job Summary

The Business Intelligence (BI) Developer supports the organization’s data-driven initiatives by assisting in the collection, preparation, and presentation of business data. This role is primarily responsible for organizing and transforming data into meaningful insights through the development of basic data models, reports, and dashboards. The BI Developer helps maintain data quality, supports existing solutions, and ensures consistency in data documentation.

Key Responsibilities:

Data Modeling & Reporting

• Prepare, clean, and transform data using established data management practices, to ensure accuracy and readiness for analysis.
• Support the development of basic data models and structures.
• Create and enhance dashboards, reports, and visualizations using business intelligence tools.
• Document data sources, definitions, and reporting processes, and help maintain data dictionaries and metadata to promote knowledge sharing, clarity and consistency.
• Provide information and clarity on data analytics requirements, processes and best practices;
• Perform data quality checks to identify missing or inconsistent values, following up with stakeholders where appropriate and escalating issues as required.
• Provide ongoing support and improvements of existing data models and analytical solutions.

Business Analysis & Requirements Support

• Assist in gathering and documenting business data and analytics requirements;
• Support the definition of projects and deliverables based on business requirements;
• Design, develop and customize reports and dashboards to support business decision-making;
• Apply data analysis techniques to identify trends, and patterns, to support decision-making.

And other duties and responsibilities, as assigned from time to time.

Key Requirements:

Knowledge and Experience

• Post-secondary degree in Computer Science, Mathematics, Economics, Statistics, or equivalent education and experience;
• Two (2) to four (4) years of experience in Business and/or Data Analysis, Data Modeling, Data Warehousing or Business Intelligence;
• Previous experience with MS Power BI required;
• Prior experience with various AGILE development methodologies (e.g. SCRUM, Kanban, etc.);
• Strong knowledge of and experience with reporting packages (e.g. Microsoft, Business Objects, etc.);
• Experience with MS SQL Server (SSIS, SSAS, SSRS) required;
• Proven proficiency with one or more programming languages (e.g. Java, C++, Python, etc.);

Demonstrated Skills and Abilities

• Excellent interpersonal, communication and presentation skills, both verbally and written;
• Ability to work collaboratively as a key member of a team and independently with minimum supervision;
• Meticulous attention to detail, refined organizational and time management skills and the ability to manage overlapping tasks;
• Advanced analytical skills with the ability to deal with sensitive and complex information;
• Proven ability to prioritize competing requirements and deadlines under pressure.

The starting annual salary for this position is between $66,550.00 and 79,000.00 per annum, based on candidates’ qualifications, experience, and internal parity. Exceptions may be considered with further review.

If this job outline describes you, we encourage you to apply through our online Careers Portal. We thank all candidates who respond; however, only those selected for an interview will be contacted.

Why join our team? CPABC offers an entrepreneurial environment with a competitive compensation package. At CPABC we live our core values:

• We Are Open
• We Work Together
• We Communicate
• We Improve Every Day
• We Are Professional
• We Laugh and Celebrate

About CPABC

The Chartered Professional Accountants of British Columbia (CPABC) is the training, governing, and regulatory body for over 40,000 CPA members and 6,000 CPA students and candidates. CPABC carries out its primary mission to protect the public by enforcing the highest professional and ethical standards and contributing to the advancement of public policy. CPAs are recognized internationally for bringing superior financial expertise, strategic thinking, business insight, and leadership to organizations. CPABC is proud to have been presented with a sixth consecutive BC Top Employer award in 2025.