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

NSCC; Halifax; On-site; CAD 76,000 - 89,000; Full time

Job summary

NSCC, located in Halifax, Nova Scotia, seeks a Business Analytics Developer (CL3) to join the Office of Learning and Transformation. This entry-level role focuses on building analytics solutions and dashboards to support Academic Operations, Institutional Research, Finance and HR.

You will translate business requirements into prototypes, assist in data warehouse design, and deliver production reports. Strong SQL, Power BI and collaboration skills are essential for success.

Qualifications

• Bachelor's degree or college diploma in IT, business, statistics or CS.
• Entry-level; demonstrates understanding of IT system development methodologies and analytics.
• Experience developing analytics solutions with Microsoft Power BI.
• Understanding of business analysis activities to gather reporting requirements.
• Knowledge of MS SQL Server T-SQL is a plus.
• Proficiency with Office apps (Word, Excel, Visio), documenting requirements and design.
• Knowledge of ERP systems (HR/Finance/Student) is a plus.
• Experience with ETL tools in Microsoft Fabric is a plus.
• Knowledge of Python or .NET for cloud API data ingestion is a plus.

Responsibilities

• Develop understanding of business processes in Academic Operations, Institutional Research, Finance and HR.
• Analyze requirements and prototype using reporting/dashboard tools to validate needs.
• Contribute to data warehouse data model design.
• Translate requirements into technical specifications for development.
• Design and develop reports and dashboards; implement report security.
• Support UAT, train users on tool usage and solution.
• Provide production support for reports and dashboards.
• Collaborate to manage BI tools, report security, scheduling, delivery and migration.
• Build relationships with BI team, offices and stakeholders.

Skills

Power BI

SQL

Data analysis

Communication

Education

Bachelor's degree or college diploma

Tools

MS SQL Server T-SQL

Cognos BI

Microsoft Fabric ETL

Power BI integration

Job description

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

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.

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.

Additional Information

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.