FINANCIAL ANALYST- BUSINESS INTELLIGENCE & SYSTEM ADMINISTRATOR

National Arts Centre; Ottawa; On-site; CAD 71,000 - 90,000; Full time

Job summary

A prominent arts organization in Ottawa is seeking a Financial Analyst - Business Intelligence & System Administrator to support financial analysis and reporting. The role requires strong analytical and technical skills, particularly in Power BI, and offers a salary range of $71,700.00 - $89,600.00 per year. Candidates should be fluent in both official languages and possess a Bachelor's degree in finance or business administration.

Benefits

Customized rewards programs

Qualifications

• Minimum of four years of professional experience in a similar role.
• Must be fluently bilingual in both official languages.
• Ability to work under pressure and collaboratively.

Responsibilities

• Design and maintain Power BI dashboards for reporting.
• Prepare internal financial reports for decision-making.
• Support full cycle accounting and audits for NAC.

Skills

Analytical skills

Communication skills

Interpersonal skills

VBA skills

Organization skills

Education

Bachelor's degree in finance or business administration

Professional accounting designation

Tools

Dynamics 365 Business Central

Power BI

MS Word

Excel

PowerPoint

Job description

FINANCIAL ANALYST- BUSINESS INTELLIGENCE & SYSTEM ADMINISTRATOR

Introducing the National Arts Centre
The National Arts Centre (NAC) is Canada's bilingual, multi-disciplinary home for the performing arts. The NAC presents, creates, produces, and co-produces performing arts programming in various streams-the NAC Orchestra, Dance, English Theatre, French Theatre, Indigenous Theatre, and Popular Music and Variety-and nurtures the next generation of audiences and artists from across Canada. The NAC is located on the traditional, unceded, unsurrendered territory of the Anishinabe Algonquin Nation.

At the National Arts Centre, we believe the performing arts are vital to the human experience. A house of dreams for the Canadian performing arts, we work with artists and arts organizations from across this land to revitalize our sector.

Curious to learn more? Read our 2023-2026 Strategic Plan, The Journey Ahead.

Equity, Diversity, Inclusion, Anti-Racism and Accessibility
We are on a journey, committed to ensuring that equity, diversity, inclusion, accessibility, anti-racism and reconciliation with Indigenous peoples will guide our actions.

The NAC welcomes applications from candidates who can help us meet our vision, and contribute to the diversity of lived experiences, perspectives, and approaches. When you join the NAC, you will be part of an inclusive community working hard to dismantle barriers to employees' well-being, access, potential, and success. The NAC actively seeks candidates who identify as women, Indigenous, Black, Persons of Colour (IBPoC), members of 2SLGBTQIA+ communities, and people with disabilities. We encourage you to self-identify in the recruitment process.

Job Number: J0725-0777

Job Title: FINANCIAL ANALYST- BUSINESS INTELLIGENCE & SYSTEM ADMINISTRATOR

Employment Type: Full-Time, Term

Job Category: Accounting / Auditing / Finance

Open Positions: 1

Posting Date: July 24, 2025

Closing Date: August 24, 2025

Salary: $71,700.00 - $89,600.00/Year

Language Requirement: Bilingual is an asset

Working Hours: Monday to Friday, 9:00 a.m. to 5:00 p.m. (35 hours per week)
Maternity leave replacement (16 months)

Job Reports To: Manager, System Administrator & BI

Share Facebook Twitter Email LinkedIn

Key Activities

Reporting to the Manager, System Administrator & BI, the selected candidate is responsible for financial analysis and internal reporting, preparation of bank reconciliations, including supporting the full cycle accounting and audit of the National Arts Centre Corporate and Foundation. In addition, the role provides support for the administration and continuous improvement of financial systems, including Sparkrock 365, Power BI, and other enterprise platforms, to ensure accurate data flow, streamlined processes, and timely reporting. The ideal candidate combines strong analytical skills with system acumen to drive data-informed decision-making and process improvements across departments.

Responsibilities include but are not limited to:

System Administration & Business Intelligence
• Design, develop, and maintain Power BI dashboards and reports to support financial and operational decision-making;
• Provide technical support and training to end users on Sparkrock modules and BI tools;
• Maintain users permissions and security roles in Business Central and related applications;
• Collaborate with finance team and departments users to automate reporting, budgeting, and workflow processes;
• Monitor system performance, troubleshoot issues, and escalate to Sparkrock support when necessary;
• Lead or support version upgrades, module rollouts, and testing of customizations;
• Create and maintain documentation for system processes, customizations, and integrations;
• Support the maintenance of the chart of accounts and other accounting dimensions;
• Monitor data quality and resolve any issues in collaboration with data owners.

Reporting & Financial Analysis
• Assist in preparing accurate and timely monthly, quarterly, and annual internal financial reports to support senior leadership decision-making and stakeholder communications;
• Preparation of bank reconciliations;
• Support of the full cycle accounting and audit of the National Arts Centre Corporation and Foundation;
• Respond to ad-hoc financial analysis and reporting requests from the NAC Foundation and the NAC Corporation leadership and stakeholders;
• Undertake additional tasks or special projects for the NAC Foundation and the NAC Corporation as assigned by management to support evolving business needs.

Skill Requirements
• Bachelor's degree in finance or business administration;
• Professional accounting designation or equivalent is an asset;
• Minimum of four (4) years of professional experience in a similar position or an equivalent combination of education and experience;
• Fluently bilingual in both official languages is an asset;
• Excellent knowledge of MS Word, Excel, PowerPoint and other software;
• Skilled in VBA for automating journal entry templates and data processing;
• Proficient with Dynamics 365 Business Central and Power BI or equivalent.
• Excellent analytical skills and attention to details;
• Strong communication and interpersonal skills;
• Ability to build relationships across different teams;
• Ability to work under pressure and with a team and problem solving skills;
• Good organizational skills and initiative.

Who Can Apply

Persons residing in Canada and Canadian citizens residing abroad. Preference will be given to Canadian citizens.

As part of NAC's interview process, in-person interviews may be required. Please ensure to have the most up-to-date information on your résumé including your current email address.

While we appreciate all applications, only those selected for an interview will be contacted by us.

Important Notice

The National Arts Centre (NAC) is committed to inclusive employee recruitment and selection. The NAC welcomes and encourages applications from people with disabilities. If you require accommodation during the selection process, please inform us as soon as possible and we will make every effort to fulfill your accommodation request.

The successful candidate will be required to provide the original or a true certified copy of their education credentials as appropriate, along with proof of a valid Criminal Background Check as a condition of employment.

Are you interested in this job?

• Customized rewards programs that focus on flexibility and work-life integration
• Customized rewards programs that focus on flexibility and work-life integration
• Customized rewards programs that focus on flexibility and work-life integration
• Customized rewards programs that focus on flexibility and work-life integration
• Customized rewards programs that focus on flexibility and work-life integration
• Customized rewards programs that focus on flexibility and work-life integration