Data Analyst

University of British Columbia•Vancouver, BC

8d•CA$5,965 - CA$8,573

About The Position

UBC Sauder School of Business is a world-leading business faculty, recognized internationally for excellence in research and learning. 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. This role operates within a dynamic and fast-paced environment, committed to driving evidence-based decision-making for academic and operational excellence. The Data Analyst will source and manage data from multiple systems, including raw data from databases and APIs, curated extracts, and ad-hoc datasets. This position supports data management and analytics for UBC Sauder, working closely with institutional data governance and analytics teams. The focus is on identifying, sourcing, cleaning, managing, and transforming data to provide clear, actionable insights for various stakeholders. Responsibilities include preparing analytics-ready datasets, developing impactful visualizations, and enabling self-service analytics using modern technologies like Microsoft Fabric and AI-enabled tools. The role involves data preparation, data mining, statistical analysis, visual analysis, temporal data analysis, and/or text analysis. This position is ideal for a team-focused professional specializing in high-quality data and visualizations that empower business users, playing a central role in enabling data-driven decision-making and advancing a modern data management and analytics environment.

Requirements

Undergraduate degree in a relevant discipline.
Minimum of two years of related experience, or the equivalent combination of education and experience.
Willingness to respect diverse perspectives, including perspectives in conflict with one’s own.
Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion.
Excellent communication and data storytelling abilities.
Strong stakeholder engagement and collaboration skills.
Strong analytical and problem-solving skills.
Ability to translate complex data into clear, actionable insights.
Ability to manage multiple priorities in a fast-paced environment.
Strong attention to detail and commitment to data accuracy, quality, and documentation.
Strong experience with Python and Microsoft Fabric (including Power BI, Dataflows, and Lakehouse/Warehouse environments).
Strong experience with SQL (T-SQL, PL/SQL) for data querying, transformation, and validation.
Advanced skills in DAX, semantic modeling, and building interactive reports within the Fabric ecosystem.
Expertise in building Power BI dashboards, reports, and semantic models.
Experience with OneLake, Delta tables, and Medallion architecture (Bronze/Silver/Gold) concepts.
Proficiency in Power Query M and/or Microsoft Fabric Dataflows for data preparation.
Familiarity with notebook-based analytics.
Understanding of data modeling concepts (star schemas, dimensional modeling).

Nice To Haves

Undergraduate or graduate degree in Business Operations, Data Analytics, Computer Science, or a related field.
Experience in data management, data analysis, business intelligence, or other analytics roles.
Experience in proactively identifying, collecting, and preparing data for use in data pipelines, reporting, and analytics.
Experience building dashboards and preparing datasets in enterprise environments.
Experience working with large and complex datasets from multiple independent systems of record.
Experience with enterprise systems such as Workday, CRM/Salesforce, and Student Information Systems.
Knowledge of data governance, data quality, and metadata management practices.
Familiarity with cloud-based analytics platforms (Microsoft Azure and AWS preferred).
Experience enabling self-service analytics in large organizations.
Familiarity with Data Agents/Copilot in Microsoft Fabric.
Experience working in Higher Education.

Responsibilities

Partner with stakeholders to understand business needs, gather requirements, and translate them into analytical datasets, dashboards, reports, and analytical solutions.
Identify relevant data sources, clarify data definitions, and understand data flow across systems.
Support reporting needs across key domains such as finance, HR, learning systems, marketing, and admissions.
Enable self-service analytics by creating reusable datasets, semantic models, and reports.
Provide guidance and training to users on interpreting and using data effectively.
Support business users in understanding the end-to-end flow of data.
Identify, source, and bring together data from multiple information systems, files, databases, and business processes.
Build and maintain curated, analytics-ready datasets within Microsoft Fabric (Lakehouse, Warehouse, OneLake).
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.
Optimize data for performance, accuracy, and long-term maintenance.
Validate and reconcile data to ensure accuracy, completeness, consistency, and reliability across reports and dashboards.
Document data definitions, calculations, transformation logic, assumptions, and lineage.
Contribute to 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.
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, usability, and performance, with an emphasis on empowering business user self-service.
Perform exploratory data analysis to uncover trends, patterns, and opportunities.
Support advanced analytics initiatives by preparing high-quality datasets.
Use novel technologies, including artificial intelligence, to support data management and analysis.
Leverage Microsoft Fabric capabilities (e.g., Notebooks, Pipelines, Data Agents) to enhance productivity and insight generation.
Manage version control of notebooks and data deployments across environments.
Improve dashboards, datasets, and reporting processes based on user feedback and changing business needs.
Ensure data is continuously available in data lakes and/or data warehouses.
Maintain documentation for datasets, data definitions, KPIs, calculations, and reporting logic.
Ensure alignment with enterprise data standards and governance practices.
Support the full analytics lifecycle, from data discovery and preparation through to reporting, visualization, and insight delivery.
Contribute to the evolution of the organization’s analytics and reporting capabilities.
Perform other duties as assigned.

Benefits

The Compensation Range is the span between the minimum and maximum base salary for a position.
The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position.
In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.
UBC supports inspired students, faculty and staff on their journey of discovery, and challenges them to realize their greatest potential.
New ideas, changing infrastructure, innovative technology, and fresh approaches are opening up possibilities for the future of research, teaching, and work.
Equity and diversity are essential to academic excellence.
An open and diverse community fosters the inclusion of voices that have been underrepresented or discouraged.
All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority.
If you have any accommodation or accessibility needs during the job application process, please contact the Centre for Workplace Accessibility at [email protected].