2627-215 - Business Analytics Developer (CL3) - Central Office

Nova Scotia Community College - NSCC; Halifax; On-site; CAD 76,000 - 89,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Paid Time Off

Retirement Plans

Pension plan

Disability Insurance

Employee Assistance Program

Tuition Aid

Job summary

Nova Scotia Community College is seeking a Business Analytics Developer (CL3) in Halifax, NS. The role reports to the Senior Manager, Institutional Research and Effectiveness, and supports Academic Operations, Institutional Research, Finance, and HR with BI solutions.

You will prototype reports, design dashboards, and participate in data warehouse design while ensuring secure, reliable report delivery. A degree in IT or related field is required and familiarity with Cognos/Power BI and Microsoft

Qualifications

• Bachelor's degree or college diploma in IT, Business Admin, Statistics, CS or related field.
• Experience with analytics solutions, especially Power BI.
• Understanding of business analysis activities to gather reporting and dashboard requirements.
• Strong SQL and relational databases knowledge (MS SQL Server T-SQL).
• Proficiency with Microsoft Office Suite (Word, Project, Excel, Visio).
• Knowledge of ERP systems (HR, Finance, Student Admin) is a plus.
• Experience with ETL in Microsoft Fabric is an asset.
• Knowledge of programming languages like Python or .NET to access cloud APIs is an asset.
• Understanding of dimensional modelling for data warehouses is beneficial.
• Comfortable in a digital environment and eager to leverage technology for better student experiences.

Responsibilities

• Develop an understanding of academic operations, Institutional Research, Finance, and HR processes to support BI needs.
• Analyze reporting requirements, prototype reports and dashboards early in the project lifecycle.
• Contribute to data warehouse data model design.
• Translate business requirements into design and technical specs for development.
• Design and develop reports and dashboards; implement report security solutions.
• Assist in UAT and train users on the BI tools and solutions.
• Provide production support for reports and dashboards to ensure performance.
• Collaborate with BI team, Office of Learning and Transformation, and Digital Innovation & Technology.

Skills

Power BI

SQL / T-SQL

ETL with Microsoft Fabric

Python / .NET

Data warehousing / dimensional models

ERP knowledge

Office suite (Excel/Word/Visio)

Education

Relevant university degree or college diploma

Tools

Cognos BI

Power BI

Microsoft Fabric

Job description

Office of Learning and Transformation

Discover
The Opportunity
Halifax, NS
In-person
Education and Training
Experienced
Full-time
Competition Number: 2627-215

Benefits

• Health Insurance
• Dental Insurance
• Paid Time Off
• Retirement Plans
• Pension plan
• Disability Insurance
• Employee Assistance Program
• Tuition Aid

Business Analytics Developer (CL3)

Education,
Central Office/ IT Campus
Halifax, Nova Scotia

Office of Learning and Transformation

Continuing Full-time Position: Commencing approximately November 16, 2026

Application deadline is

11:59PM, November 3, 2026

Competition No.

2627-215

Salary range

$76,058.94 to $89,481.10 annually

Share

What you'll do

Responsibilities

What you will be doing…

Reporting to the Senior Manager, Institutional Research and Effectiveness and as part of the Business Analytics Team, you will:

• Develop a strong understanding of business processes for Academic Operations & Planning, Institutional Research, Finance, and HR in order to be able to better support their Business Intelligence needs for the College through an understanding of how reports and information can enable them to perform their role more effectively.
• Analyze Information and reporting business requirements, explore and evaluate various options, develop prototypes using reporting and dashboard tools up front in the project life cycle thereby validating the requirements, eliminating ambiguity and providing early visibility to business on the final solution.
• Participate as a contributor in the design of the data warehouse data model.
• Assist in translating the business requirements to a design and build technical specification document that will drive the development activities.
• Work closely with the team in designing and developing reports, dashboards and implementing report security solutions.
• Participate and assist in User Acceptance testing, train users on usage of the tool and the solution.
• Provide production support of all reports and dashboards to ensure the availability and performance of developed reports and dashboards for customers.
• Working collaboratively with the team to perform administrative functions with our BI tools including Cognos BI, Microsoft Power BI, and Microsoft Fabric tools and capabilities. This will include setting up and maintaining report security, scheduled jobs, automated report delivery, and report migration between environments.
• Build and maintain collaborative relationships with Business Analytics Team members, Office of Learning and Transformation and Digital Innovation & Technology personnel and with business stakeholders.

What you'll need

Qualifications

Qualifications and Occupational Experience

• The minimum educational qualification for this position is a relevant university degree or College diploma in an area such as Information Technology, Business Administration, Statistics, Computer Science or related field.
• This is an entry level position. While extensive professional experience is not required, candidates must demonstrate:
• an understanding of IT system development methodologies
• experience developing Analytics solutions specifically with Microsoft Power BI
• understanding of business analysis activities to gather required reporting and dashboard requirements
• Srong understanding of relational databases with hands on experience in SQL programming, specifically MS SQL Server T-SQL would be considered an asset.
• Proficiency with use of Microsoft Office applications including, Word, MS Project, Excel and Visio and other tools that facilitate documenting requirements and solution design.
• Knowledge of Administrative ERP systems (HR, Finance, and Student Admin) would be considered an asset.
• Experience with ETL development tools within Microsoft Fabric would be considered an asset.
• Knowledge of programming languages such as Python or .NET that could be used to leverage Cloud software API's to ingest data would be considered an asset.
• Strong understanding of dimensional modelling principles for data warehouses is a plus.
• You are comfortable working in a digital environment; you take responsibility for acquiring knowledge about advancing technology, and you are committed to using technology to create an exceptional student experience.

Relevant Skills And Knowledge

• You demonstrate a commitment to inclusion, diversity, equity, accessibility and anti-racism.
• Possess a curiosity and interest in data and analytics.
• A positive, self-starter that will seek out opportunities to learn and add business value to the Analytics team and the organization.
• Ability to translate business requirements to develop report prototypes that lead to business buy-in and refinement of the final deliverables.
• Experience gathering and documenting detailed business requirements for reporting solutions.
• Excellent Analytical skills and strong attention to detail.
• Excellent communication skills and presentation skills.
• Excellent interpersonal and collaborative skills.

A Little Bit About Us

Nova Scotia Community College

We value Diversity and Inclusion

The College values diversity and inclusion and is committed to employment equity. We encourage applications from all qualified candidates including Mi'kmaq, Aboriginal/Indigenous Persons, Black/African Nova Scotians, members of racially visible communities, persons with disabilities, persons of a minority sexual orientation, gender identity and/or expression, and women. Applicants from these communities wishing to self-identify may do so by completing the online questionnaire within the application.

NSCC is organized into six campus regions and one stand-alone campus. Each region and stand-alone campus is led by a designated Principal and regional management team which supports NSCC's commitment to accessible, high-quality education across the province.

• Eastern Region: Includes Pictou Campus, Strait Area Campus, and Wagmatcook Learning Centre
• Northern Region: Includes Truro Campus, Cumberland Campus, and Amherst Learning Centre
• Metro Region: Includes Akerley Campus and IT Campus
• Southwest Region: Includes Lunenburg, Shelburne, Burridge Campuses, and Digby Learning Centre
• Valley Region: Includes Kingstec Campus, Annapolis Valley Campus, and the Centre of Geographic Sciences (COGS)
• Sydney Waterfront and eCampus Region: Includes Sydney Waterfront Campus and eCampus

Stand-Alone Campus

• Ivany Campus

Are you interested?

Work With Us

Candidates selected for interviews will be expected to provide at least three recent, occupational references. The successful candidate will be expected to provide official transcripts to show proof of academic achievements. NSCC is committed to the full inclusion of all applicants. As part of this commitment, NSCC will ensure that applicants are provided reasonable accommodations, as required. If accommodation is needed to participate in the job application process, please contact Nikki Berrigan, HR & Talent Consultant at [e-mail]. Our Employee Workplace Accommodation Policy can be found here.

Unfortunately, we cannot accept late or paper applications.