Business Intelligence Developer

Society for the Prevention of Cruelty to Animals shelters; Vancouver; Hybrid; CAD 75,000 - 100,000; Full time

Job summary

The BC SPCA is seeking a Business Intelligence Developer for a temporary full-time role responsible for automating reports and developing KPI dashboards. The ideal candidate will have a degree in Computer Information Technology and extensive experience in data analytics and reporting solutions. Join a dynamic team dedicated to making a difference in animal welfare with a commitment to diversity and inclusion.

Qualifications

• Minimum of 8 years’ experience in a Data analytics or Business Intelligence role.
• Experience generating reporting solutions and working with data models.
• Advanced knowledge of Microsoft Office and Microsoft BI Stack.

Responsibilities

• Automate organizational reports and create departmental KPIs/KRIs dashboards.
• Gather business requirements from key stakeholders for approval.
• Perform QA testing to ensure accuracy of reports and dashboards.

Skills

Data Analytics

Business Intelligence

Problem Solving

Analytical Thinking

Communication

Education

Degree in Computer Information Technology

Tools

Power BI

SQL

Microsoft Azure

Job description

Job Description

Posted Wednesday, June 25, 2025 at 10:00 AM | Expires Thursday, January 1, 2026 at 10:59 AM

If you are up for the challenge and would like to be considered for this position, we would like to hear from you. The British Columbia Society for the Prevention of Cruelty to Animals (BC SPCA) is looking to fill the following career opportunity:

POSITION : Business Intelligence Developer

STATUS : Full-time, Temporary ( 18 months mat leave coverage with a possibility of extension or transition to a permanent full time role)

SHIFT: 35 hours per week- hybrid with 3 days from the office

CLASSIFICATION: Exempt

We welcome diversity, value differences, and foster inclusion in our employment practices.Find out more about our commitment to diversity and inclusion by reading our Foundational Principles on our website. We invite applications from all qualified individuals who are philosophically aligned with our mission, vision and values .

The BC SPCA is a dynamic organization with facilities and services across the province of BC. Join an expanding team in an exciting time of change in an organization that makes a difference! Please read below for additional details and let us know if you have the skills and experience we are looking for by submitting your application.

About the position:

Providing exceptional service the Business Intelligence Developer is responsible to automate organizational reports and create departmental Key Performance Indicators (KPIs)/ Key Risk Indicators (KRIs) dashboards. The Developer will work closely with key internal stakeholders to understand requirements and transform those requirements into dashboards and reports. Work will be done in environments including, but not limited to Microsoft 365, Microsoft Power Platform, SQL, and Microsoft Azure. Other responsibilities include discovering and documenting data sources and maintaining or enhancing data reporting as required.

Please read below for additional details and let us know if you have the skills and experience we are looking for by submitting your application.

The duties and responsibilities of this role include:

• Gather business requirements from key stakeholders and present recommendations for approval.
• Create reports and dashboards based on stakeholder requirements.
• Perform QA testing to assure reports and dashboards are accurate.
• Design and document an appropriate Microsoft data platform solution based on the defined information architecture, and functional and non-functional requirements of the stakeholders.
• Provide technical expertise regarding the unique features and constraints of Power BI and related technologies.
• Provide best practice recommendations relating to deployments and usage.
• Analyze issues, recommend viable solutions, and implement based on organizational change and release strategy.
• Troubleshoot performance problems and conduct root cause analysis on performance tuning.
• Catalogue all existing reporting and analysis in use across the organization.
• Develop and maintain operational reporting, dashboards and scorecards that track organization key metrics. Assist the staff in obtaining the full benefit of these tools.
• Lead projects to implement reporting solutions in accordance with BC SPCA project and change management frameworks.
• Collaborate with the Training & Development Specialist to develop and/or deliver tools, resources, and training, as needed.
• Support users as needed.

The ideal candidate will have:

• Degree in Computer Information Technology or related program plus minimum of 8 years’ experience in a Data analytics or Business Intelligence role or an equivalent combination of education and experience acceptable to the employer.
• Excellent listening and questioning skills, combined with the ability to interact with a diverse group of staff in a respectful manner, determine problems and apply appropriate solutions.
• Experience generating reporting solutions
• Experience with tabular data models within Power BI
• Experience with Microsoft tools such as SQL and Azure
• Excellent analytical thinking demonstrated by translating data into informative visual reports dashboards, and KPI scorecards in Power BI
• Continuous improvement such as Six sigma would be an asset
• Solid knowledge extracting data from various large relational databases with SQL queries and OLAP cubes.
• Experience working with conceptual, logical, and physical data models, data flows and databases.
• Ability to work as part of a team and independently
• Ability to organize, set priorities, complete tasks, and meet deadlines with minimal supervision while maintaining attention to detail and accuracy
• Strong written and oral communication skills; ability to relate respectfully to a group of diverse stakeholders.
• Strong problem-solving skills.
• Ability to translate business requirements into technical solutions and communicate back to the business using non-technical language.
• Advanced knowledge of Microsoft Office and Microsoft BI Stack.
• Philosophical harmony with the vision, mission, and strategic direction of the organization.

How to apply:

If you are interested in joining our team and are legally entitled to work in Canada, we would like to hear from you. Click on apply now or use the link to apply https://spca.bc.ca/about-us/careers/

We thank you for your interest in the BC SPCA, however; only candidates selected for an interview will be contacted. No telephone calls, please.

The BC SPCA is a Registered Charity BN 11881 9036 RR0001