Senior Business Intelligence Analyst

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

** This position is classified at the RE-05 level which is equivalent to the groups and levels identified above.

How to Apply:

Please do not submit a covering letter. Screening will be based on responses to the screening questions, so read them carefully and provide complete answers that demonstrate the depth and breadth of your experience.

In order to be considered, your responses to the screening questions must clearly explain how you meet the essential education and experience requirements otherwise you will not be screened into the next phase of the process. Candidates will not be contacted to seek missing or incomplete information. Provide specific and concrete examples of your work history as it relates to each essential experience requirement and any applicable assets. Really focus on what you did! Your résumé may be used to validate your examples.

As this process may be used to fill similar positions, additional qualifications (asset qualifications, operational requirements) may be used in the screening of candidates and/or to choose from among qualified candidates for specific positions. If you have any of those qualifications, please answer "yes" to the relevant question in your application and ensure you clearly demonstrate with specific and concrete examples how you meet the qualification.

Duties

The Senior Business Intelligence Analyst will lead projects and programs in data governance, data quality and data management. They will have a key role in implementing the FCAC’s Data and Analytics Strategy. They will work closely with subject matter experts on other teams in the Agency and will collaborate with other business intelligence analysts and data architects within the IM/IT division.

Work environment

Financial consumer protection is an integral part of the Government of Canada’s oversight of the financial sector. The Financial Consumer Agency of Canada (FCAC) ensures Federally Regulated Financial Entities (FRFEs) comply with consumer protection measures, promotes financial education and raises consumers’ awareness of their rights and responsibilities.

FCAC is a small separate agency subject to the Public Service Employment Act (PSEA). We have our own unique classification system (RE and REX) with relevant equivalences noted above and we offer the same pension as the core public administration. In addition, as a FCAC employee, you will benefit from:
• a competitive salary;
• eligibility for performance pay at all classification levels within the organization;
• a comprehensive benefits package including: Health and Dental Plan; Disability benefits; Life insurance;
• a minimum of four (4) weeks of vacation leave per year;
• a hybrid work place with options for telework* and flexible work schedules;
• a broad range of learning opportunities; and,
• a strong support for employee wellness and mental health including access to the confidential employee assistance program.

* The designated workplace for this position is downtown Ottawa (Ontario). However, requests to telework from other parts of Canada may be considered. For information on our telework requirements and conditions, please contact us.

Our people are our strength and we're looking for highly engaged and talented professionals to join our team!

Intent of the process

The intent of this process is to staff one position on an indeterminate (permanent) basis.

This selection process may be used to staff similar or identical positions with various linguistic profiles and requirements, security profiles, and tenures.

Positions to be filled: 1

Information you must provide

Your résumé.

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

Successful completion of an acceptable post-secondary educational program in computer science, information technology, economics, applied mathematics or statistics, or another specialty relevant to the position to be staffed.

Degree equivalency

Experience using SQL Server Management Studio (SSMS) and Power BI;

Significant experience* querying and modelling data sources including data warehouse systems;

Significant experience* analyzing data from different business units horizontally to improve business processes, and to operationalize data analytic solutions; and,

Significant experience* with Business Intelligence (BI) and Data Analytics, including data mart, reporting models, and visualization (E.g., cubes, tabular models, datasets, dataflows in Power BI).


* Significant is defined as depth and breadth of experience normally associated with the performance of those duties for a period of approximately two years.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

Graduation with a degree from a recognized university with an acceptable specialization in computer science, computer engineering, information technology, or other related area.

Degree equivalency

Microsoft Certification on cloud technologies relating to data analysis, data engineering and data science.

Experience using Purview, or comparable alternatives such as Informatica, Oracle Enterprise Manager.

Experience OR Microsoft Certification on Microsoft cloud technologies and platforms such as Dynamics 365, Power BI, Power Apps, Power Automate, and other Azure services that are not relating directly to data and analytics.

Experience of leading data management and data governance initiatives.

Experience with SPSS Statistics or Modeler, R or Python for data analysis.

The following will be applied / assessed at a later date (essential for the job)

Bilingual - Imperative (BBB/BBB)

Information on language requirements

Knowledge of Microsoft Cloud technologies relating to data engineering;
Knowledge of Microsoft Cloud technologies relating to data analysis and data science; and,
Knowledge of data and analytics strategies, responsible use, governance and best practices.

Upholding Integrity and Respect;
Working effectively with others;
Demonstrating initiative and being action oriented;
Thinking things through; and,
Digital Literacy and competency.

Ability to communicate effectively in writing
Ability to communicate effectively orally

The following may be applied / assessed at a later date (may be needed for the job)

Preference may be given to applicants who are members of one or more of the following employment equity groups: Women, Aboriginal peoples, persons with disabilities and members of a visible minority group

Information on employment equity

Ability and willingness to work overtime when required.

Conditions of employment

Secret security clearance

Other information

The Public Service of Canada 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 designated groups when you apply.

Information on employment equity

Indeterminate employees of the Public Service who are at the same or an equivalent group and level may be considered for deployment.

Please identify clearly your substantive group and level and your employment status on your resume and/or application form. Also ensure that your Personal Record Identifier (PRI) is included in your application.

Various assessment tools may be used in this selection process. All communication relating to this process, including email correspondence may be used in the assessment of qualifications identified on the Statement of Merit Criteria.

Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

Candidates invited to an interview will be required to provide proof of their education credentials, in the form of a diploma or official transcript (original documents only).For candidates with an international diploma, Canadian equivalency will also be requested.

Proof of Canadian citizenship or permanent residence will be required.

Unless a request for accommodation has been made, we will only accept on-line applications received via the jobs.gc.ca site. Persons with disabilities or residing in locations that prevent them from applying on-line are asked to contact 1-800-645-5605.

Candidates are strongly encouraged to check their email on a regular basis. It is your responsibility to inform us at all times of any changes regarding your contact information.

Depending on the number of applicants, volume management strategies such as random selection, top-down approach and/or establishing cut-off scores to determine who will continue in the staffing process, may be used for the purpose of managing applications. Please note that although you may attain the established pass mark on any of the assessments used in this staffing process, management may decide to use a higher cut off score.

Please add to your safe list or as needed to ensure this email will be received in your inbox versus junk/bulk/spam mail.

Preference

Preference will be given to veterans first and then to Canadian citizens and permanent residents, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.