Business Analyst

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: 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. 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. Accreditation & Partnership Compliance Reports Fully validated, submission-ready data packages tailored to specific external accreditation standards and institutional partnership agreements. Departmental Analytics Support (Admissions, Finance, Marketing) Custom ad-hoc reporting solutions and analytics models addressing specific cross-departmental business questions and operational needs. 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.

The Business Analyst will extract and integrate complex datasets from Salesforce and D2L Brightspace to build data pipelines and interactive dashboards. They will provide strategic KPI reporting and analytical support to the Admissions, Finance, and Marketing departments.

Candidates need a degree or diploma in Data Analytics or a related field and at least 2 years of experience in data analysis. Proficiency in SQL, data visualization tools, and educational platforms is required.

• Data visualizationPreferred
• Power BIPreferred
• SQLPreferred
• TableauPreferred
• Problem solvingPreferred
• Data analysisPreferred
• Microsoft ExcelPreferred
• CommunicationPreferred
• Critical ThinkingPreferred
• SalesforcePreferred

Identified from the job description. Confirm important requirements above.

• SQL
• Data Visualization
• Tableau
• Power BI
• Microsoft Excel
• Google Sheets
• Data Cleaning
• Data Integration
• Salesforce
• D2L Brightspace
• KPI Reporting
• Problem Solving
• Critical Thinking
• Communication
• Presentation Skills
• Data Analysis

• Data & Analytics
• Education
• Technology
• Marketing
• Finance & Accounting

Minimum education

Professional degree

Minimum experience

2+ years

Apply by

Oct 5, 2026

Posting language

English

Working hours

15 hours per week

Seniority

Entry level