Junior Business Intelligence Analyst

Full job description

Position Title Junior Business Intelligence Analyst Department/Unit Planning and Analytics Location Halifax, Nova Scotia, Canada Posting Number S287-26 Employee Group NSGEU Local 77 Position Type Term Duration of Contract (if applicable) 2 years Employment Type Full Time Full-time Equivalency (FTE) 1.0 Salary $38.70 - $49.01 per hour ($65,403 - $82,835 per annum, 32.5 hours per week per week) 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. About Dalhousie University 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

Job Competencies The successful candidate is expected to demonstrate proficiency in 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.