Business Analyst

Kaizen Lab Inc.; Edmonton; On-site; CAD 41,000 - 55,000; Part time

Job summary

Robertson is the School of New Work in Edmonton. We are seeking a Business Analyst on a two-month contract, 15 hours per week, to partner with Admissions and Marketing to drive data-informed decisions.

You will extract and clean data from Salesforce and D2L Brightspace, build data pipelines and dashboards, and deliver KPI reports for enrollment, retention and academic success, with cross-department support.

Qualifications

• Degree or diploma in Data Analytics or related discipline.
• 2+ years in a data analysis role, preferably education/tech.
• Adult Education Certificate is an asset.
• Proficiency in SQL for data extraction and manipulation.
• Experience with data visualization tools (Tableau/Power BI).
• Familiarity with data from Salesforce and D2L Brightspace.
• Strong Excel/Google Sheets data cleaning skills.
• Excellent problem-solving and communication skills.
• Ability to present data to non-technical audiences.

Responsibilities

• Extract, clean and integrate datasets from Salesforce and D2L Brightspace.
• Build data pipelines, interactive dashboards and reports for decision-making.
• Develop KPI-focused dashboards for enrollment, retention and academic success.
• Prepare validated data packages for accreditation and partnerships.
• Provide analytics support to Admissions, Finance and Marketing.

Skills

Data analysis

SQL

Communication

Problem solving

Presentation

Attention to detail

Independent work

Collaboration

Education

Bachelor's/ Diploma in Data Analytics or related

Adult Education Certificate asset

Tools

Tableau

Power BI

Salesforce

D2L Brightspace

Excel/Google Sheets

Job description

Who are we?

Robertson is the School of New Work. Our vision is for everyone to have a good life through a prosperous and fulfilling career. Our mission is to empower our learners with the most relevant training and up-to-date industry insights so that they may find fulfilling and meaningful careers.

We are in search of a Business Analyst to join our team on a two month contract, 15 hours/week.

Reporting to the Vice President of Admissions and Marketing, the Business Analyst will serve as a key analytical partner responsible for driving data-informed decision-making across the institution.

This role focuses on extracting, cleaning and integrating complex datasets from the College’s core platforms- specifically Salesforce and D2L Brightspace, to build robust data pipelines, interactive dashboards, and actionable reports.

Key Deliverables:

1. Integrated Data Asset & Pipeline Architecture:

• Combined, cleaned dataset merging Salesforce student CRM data with D2L Brightspace learning engagement and grade metrics.

• Documented data transformation processes (queries, scripts, and mapping rules) ensuring ongoing data integrity and consistency.

2. Strategic Dashboards & Executive KPI Reporting

• Interactive visualization dashboard tracking core institutional KPIs, including enrollment trends, student retention rates, and academic success indicators.

• Comprehensive report suite detailing key patterns and anomalies in student outcomes to inform leadership decision-making.

3. Accreditation & Partnership Compliance Reports

• Fully validated, submission-ready data packages tailored to specific external accreditation standards and institutional partnership agreements.

4. Departmental Analytics Support (Admissions, Finance, Marketing)

• Custom ad-hoc reporting solutions and analytics models addressing specific cross-departmental business questions and operational needs.

5. Operational & Interdepartmental Collateral

• Remote analytical support materials, event coordination data, and active contribution artifacts for division/program activities and cross-functional teams (Finance, Operations, Workforce)

Qualifications

• A degree or diploma in Data Analytics or a related discipline (such as Data Science, Statistics).

• 2+ years of experience in a data analysis role, preferably within an educational or technology-focused environment.

• Adult Education Certificate is an asset.

• Proficiency in SQL for data extraction and manipulation.

• Experience with data visualization tools (e.g., Tableau, Power BI).

• Familiarity with data from educational platforms like Salesforce, and D2L Brightspace.

• Strong skills in Microsoft Excel and/or Google Sheets for data cleaning and analysis.

• Excellent problem-solving and critical thinking skills.

• Strong communication and customer service skills.

• Strong presentation skills, with the ability to explain complex data concepts to non-technical audiences.

• A keen eye for detail and a commitment to data accuracy.

• Ability to work both independently and collaboratively in a fast-paced environment.

• Ability to work in a diverse, inclusive environment.

• A clear criminal records check and child abuse registry check.