Top Benefits
About the role
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
LOCATION: Provincial Office - Vancouver, BC
CLASSIFICATION: Exempt
WAGE: Salaried
CLOSING DATE: Open Until Filled
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.
- Create appropriate datasets.
- 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
About BC SPCA
The BC SPCA is the only animal welfare organization in B.C. with the authority to enforce animal cruelty laws under the Prevention of Cruelty to Animals Act (PCA Act). We are the largest animal welfare organization of our kind in North America and the largest animal sheltering society in the world. We have 44 locations across B.C. including:
36 branches which care for abused and homeless animals, until they are adopted into new homes (including two facilities with large animal barns)
Three animal hospitals (Vancouver, Burnaby and Penticton)
Two spay/neuter clinics (Kamloops and Prince George)
Wild ARC, our wildlife rehabilitation centre in Metchosin
A provincial call centre in Victoria
Our provincial office in Vancouver, which oversees animal cruelty investigations, advocacy and education for youth and adults and other key activities across B.C.
We assist more than 97,109 animals in need every year and are funded by compassionate animal lovers who support our work and partner with us to protect and enhance the quality of life for domestic, farm and wild animals in B.C. See more stats at a glance.
We are committed to achieving the highest standards of transparency and accountability in all our activities. In order to maintain these high standards of accountability and to foster public confidence in the work of our organization, we undertake to provide the public with information on our governance, operations and financial position.
Top Benefits
About the role
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
LOCATION: Provincial Office - Vancouver, BC
CLASSIFICATION: Exempt
WAGE: Salaried
CLOSING DATE: Open Until Filled
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.
- Create appropriate datasets.
- 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
About BC SPCA
The BC SPCA is the only animal welfare organization in B.C. with the authority to enforce animal cruelty laws under the Prevention of Cruelty to Animals Act (PCA Act). We are the largest animal welfare organization of our kind in North America and the largest animal sheltering society in the world. We have 44 locations across B.C. including:
36 branches which care for abused and homeless animals, until they are adopted into new homes (including two facilities with large animal barns)
Three animal hospitals (Vancouver, Burnaby and Penticton)
Two spay/neuter clinics (Kamloops and Prince George)
Wild ARC, our wildlife rehabilitation centre in Metchosin
A provincial call centre in Victoria
Our provincial office in Vancouver, which oversees animal cruelty investigations, advocacy and education for youth and adults and other key activities across B.C.
We assist more than 97,109 animals in need every year and are funded by compassionate animal lovers who support our work and partner with us to protect and enhance the quality of life for domestic, farm and wild animals in B.C. See more stats at a glance.
We are committed to achieving the highest standards of transparency and accountability in all our activities. In order to maintain these high standards of accountability and to foster public confidence in the work of our organization, we undertake to provide the public with information on our governance, operations and financial position.