Senior Business Intelligence Engineer

ORGANIZATION:      Pathways to Education Canada
Senior BI Engineer
Director, Business Intelligence
LOCATION:               Toronto, ON or Montreal, QC (Hybrid workplace)


Senior Business Intelligence Engineer, Pathways to Education Canada

We’re looking for someone who can change the paradigm for Canadian youth living in poverty. Someone who enjoys building partnerships, making an impact, and working with energetic, high-performing teams. Is that you?

Pathways to Education is a national, charitable organization breaking the cycle of poverty through education. Its award-winning program is creating positive social change by supporting youth living in low-income communities to overcome barriers to education, graduate from high school, and build the foundation for a successful future. Through the collective power of partnerships, Pathways to Education’s innovative program is preparing youth for tomorrow.


The Opportunity

As a member of the Business Intelligence (BI) team within the Finance and Operations department, you will play a key role in developing the organization’s BI infrastructure to execute on its data strategy. By collaborating with a variety of business stakeholders to identify their business needs, you will design data models, BI assets, dashboards, and reports to contribute to data-driven decision-making for Pathways Canada.

As the successful candidate, you are passionate about data and how it can be leveraged by organizations to empower their analytics. You have strong technical skills and a customer service focus to support non-technical business users in understanding the root of their requirements and developing BI solutions that fully meet their needs. You bring exceptional problem-solving skills and want to make an impact in a small team in support of young people across Canada.


What You’ll Do

  • Collaborate with business and IT teams to design dimensional models that represent business processes.
  • Design and build data models, views, BI semantic layers, and BI assets for governed reporting and self-service data discovery and analytics.
  • Engage in workshops with various business stakeholders to understand underlying business requirements for new reporting and analytics use cases, and develop dashboards and reports that fully meet their needs.
  • Conduct source data analysis and profiling to complete source-to-target mapping.
  • Develop, implement, and monitor data pipelines to maintain a high level of service and data quality.
  • Support the development and implementation of a data quality monitoring framework with departmental data owners and stewards.
  • Supervising of staff in maintaining data governance documentation.
  • Strategic planning of BI infrastructure, including budget analysis, identification of technical requirements, and providing business case recommendations.


What You Bring

  • A minimum of 5 years’ in-depth business reporting and analytics experience.
  • Post-secondary education or training in Engineering, or Computer Science is an asset.
  • Deep understanding of data structures and schemas.
  • Extensive experience and skills in Business Intelligence, Data Architecture, and cloud-based technologies (especially within the Azure technology stack).
  • Advanced knowledge of Power BI functionalities, administration, design, and implementation.
  • Advanced working knowledge of SQL and DAX scripting.
  • Experience working in an Agile environment (developing stories, prioritizing tasks, and backlog grooming).
  • Quick to understand business needs and learn domain-specific knowledge.
  • Excellent communication skills.


What We Offer

  • An exciting opportunity to be part of a leading not-for-profit dedicated to excellence and impact.
  • A collaborative work environment with a culture of innovation.
  • Opportunities for learning and professional development.
  • Competitive salary.
  • Generous vacation and health benefits package.
  • Group RRSP program.


To confidentially explore this opportunity, please submit a cover letter and resume with the subject line ‘Senior BI Engineer’ to [email protected]. Applications will be accepted until the position is filled. Pathways Canada thanks all applicants for their interest. Due to volume, only those who qualify for an interview will be contacted.

Pathways to Education Canada is committed to fostering a diverse work environment, one that is inclusive of different races, ethnic origin, citizenship, gender identity, gender expression, sexual orientation, ages, family status, disability status, and intersectional identities. All interested candidates are encouraged to apply and advise us of any accommodations or supports needed to ensure fair and equitable access throughout the recruitment and selection process.

Pathways is committed to ensuring the health and safety of its staff, visitors, and community partners. Accordingly, to be considered for employment with Pathways, candidates must be fully vaccinated against COVID-19, in accordance with provincial guidelines, and provide proof of such vaccination at any time during the recruitment process as required by Pathways, subject to accommodations necessary pursuant to the Quebec Charter of Human Rights and Freedoms, the Human Rights Code, and the Accessibility for Ontarians with Disabilities Act. Pathways will comply with all applicable privacy legislation.