System and Data Analyst
Closing date: 27 July 2021
Competition: 140031 (Internal/External)
Status: Regular Full-time
Section: Research, Measurement and Data Analytics
Salary Scale: $79,344 to $93,382
This competition is open to all candidates who meet the eligibility criteria. This competition will have a hiring priority for Indigenous people, Black people, Asian people and racialized people. Candidates from these groups who wish to qualify for preferential consideration must self-identify. This initiative is in support of the Council’s employment equity goals.
About the Canada Council for the Arts
Join our team and play a role in supporting Canadian creativity. The Canada Council is a dynamic, highly-respected federal Crown corporation with a mandate to foster and promote the study and enjoyment of, and production of works in, the arts for the benefit of all Canadians. We offer competitive salaries and benefit package. For more information about the Canada Council for the Arts, please visit our website at www.canadacouncil.ca.
About the role
Under the direct supervision of the Senior System and Data Analyst, the incumbent liaises with arts funders and organizations using the system and is responsible for developing and maintaining relationships with these users.
As the System and Data Analyst, you will:
- assist in managing all non-technical and technical aspects of the CADAC database and application;
- help with registration of arts organizations in CADAC;
- complete reconciliations of arts organizations’ financial statements with their financial data;
- sign off on arts organizations’ financial data;
- conduct analysis of the submitted data and recommends corrections to entries made in CADAC and/or Financial Statements;
- recommend, monitor, validate financial and statistical data collection and reporting approaches;
- develop and maintain data sets used for the analysis of data, identification of trends and corporate reporting using CADAC data;
- undertake data analysis and research concerning the activities of the Canada Council and the arts milieu in Canada and abroad;
- design visualizations (including charts and graphs) to best represent data;
- assist in managing the approval and tracking process for CADAC content enhancements;
- communicate with agencies to resolve specific reporting issues as required;
- provide service to CADAC members;
- prepare for and participates in various CADAC working groups and committees;
- provide customer service to all users and responds to technical and administrative enquiries;
- create training material and provide technical, financial and statistical data related training for the Council staff, members and arts organizations;
- provides organization’s financial analysis and present recommendations to the CADAC members, raises awareness, and communicates to CADAC users about financial trends and changes in the Canadian not-for-profit sector;
- perform other related duties.
Note: CADAC is a joint effort of arts funders across the country, CADAC (Canadian Arts Data / Données sur les arts au Canada) provides a simplified process and standardized forms for arts organizations applying for operating grants. Arts organizations making application to multiple funding agencies submit their financial and statistical information in a single format, to a single source, they have access to their own historical data and to reports both on their own organizations and comparisons to all similar organizations in the database. Public sector funding agencies have immediate access to current and consistent data for all the arts organizations they fund. Aggregate data across CADAC is also accessible, allowing for reliable and consistent analysis of the Canadian arts sector. Individually and collectively, funding agencies are be able to report on the health of the field and the impact of the arts in their communities.
You may be required to travel up to twenty (20) days per year and on occasion, work irregular hours.
This position is in Ottawa. The Council provides eligible employees with financial assistance to help offset specific moving expenses associated with relocation to the National Capital Region (NCR).
Requirements of the position
*Important: Please submit your resume clearly demonstrating how you meet the following qualifications for Education and Experience. Please note that selection for further consideration will be based solely on the information provided in your resume and in the application form.
- An undergraduate degree in finance, accounting or arts management, or an equivalent combination of education and practical experience related to the responsibilities of the position
- Five (5) years of experience directly related to the principal responsibilities of the position in financial administration, data analytics, accounting practices and principles, including three (3) years progressive experience in statistical and quantitative analysis, principles and methods, and electronic data processing methods
- Experience analyzing financial and statistical data utilizing a computerized system
- Experience in extraction, validation, analysis and presentation of quantitative data using data extraction and data visualization software
- Experience preparing change request documents, instructions and guidelines
- Experience with web-based systems would be an asset
- Experience working in arts funding would be an asset
- Strong knowledge of general accounting principle and practices for Not-for-Profit organizations, and financial management principles and practices, preferably in the context of an arts milieu
- Working knowledge of data software (such as QuickBooks, SQL, Power BI, CRM)
- Knowledge of data architectures and diagram principles
- Strong general knowledge of regulations and practices relating to the not for profit sector, e.g. taxation and/or legal regulations
- Excellent knowledge of quantitative analysis
Skills & Competencies
- Ability to analyze financial statements Ability to analyze financial and statistical data to recognize significant factors, relationships and trends, and provide recommendations
- Strong attention to detail
- Ability to communicate clearly and concisely, effective presentation skills, facilitating knowledge transfer
- Proficiency in MS Office Suite and Adobe
- Ability to collaborate effectively with internal and external stakeholders
- Strong time management and prioritizing skills
- Demonstrated problem-solving and decision-making skills
- This position requires the use of both official languages. The requirements in the second official language are: an advanced level in oral, an advanced level in reading comprehension and an intermediate level in writing.
How to apply
Send the complete Application Form quoting the competition number listed above and a copy of your resume to the attention of Mylène Mougeot, Human Resources, prior to the closing date by email at email@example.com.
For more information please contact Mylène Mougeot at 613-566-4414 or 1-800-263-5588, extension 4124 or by e-mail at firstname.lastname@example.org.
We thank all applicants for their interest; only those selected for an interview and/or a written exam will be contacted.
TTY machine (toll-free)
The Canada Council for the Arts is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the targeted groups (women, visible minorities, Indigenous peoples and persons with disabilities) when you apply. Please note that while Council uses other terms such as Indigenous (for Aboriginal peoples) in this posting, Council uses the terminology prescribed by legislation for the purposes of employment equity monitoring and reporting.
We are committed to providing a workplace that is inclusive and accessible to all. Should you require accommodation during the staffing process, please do not hesitate to contact a member of our Human Resources team.
If the form won’t open
To view the form, you will need the free version of Adobe Acrobat Reader. Download Adobe Acrobat Reader
Make sure the PDF is opening in Adobe Reader and not in a browser: right‑click the document in your downloads folder and select Open with Adobe Acrobat Reader.
Send the completed form to:
Human Resources, The Canada Council for the Arts,
150 Elgin Street, P.O. Box 1047,
Ottawa, Ontario, K1P 5V8.