Business Analyst

Robertson College; Edmonton; On-site; CAD 39,000 - 52,000; Part time

Job summary

Robertson College is seeking a Business Analyst for a two-month contract (15 hours/week) to drive data-informed decisions. You will merge Salesforce and D2L Brightspace data, create dashboards, and deliver KPI reports to leadership.

You will support Admissions, Finance, and Marketing with cross-departmental analytics, ensuring data quality and actionable insights in a fast-paced educational environment.

Qualifications

• Degree or diploma in Data Analytics or related field.
• 2+ years in a data analysis role, preferably education/tech.
• Proficiency in SQL for data extraction and manipulation.
• Experience with data visualization tools (Tableau, Power BI).
• Familiarity with data from Salesforce and D2L Brightspace.

Responsibilities

• Extract, clean, and integrate datasets from Salesforce and D2L Brightspace.
• Build interactive dashboards and reports to track KPIs.
• Deliver accreditation and partnership data packages.
• Provide ad-hoc analytics support for Admissions, Finance, and Marketing.

Skills

Data analysis

Problem solving

Communication

Presentation

Independent work

Team collaboration

Education

Bachelor's degree in Data Analytics or related

Tools

SQL

Tableau

Power BI

Excel

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.