Junior Business Intelligence Analyst

Salary $38.70 - $49.01 per hour ($65,403 - $82,835 per annum, 32.5 hours per week per week)

Classification
Classification SIT2

Provisional Statement
This is a provisional classification. Formal regular review classification procedures may be initiated at any time by the incumbent or supervisor after the incumbent has worked a minimum of six months in the role.

Dalhousie University is Atlantic Canada’s leading research-intensive university and a driver of the region’s intellectual, social and economic development. Located in the heart of Halifax, Nova Scotia, with an Agricultural Campus in Truro/Bible Hill, Dalhousie is a truly national and international university, with more than half of our almost 21,000 students coming from outside of the province. Our 6,000 faculty and staff foster a vibrant, purpose-driven community, that celebrated 200 years of academic excellence in 2018.

Job Summary
The Office of Planning and Institutional Effectiveness ( OPIE ) is accountable for ensuring smooth, efficient institutional operations and supporting the strategic priorities of Dalhousie by providing shared services in the space of strategy development, project and planning support, data warehousing, governance and advanced analytics. Reporting to the Director, Data Transformation and Governance, the Junior Business Intelligence Analyst will support the development, maintenance, and quality of institutional reporting and analytics to enable evidence-based decision making across the university.

Key Responsibilities

Design, automate, and maintain operational and institutional reports to support decision-making, improve consistency, and reduce manual effort. Ensure compliance with data governance standards and resolve data quality issues.

Develop and optimize Power Business Intelligence (BI) dashboards, Data Analysis Expressions ( DAX ) measures, calculated tables, and data models. Apply visualization and user-centred design standards to deliver clear, accessible, and consistent reporting solutions.

Validate and reconcile data across source systems, the Enterprise Data Warehouse ( EDW ), and BI products. Troubleshoot data refresh failures, model logic issues, and reporting discrepancies.

Support the development and maintenance of Power BI semantic models and datasets. Collaborate with Senior BI Analysts and Data Architects to validate data relationships, calculations, and metadata.

Document data definitions, business rules, transformation logic, and lineage to support governance and compliance. Perform data profiling and implement data quality controls.

Provide technical support and guidance to dashboard users on reporting functionality, data interpretation, and analytics tools. Contribute to training materials, user documentation, and continuous improvement initiatives.

Note
The successful applicant will be eligible for hybrid work (combination of in-person work on campus and remote work from within Nova Scotia) as agreed by all parties based on operational requirements and university guidelines.

Required Qualifications

Undergraduate degree in Data Science, Computer Science, Business Analytics, Statistics, Economics, or a related field plus one to two years’ relevant experience (or an equivalent combination of training and experience).

Foundational experience with Power BI, Tableau, or similar BI tools (academic, internship, or entry level work experience) as well as demonstrated understanding of relational databases, SQL concepts, and data modeling basics.

Strong organizational, analytical, problem solving, and attention to detail skills with the ability to multi-task and work independently in a fast paced, deadline driven environment.

Strong collaboration and communication (verbal and written) skills including the ability to work with both technical and non-technical partners and to document processes clearly and communicate technical concepts in user friendly language.

Demonstrated commitment to accuracy, data integrity, and ongoing professional development.

Assets

Experience working with enterprise data, EDW environments, or large complex datasets.

Exposure to Microsoft Fabric data ecosystem

Required core competencies
Dalhou…