The Data & Reporting Project Assistant will support accessibility-related data management, reporting, and dashboard development within the Accessibility at Western portfolio, assisting with the following duties:
Data Management & Quality Assurance
- Assist with the collection, organization, cleaning, and maintenance of accessibility-related projects, participation, and service-usage data.
- Review and improve existing Excel-based tracking systems, including the master accessibility project tracker.
- Standardize data structures, definitions, and reporting practices to improve consistency, accuracy, and usability across projects.
- Identify data gaps, inconsistencies, and opportunities to streamline data collection and reporting processes.
Dashboard Development & Data Visualization
- Develop and maintain a Power BI dashboard to track accessibility projects, institutional progress, participation, and service usage.
- Create accessible, user-friendly dashboards, charts, and visual summaries to communicate key information to institutional partners.
- Explore opportunities to develop a future public-facing accessibility dashboard for integration into Western's accessibility website.
- Apply accessible data visualization practices, including appropriate colour contrast, clear labels, and alternative formats.
Data Analysis & Reporting
- Analyze quantitative and qualitative data to identify trends, gaps, and opportunities for improvement.
- Support the development of reporting indicators and performance measures to track institutional accessibility initiatives.
- Prepare data summaries and visualizations to support committee reporting, Western's Annual Accessibility Status Report, and Multi-Year Accessibility Plan.
Documentation & Process Improvement
- Document data structures, workflows, and procedures for maintaining datasets and updating dashboards.
- Develop standardized templates and processes to support consistent, sustainable data collection and reporting.
- Maintain organized datasets and supporting documentation in SharePoint, Teams, and other approved platforms.
- Participate in regular check-ins with the Project Manager, Accessibility.
Equity-Informed Perspective
- Apply accessibility-informed, equity-informed, and student-centred perspectives to data collection, analysis, and reporting.
- Consider how data collection and reporting practices may reflect diverse access needs and disability experiences.
- Support responsible data practices, including confidentiality, privacy, and appropriate interpretation of sensitive information.
Education
- Currently enrolled in, or recently completed, a Bachelor's degree (or higher).
- Preference may be given to students in data analytics, computer science, statistics, mathematics, business analytics, information systems, social sciences, or related fields, though all disciplines are welcome.
Experience
- Experience in data management, analysis, reporting, dashboard development, research, or a related area is preferred.
- Experience independently managing assigned work, meeting deadlines, and producing complete, professional deliverables is an asset.
Knowledge, Skills, Abilities
- Demonstrated proficiency with Microsoft Excel, including formulas, functions, data validation, tables, and data organization.
- Familiarity with Microsoft Power BI, including data modelling, dashboard development, and visualization, or demonstrated ability to learn these tools quickly.
- Strong analytical and problem-solving skills, including the ability to clean, organize, validate, and interpret quantitative information.
- Ability to develop clear, accurate, and accessible dashboards, charts, and reports for different audiences.
- Strong attention to detail, including identifying errors, inconsistencies, missing information, and opportunities to improve data quality.
- Demonstrated proficiency with Microsoft 365, including Excel, Word, PowerPoint, Teams, and SharePoint.
- Strong organizational and documentation skills, including maintaining accurate datasets and establishing clear procedures for updating reports and dashboards.
- Ability to translate project goals into practical data-management tasks and independently produce complete, high-quality deliverables.
- Excellent written and verbal communication skills, including the ability to communicate technical information and data findings in accessible language.
- Demonstrated accountability, initiative, and follow-through, including managing competing priorities, providing progress updates, and meeting deadlines.
- Ability to collaborate effectively with colleagues and institutional partners with varying levels of technical knowledge.
Assets
- Experience with advanced Excel functions, Power Query, Power BI, DAX, or other data analysis and business intelligence tools.
- Experience consolidating information from multiple data sources and developing automated or repeatable reporting processes.
- Familiarity with Microsoft Power Automate, Microsoft Forms, Qualtrics, or other data collection and workflow automation tools.
- Knowledge of accessibility standards and accessible data visualization practices, including the Web Content Accessibility Guidelines (WCAG).
- Familiarity with accessibility, disability inclusion, equity, or institutional reporting within an institutional environment.
- Experience supporting performance measurement, program evaluation, survey analysis, or project portfolio reporting.