Plan International Analyst, Business Intelligence

Job Description

What can you expect from joining a leading organization in the global movement to advance children’s rights and equality for girls?

We are one of Canada’s Most Admired Cultures and here’s why: together, we have created a climate of trust and inclusivity – where diversity in people, ideas and approaches is not only respected, it’s encouraged.

Amidst the uncertainty of COVID-19, these qualities have come to the forefront as our organization evolves to remain agile. Though we will evolve in many respects, our mission and strategic ambition will not change – and our work has never been so imperative. We will never stop believing in the multiplying power of girls and that every child deserves that right to learn, lead, decide and thrive. Our future success will be founded upon Plan International Canada’s 80+ year history of focusing on our mission, our core values, responding to challenges and seizing opportunities with purpose, relevance and impact.

Further information can be found at: https://plancanada.ca/careers

Summary

Organization:	Plan International Canada
Reports to:	Senior Manager, Insights and Analytics - Programs & Operations
Location:	Toronto (Mount Pleasant and Eglinton)
Status:	Full-time, Permanent
Contact level:	B
Grade:	7

The Position

Report Delivery

Develop management and operational reports, design campaign analysis and modify existing reports for business decision making.
Leverage business intelligence (BI) skills and database knowledge to deliver high quality reporting.
Collaborate and work with business partners to bridge technical and business knowledge.
Facilitate iterative reporting requirements and design.
Prepare and maintain appropriate documentation.

Data Warehouse Maintenance and Architecture

- Design and develop database models, ETL engines and OLAP cubes using BI technologies and concepts.
- Understand current architecture and configure a scalable and robust environment for future needs.
- Configure current environment to improve efficiency and automate routine task times.
- Coordinate or perform database administration and data warehouse refresh.
- Troubleshoot issues to resolution.
Advertisement

Projects and Processes

Create data solutions to support business requirements for targeted initiatives and analytics.
Validate data quality and accuracy and apply tracking codes for meaningful campaign analysis.
Automate operational process changes ensuring end to end testing from an information management perspective using defined project management approach.
Conduct specific training as required.
Provide end user support and documentation.

What success looks like?

Thriving in a fast paced, dynamic environment
Ability to develop a customer service culture within the team and ensuring the team is well equipped for success
Demonstrating an action-oriented approach to application support, enterprise data and business intelligence
Ability to work with business partners to transform ambiguous requests into clear and concise reporting requirements
A very high level of attention to detail, ensuring that reports and extracts meet the highest possible standards of accuracy

As our ideal candidate you will have:

Experience and skills with SQL, and some level of skill with Power BI (or similar data visualization tool); skill or experience with Python is not required but would be a very strong asset
Demonstrated experience with economic and financial principles to perform financial and revenue prediction modelling, including the use of controls and best practices to reduce risk of errors
Demonstrated experience conducting data analyses, synthesizing information from multiple sources, and making evidence-based recommendations
Strong technical knowledge of query tools, analysis and report delivery systems
Highly familiar with multi-dimensional structures, modeling, design, and technologies
Excellent analytical and troubleshooting skills
Previous experience with Great Plains, Snowflake, and/or Salesforce would be a strong asset
Previous experience with non-profit financial reporting would be a strong asset
Ability to manage multiple activities and prioritize according to importance and impact, including managing stakeholder expectations
Personal values consistent with those of Plan International’s organizational values

How to Apply:

To express interest in this exciting opportunity at Plan International Canada, please apply with your resume and cover letter to https://plancanada.ca/apply by March 5, 2023.

Plan International Canada is a hybrid workplace. You will work from the office and from home.

Plan International Canada hires based on merit and is strongly committed to equity and diversity within its community and to providing an inclusive workplace. Plan International Canada especially welcomes applications from Indigenous persons, persons with disabilities, visible minorities, women, persons of all sexual orientations and genders, and others with the skills and knowledge to productively engage with diverse communities.

If you have a disability that may affect your ability to perform in a role in which you are interested, we will be happy to discuss with you what adjustments or arrangements we can make to accommodate your needs. If your disability is likely to affect you adversely within the application process itself, please let us know (as soon as you feel comfortable to do so) by emailing gethired@plancanada.ca so that we can consider any adjustments to the process that will allow you to be considered fairly for the role.

Consistent with our Safeguarding Children and Young People Policy the successful candidate must receive clearance by a police background check, including the vulnerable sector screen.

Applicants must be eligible to work in Canada for the duration of the work term. Proof of eligibility will be required.

Thank you for your interest in a career at Plan International Canada!

This job is no longer available.

View on Organization Website

Similar Jobs