Junior Business Intelligence Analyst

Dalhousie University; Halifax; Hybrid; CAD 65,000 - 83,000; Full time

Benefits offered by this job

Hybrid work (on campus + remote within

Health and dental plans

Health spending account

Employee assistance program

Tuition assistance

Job summary

Dalhousie University is seeking a Junior Business Intelligence Analyst to support institutional reporting and analytics. You will help develop, maintain, and improve reporting solutions to enable evidence-based decision making across the university.

The role emphasizes building Power BI dashboards, validating data, and collaborating with Senior BI Analysts and Data Architects. Hybrid work is available within Nova Scotia.

Qualifications

• Undergraduate degree in data-related field plus 1–2 years of relevant experience.
• Strong organizational, analytical, problem-solving and detail orientation.
• Ability to multi-task and work independently in a fast-paced environment.
• Excellent collaboration and written/verbal communication with technical and non-technical partners.
• Commitment to data accuracy and ongoing professional development.

Responsibilities

• Design, automate, and maintain operational and institutional reports.
• Develop and optimize Power BI dashboards, DAX measures, and data models.
• Validate data across source systems and troubleshoot refresh failures.
• Support Power BI semantic models and collaborate with Data Architects.
• Document data definitions, business rules, and lineage for governance.
• Provide guidance to dashboard users and contribute to training materials.

Education

Undergraduate degree in Data Science/Computer Science/Business Analytics/Statistics/Economics or related field

Tools

Power BI

Tableau

Job description

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

Dalhousie’s core competencies, in particular:

• Self-Awareness & Professionalism
• Respect & Inclusion
• Adaptability
• Knowledge & Thinking Skills
• Service

Additional Information

Dalhousie University supports a healthy and balanced lifestyle. Our total compensation package includes a defined benefit pension plan, health and dental plans, a health spending account, an employee and family assistance program and a tuition assistance program.

Application Consideration

Non-probationary bargaining unit employees ( NSGEU local 77) are given priority consideration. All other applications will be considered when there is no qualified candidate from the bargaining unit.

We sincerely appreciate all applications and note that only candidates selected for an interview will be contacted directly by the hiring department or People and Culture.

Diversity Statement

Dalhousie University commits to achieving inclusive excellence through continually championing equity, diversity, inclusion, and accessibility. The university encourages applications from Indigenous Peoples of Turtle Island (especially Mi’kmaq), persons of Black/African descent (especially African Nova Scotians), and members of other racialized groups, persons with disabilities, women, persons identifying as members of 2SLGBTQIA+ communities, and all candidates who would contribute to the diversity of our community. In accordance with our Employment Equity Policy, preference will be given in hiring processes to candidates who self-identify as members of one or more of the equity-deserving groups listed above. For more information, including details related to our Employment Equity Policy and Plan and definitions of equity-deserving groups please review our Employment Equity information. If you require any support for the purpose of accommodation, such as technical aids or alternative arrangements, please let us know of these needs and how we can be of assistance. Dalhousie University is committed to ensuring all candidates have full, fair, and equitable participation in the hiring process. Our complete Accommodation Policy can be viewed here.

Required fields are indicated with an asterisk (*).

Documents Needed to Apply

Required Documents

• Résumé / Curriculum Vitae (CV)

Optional Documents

• Cover Letter