Position Title
Junior Business Intelligence Analyst
Department/Unit
Planning and Analytics
Location
Halifax, Nova Scotia, Canada
Duration of Contract (if applicable)
2 years
Employment Type
Full Time
Full-time Equivalency (FTE)
1.0
Salary
$54,222 - $72,426 per annum
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, maintain, automate and enhance recurring operational and institutional reports for units improving consistency and reducing manual effort. Ensure reports adhere to institutional definitions, governance standards, and business rules; investigate and resolve data issues.
- Build data analysis expressions (DAX) measures, calculated tables, and optimized data models. Apply user centered design principles and OPIE’s visualization standards to ensure clarity, consistency, and accessibility. Collaborate with senior analysts to ensure cross dashboard alignment and reuse of shared logic.
- Support the development and maintenance of semantic models and dataset structures within Power Business Intelligence (BI). Work with Senior BI Analysts and Data Architects to validate relationships, measures, and metadata.
- Validate data transformations and conduct reconciliation between source systems, the enterprise data warehouse (EDW), and BI products. Troubleshoot data refresh issues, broken logic, and discrepancies between source systems and reports.
- Document business rules, definitions, transformation logic for use in MS Purview; and lineage, data definitions, and business rules to support governance and compliance. Execute data profiling and implement data quality checks within BI datasets.
- Provide frontline support to campus users by answering questions about dashboards, filters, definitions, and data interpretation. Contribute to training materials, documentation, and user guides. Participate in workshops and feedback sessions to collect user insights and identify areas of improvement.
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 Azure data ecosystem (Data Factory, Microsoft Fabric, Synapse, Data Lake).
- Familiarity with data governance concepts, including definitions, lineage, quality rules, and stewardship.
- Experience applying visualization best practices and user centered design.
Job Competencies
The successful candidate is expected to demonstrate proficiency in Dalhousie’s core and leadership competencies (https://www.dal.ca/dept/leaders.html), in particular:
- Integrity
- Respect & Inclusion
- Adaptability
- Knowledge & Thinking Skills
- Communication
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
Applications from current university employees and external candidates are assessed concurrently. Current university employees will be given special consideration.
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 visit www.dal.ca/hiringfordiversity
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.