Data and Insights Analyst

The role of a Data & Insight Analyst will support and report to the Manager, Data & Insights. The Data & Insight Analyst works with other members of the team to provide business intelligence for decision makers across campus. The Data & Insight Analyst builds and maintains the data models, pipelines, and reports that leaders across NAIT rely on. Student Progression is comprised of two main areas: Education Insights, Data and Research (EI) and the Office of the Registrar.

Responsibilities

Owns assigned data analysis and reporting requests from programs, schools, and central administrative departments, from requirements through to tested, deployed output; Leads the design, construction, testing, and deployment of business intelligence and reporting solutions that inform decisions made by stakeholders across the institute, including standardized reports, dashboards, exploratory views, and data exports; Sources, cleanses, and models large data sets in the Microsoft Fabric lake house and data warehouse for projects; Uses data visualization tools and techniques to explore trends and communicate findings to stakeholders; Accesses, compiles, organizes data for distribution to stakeholders; Responsible for maintaining confidentiality of data and information when supporting leaders through decision making processes; Performs and supports data reporting that inform admissions and student financial support policies, program efficacy assessment, program renewal, curriculum assessment, institutional enrolment planning, and budgets; Develops an understanding of stakeholder's needs by participation in meetings and other requirement gathering activities with individuals and groups; Works in an iterative, agile manner with stakeholders to validate and incorporate requirements into projects, managing own work in Azure DevOps and delivering accurate work to committed dates; Maintains knowledge of business source systems and processes by maintaining contact with subject matter experts in the registrar's office and program areas; Collaborates with other members of Education Insights in delivering needed support to stakeholders; Ensures that projects follow best practice for data visualization, modelling, and data governance, including access security, documentation, data quality, and privacy requirements

Requirements

Bachelor's degree relevant to position; Minimum 4 years of experience working with institutional data, preferably in a post-secondary institution; Advanced skills with business intelligence tools such as PowerBI/DAX, SQL Server and Excel; Strong analytical and problem-solving skills. Able to learn quickly and independently when facing new problems or situations; Knowledge of post-secondary Institution programs, policy, procedures, and reporting environments; Understanding of software development lifecycles, data modelling, and business intelligence approaches such as Kimball data warehouse; Knowledge of data visualization best practices; Strong written and verbal communication skills; Ability to interpret and explain data insights to a non-technical audience using business language; Ability to elicit requirements from business users and work with IT teams to translate requirements into useable data structures; Ability to work independently with minimal direction, manage own priorities, and work as part of cross-functional teams; Excellent time management and organizational skills

Nice to have

Experience with Microsoft Fabric or a similar lakehouse platform; Python; Campus Solutions; Current Microsoft Fabric or Power BI certification

Benefits

Comprehensive benefits package; Health and wellness, work-life balance, recognition, and professional and personal growth perks (for eligible positions); Excellent vacation time; Paid time off between Christmas and New Year's (for eligible employees)