Business Intelligence Analysts

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

(*) These positions are classified at the RE-04 and RE-05 group and levels which are equivalent to EC-05, EC-06, CS-02 and CS-03.

Rate of Pay for RE-04: $72,700 - $93,600
Rate of Pay for RE-05: $91,500 - $116,200

Duties

The roles associated to these positions includes developing, implementing, and supporting Business Intelligence applications to meet operational objectives in support of FCAC’s mandate, and the vision and objectives set out in the IM/IT Strategic Plan. You would play an important role in understanding and articulating users’ information requirements, in liaising with external consultants, in delivering data and analytic solutions, in assessing system deliverables, and in facilitating or participating in knowledge transfer between users, technical staff and external consultants.

The Business Intelligence Analyst (RE-04) will act as the developer and administrator of selected applications and will actively participate in the development projects associated with them. They will also provide technical consultation to business clients in the areas of analytics, reporting, dashboarding, and data integrity.

The Senior Business Intelligence Analyst (RE-05) will carry out the same duty as the RE-04 Analyst, but with more complex requirements. The Senior Business Intelligence Analyst also leads the design, development, establishment and maintenance of Data and Business Intelligence strategies, architecture, and operations. In addition, the Senior Business Intelligence Analyst provides coaching and mentoring to subordinate resources such as the RE-04 Analyst.

Work environment

Located in downtown Ottawa, and fully equipped to work virtually, FCAC is a separate agency subject to the Public Service Employment Act (PSEA). We offer the same pension and benefits plans as the core public administration. In addition you will benefit from a minimum of four (4) weeks of vacation leave per year, earn a competitive salary, and be eligible for performance pay. We are also pleased to offer flexible work arrangements including telework, and a broad range of learning opportunities to help you grow and contribute your best. We have our own unique classification system (RE and REX) with relevant equivalences to the group and levels noted above. Our people are our strength and we're looking for highly engaged and talented individuals to join our team!

Intent of the process

The intent of this process is to staff positions with the designated workspace of Ottawa. 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: 2

Information you must provide

Your résumé.

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

Candidates must use concrete and detailed examples of how they meet the education, experience, and asset experience in their résumé. Unless indicated otherwise, merit criteria applies to both the RE-04 and RE-05 positions.

Education:
Successful completion of an acceptable post-secondary educational program in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Degree equivalency

Experience required for the RE-04 only:
- Experience using Structured Query Language (SQL);
- Experience analyzing and transforming functional requirements and change requests into technical
specifications;
- Experience with Business Intelligence (BI) and Data Analytics, including data mart, reporting models
(E.g., cubes, tabular models, datasets in Power BI), and visualization (i.e., reports and dashboards);
and
- Experience in providing application support to clients and end users of data solutions.

Experience required for the RE-05 only:
- Experience using SQL Server Integration Services (SSIS) or Azure Data Factory;
- Experience performing data modelling for transactional databases, data warehouse or data marts;
- Significant experience* using Structured Query Language (SQL);
- Significant experience* mapping, developing and loading data warehouse systems;
- Significant experience* analyzing and transforming functional requirements and change requests into technical specifications;
- Significant experience* with Business Intelligence (BI) and Data Analytics, including data mart, reporting models (E.g., cubes, tabular models, datasets in Power BI), and visualization (i.e., reports and dashboards);
- Experience in providing application support to clients and end users of data solutions; and
- Experience assisting in the development of project plans, assigning appropriate technical resources, and cost estimation.

* 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.
- Microsoft Certification on cloud technologies relating to data analysis, data engineering and data science.
- Microsoft Certification on non-BI cloud technologies and platforms such as Dynamics 365, Power Apps, Power Automate, and Azure services that are not relating directly to data and analytics.
- Experience using SQL Server Integration Services (SSIS) or Azure Data Factory.
- Experience developing and loading data warehouse systems.
- Experience working with REST API or OData in data solutions.
- Experience of using ERWin as a data modelling tool.
- Experience on non-BI 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 activities.
- Experience supervising a technical team via formal reporting structure.
- Experience providing functional leadership to a technical team in a matrix environment.
- Experience providing functional or hierarchical leadership to employees or managing the work of contractors.
- Advance knowledge of data management and data governance principles and best practice.

Willingness and ability to work overtime, sometimes with short notice.

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

Various language requirements
Bilingual Imperative CBC / CBC
Bilingual Imperative BBB / BBB
English Essential

Information on language requirements

Second Language Writing Skills Self-Assessment
In order to help you decide if you should apply to a bilingual position, an optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.

For more information, please consult:
Unsupervised Internet Test of Second Language Writing Skills

Knowledge required for the RE-04 only:
- Knowledge of Microsoft Cloud technologies relating to data analysis and data engineering.
- Knowledge of relational database design principles and SQL scription languages such as T-SQL.
- Knowledge of Agile Software Development Lifecycle, and that applies to Data Analysis and Business Intelligence initiatives.

Knowledge required for the RE-05 only:
- Knowledge of Microsoft Cloud technologies relating to data analysis, and data science.
- Advanced knowledge of Microsoft Cloud technologies relating to data engineering.
- Advanced knowledge of data modelling, relational database design principles and SQL scription languages such as T-SQL.
- Advanced Knowledge of Agile Software Development Lifecycle, and that applies to Data Analysis and Business Intelligence initiatives.

Competencies required for the RE-04 only:
- Demonstrating integrity and respect
- Thinking things through
- Working effectively with others
- Showing initiative and being action oriented
- Autonomy
- Digital literacy and competency

Competencies required for the RE-05 only:
- Create Vision and Strategy
- Mobilize People
- Uphold Integrity and Respect
- Collaborate with partners and stakeholders
- Promote Innovation and Guide Change
- Achieve Results
- Autonomy
- Digital Literacy and competency

Abilities:
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)

Selection may be limited to members of the following Employment Equity groups: Aboriginal persons, persons with disabilities, visible minorities

Information on employment equity

Conditions of employment

Secret security clearance

All employees of the Financial Consumer Agency of Canada (FCAC) are required to be fully vaccinated against COVID-19 and attest to their vaccination status unless accommodated based on a medical contraindication, religion, or another prohibited ground for discrimination as defined under the Canadian Human Rights Act.

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

On October 6, 2021, the Government of Canada announced details of its plans to require vaccination across the federal public service and asked separate agencies to implement policies mirroring the requirements announced for the rest of the public service.

As per the new FCAC Policy on COVID-19 Vaccination, employees must attest to their vaccination status. The requirement for employees to be fully vaccinated applies whether they are teleworking, working remotely or working on-site. This is a condition of employment and it applies to indeterminate (permanent), determinate (term), casual, and student hiring. Should you reach the point in the selection process where it is necessary to verify terms and conditions of employment then the hiring manager or a human resources representative will contact you in order to complete an attestation.

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

Unless an accommodation has been granted, applications must be submitted through the jobs.gc.ca site. There are some benefits associated with applying on-line: Applicants can create a profile and retrieve stored application(s) (personal information, covering letter and résumé) previously submitted and modify them, if necessary, before submitting the application. Applicants can modify their application/résumé at any time BEFORE the closing date indicated on the job advertisement.

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.