Ubc
Data Analyst
UBC Vancouver Campus - Vancouver, BC, Canada
Sponsorship not specifiedDetected 5 days ago
PythonSQLAWSAzureData AnalysisData EngineeringData VisualizationStatisticsSalesforceCRMHRISResearchLeadershipCommunicationCollaborationProblem Solving
About the role
- 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.
Responsibilities
- 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.
- Partner with stakeholders to understand business needs, gather requirements and translate them into analytical datasets, dashboards, reports and analytical solutions.
- 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 to support reporting and analytics needs.
- Build and maintain curated, analytics-ready datasets within Microsoft Fabric (Lakehouse, Warehouse, OneLake).
- 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.
Requirements
- Undergraduate degree in a relevant discipline.
Nice to have
- 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 working with large and complex datasets from multiple independent systems of record.
- 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.
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.
- 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).
- Additional Assets
- 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.
Compensation
- $5,964.75 - $8,573.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position.
- In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.
Benefits
- Support reporting needs across key domains (e.g., finance, HR, learning systems, marketing, admissions).
Company info
- Operating within a dynamic and fast-paced environment, we are committed to driving evidence-based decision-making in support of academic and operational excellence.
This listing is sourced directly from Ubc's careers page and normalized into a canonical job model.