{bc}
Apply
indeed

Data Analyst

University of British Columbia
Vancouver, CAN
Full Time
Mid
Field
Yesterday
SQLPythonMicrosoft FabricPower BIData VisualizationData Governance
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

SQLPythonMicrosoft Fabric
Smart Apply

Full Job Posting

Job Summary

  • UBC Sauder School of Business is one of the world’s leading business faculties.
  • 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.

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.

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, 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.

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, usability, and performance, with an emphasis on empowering business user self service where appropriate.

Advanced Analytics & Continuous Improvement

  • 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.

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, 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

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 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.

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).

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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today