Data Analyst

UBC Sauder School of Business is one of the world’s leading business faculties. The school consistently ranks among the top 100 in the world and is recognized internationally for excellence in research and learning, an outstanding faculty and unmatched global partnerships. A collaborative and respectful culture within which all members of our community can thrive is a key principle in our strategic plan, and one that underpins our educational mission.

We acknowledge that UBC Sauder at the Vancouver Point Grey campus is situated on the traditional, ancestral and unceded territory of the Musqueam. We acknowledge that UBC Sauder at UBC Robson Square is situated on the traditional territory of the Musqueam, Squamish and Tsleil-Waututh.

The Sauder IT & Analytics team partners with faculty, staff, students, and other institutional stakeholders to deliver and sustain relevant, reliable, and innovative information technology solutions. Operating within a dynamic and fast-paced environment, we are committed to driving evidence-based decision-making in support of academic and operational excellence.

The Data Analyst sources and manages data from multiple systems-of-record, including raw data from databases and application APIs, curated extracts, and ad-hoc datasets. This position supports data management and analytics for the UBC Sauder School of Business, while working closely with institutional data governance and analytics teams.

This role focuses on identifying, sourcing, cleaning, managing and transforming data to provide clear, actionable insights for multiple UBC Sauder stakeholders. The Data Analyst is responsible for identifying and sourcing required data, preparing trusted and analytics-ready datasets, developing impactful visualizations, and enabling self-service analytics for business users using modern technologies such as Microsoft Fabric and AI-enabled analytics tools. The Data Analyst is responsible for a number of analytic areas, including, but not limited to, data preparation and management, data mining, statistical analysis, visual analysis, temporal data analysis and/or text analysis.

Organizational Status

Reports to the Assistant Dean, Information Technology & Analytics, UBC Sauder School of Business.

The Data Analyst collaborates proactively with business stakeholders within UBC Sauder, including other data analysts, faculty and administrative stakeholders. The Data Analyst also works with UBC’s Enterprise Data Governance & Business Intelligence teams. Work is reviewed in terms of achievement of high professional standards in the delivery of data and analytics services and broad project objectives and goals.

Work Performed

Business Engagement & Delivery

• Partner with stakeholders to understand business needs, gather requirements and translate them into analytical datasets, dashboards, reports and analytical solutions.

• Work with stakeholders to identify relevant data sources, clarify data definitions, and understand how data flows across systems.

• Support reporting needs across key domains (e.g., finance, HR, learning systems, marketing, admissions).

• Enable self-service analytics by creating reusable datasets, semantic models, and reports.

• Provide guidance and training to users on how to interpret and use data effectively.

• Support business users in understanding the end-to-end flow of data.

Data Discovery, Dataset Development & Data Preparation

• Identify, source, and bring together data from multiple information systems, files, databases, and business processes to support reporting and analytics needs.

• Build and maintain curated, analytics-ready datasets within Microsoft Fabric (Lakehouse, Warehouse, One Lake).

• Clean, transform, standardize and model data using SQL, Power Query, and Fabric Dataflows.

• Apply business rules and data transformation logic to ensure datasets are accurate, consistent, and aligned with reporting needs.

• Collaborate with other analysts, data managers, and technical partners to source, refine, and prepare data for analytics consumption.

• Collaborate with other analysts and data managers to optimize data for performance, accuracy, and long-term maintenance.

Data Quality & Governance

• Validate and reconcile data to ensure accuracy, completeness, consistency, and reliability across reports and dashboards.

• Document data definitions, calculations, transformation logic, assumptions and lineage for transparency and reuse.
• Contribute and adhere to data governance practices, including the use of standardized data definitions, metrics and metadata.

• Identify and troubleshoot data issues, working with upstream teams to resolve them.

Dashboarding & Data Visualization

• Design, develop, and maintain interactive dashboards and reports using Power BI within Microsoft Fabric.

• Create clear, intuitive and visually compelling data products that communicate key metrics, trends, insights, and business unit performance.

• Define and standardize KPIs and reporting layers.

• Promote best practices in data visualization,…