linkedin
Data Analyst
The University of British Columbia
Vancouver, CAN
Full Time
Mid
Field
Today
SQLPythonMicrosoft FabricPower BIData PreparationData Visualization
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
SQLPythonMicrosoft Fabric
About the Role
UBC Sauder School of Business seeks a Data Analyst to source, manage, and transform data from multiple systems, creating analytics-ready datasets and impactful visualizations using Microsoft Fabric and Power BI.
Key Skills for This Role
SQLPythonMicrosoft FabricPower BIData PreparationData Visualization
Responsibilities
- Partner with stakeholders to understand business needs and translate them into analytical datasets, dashboards, and reports
- Identify, source, and bring together data from multiple information systems to support reporting and analytics needs
- 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
- Design, develop, and maintain interactive dashboards and reports using Power BI within Microsoft Fabric
- 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
- Perform exploratory data analysis to uncover trends, patterns, and opportunities
- Support advanced analytics initiatives by preparing high quality datasets
- Enable self service analytics by creating reusable datasets, semantic models, and reports
Requirements
- Undergraduate degree in a relevant discipline
- Minimum of two years of related experience, or equivalent combination of education and experience
- 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 concepts
- Proficiency in Power Query M and/or Microsoft Fabric Dataflows for data preparation
- Excellent communication and data storytelling abilities
- Strong analytical and problem solving skills
Full Job Posting
Job Summary
- UBC Sauder School of Business is one of the world's leading business faculties, recognized for excellence in research and learning.
- The Sauder IT & Analytics team partners with stakeholders to deliver innovative IT solutions and drive evidence based decision making.
- The Data Analyst sources and manages data from multiple systems of record, supporting data management and analytics for the school.
Work Performed
- Partner with stakeholders to understand business needs, gather requirements and translate them into analytical datasets, dashboards, reports and analytical solutions.
- 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, OneLake).
- Clean, transform, standardize and model data using SQL, Power Query, and Fabric Dataflows.
- Design, develop, and maintain interactive dashboards and reports using Power BI within Microsoft Fabric.
- 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.
- Perform exploratory data analysis to uncover trends, patterns, and opportunities.
- Support advanced analytics initiatives by preparing high quality datasets.
- Enable self service analytics by creating reusable datasets, semantic models, and reports.
Minimum Qualifications
- 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.
- Demonstrates a commitment to enhancing one's own awareness, knowledge, and skills related to equity, diversity, and inclusion.
Preferred Qualifications
- 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 building dashboards and preparing datasets in enterprise environments.
- Experience working with large and complex datasets from multiple independent systems of record.
Technical Skills
- 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).
People Skills
- 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.
Compensation
- Salary range: CAD 5,964.75 CAD 8,573.08 monthly.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at The University of British Columbia
Payroll Reconciliation Analyst
Vancouver, CAN
MidFull Time
UBC is hiring a Payroll Reconciliation Analyst to manage payroll reconciliation, accounting, and compliance for a large university. The role involves analyzing complex data sets, ensuring accurate payroll processing, and
YesterdayView →
Senior Financial Analyst
Vancouver, CAN
SeniorFull Time
UBC is seeking a Senior Financial Analyst to manage complex financial activities for Student Financial Management, including tuition and fee assessments, financial planning, and policy development. The role requires a CP
3 days agoView →
Education Systems Coordinator
Vancouver, CAN
MidFull Time
UBC Faculty of Medicine is seeking an Education Systems Coordinator to oversee rotation management and system access for the MD Undergraduate and Postgraduate Medical Education programs. The role involves data management
6 days agoView →