IT Technical Advisor, Business Intelligence Architect

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

❗❗𝗩𝗘𝗥𝗬 𝗜𝗠𝗣𝗢𝗥𝗧𝗔𝗡𝗧 𝗡𝗢𝗧𝗘: It is the responsibility of the candidate to clearly outline that they meet each of the screening criteria (i.e. 𝗘𝗱𝘂𝗰𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 𝗤𝘂𝗮𝗹𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀, 𝗯𝗼𝘁𝗵 𝗘𝘀𝘀𝗲𝗻𝘁𝗶𝗮𝗹 𝗮𝗻𝗱 𝗔𝘀𝘀𝗲𝘁𝘀). Please note that it is not sufficient to only state that the requirement is met or to provide a listing of current responsibilities, rather the candidate must provide concrete examples that illustrate how they meet the requirement. Failure to do so could result in the application being rejected from the process.

⇒ The screening questions will be used as the primary tool in the screening process. The résumé may be used to substantiate the information provided. The board members cannot make any assumptions about the candidate's experience and will not contact candidates for additional, or potentially missing information.

Duties

The architect is part of the Microsoft Power BI Centre of Excellence under the Data Warehouse Services (DWS) team.

The architect will work with users, developers, data modellers, DBAs and consultants in order to maintain an efficient reporting system running on SSAS Tabular and Power BI Report Server.

DWS will be migrating their data marts to the Microsoft Azure Cloud and DWS will be leveraging Microsoft Fabric in the near future to improve their analytics.

The architect will also advise on the methods that can be used to efficiently transfer data from on premise sources to the Data Lake and other databases in the Cloud.

Their responsibilities include:

• Training and advising users on developing dashboards with Power BI Desktop;
• Updating Power BI Report Server;
• Liaising with data modellers regarding modelling data in Power BI Desktop and SSAS Tabular;
• Writing and/or updating Authority to Operate (ATO) documents such as the Concept of Operations (CONOPS) and Standard Operating Procedures (SOP) documents.

Work environment

⭐ About the Correctional Service of Canada (CSC):

The Correctional Service of Canada (CSC) contributes to public safety by actively encouraging and assisting offenders to become law-abiding citizens, while exercising reasonable, safe, secure and humane control.

By joining CSC, you will be part of an engaged and high-performing workforce that takes pride in changing lives and protecting Canadians on a daily basis.

💻 Learn more about us: https://www.csc-scc.gc.ca/003/001/003001-0008-en.shtml
👉 Based on Treasury Board's Direction on prescribed presence in the workplace, CSC is transitioning to a hybrid work model which will allow most employees the opportunity to both telework and work from the office location, subject to operational requirements. When answering the application question, please only select the cities from which you are willing to physically work.

Intent of the process

A partially or fully qualified pool of candidates may be established to staff similar positions within Correctional Service Canada with various tenures, linguistic profiles and/or operational requirements. The pool may be used to staff similar positions at various locations across Canada and may be shared with other government departments.

Positions to be filled: 1

Information you must provide

Your résumé.

Contact information for 2 references.

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

EDUCATION
Graduation from a two-year program of study from a recognized post-secondary institution with acceptable specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Notes
An acceptable combination of education, training and/or experience, that is comparable to a degree from a recognized post-secondary institution with specialization relevant to the work to be performed, may serve as an alternative to meet the minimum education standard. Whenever the minimum education standard is met through this alternative, it is met only for the position being staffed, and candidates must be re-assessed for future appointments or deployments where the manager has decided to use this alternative.

Degree equivalency

EXPERIENCE

Recent* and significant** experience providing expertise and/or leadership in the implementation, integration, maintenance, and support of Microsoft Power BI Report Server and Microsoft SSAS Tabular.

Recent* and significant** experience with analysis, design, development, implementation of complex reports & dashboards using Microsoft Power BI Desktop.

Experience developing and maintaining dimensional data models in relational databases and/or Microsoft SSAS Tabular using industry best practice.

Recent* and significant** experience with SQL.

Recent* experience using DAX and Power Query(M) languages.


* Recent is defined as performing the duties within the last five (5) years.
** Significant is defined as performing the duties for a minimum of two (2) years.

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

English essential

Information on language requirements

COMPETENCIES

Demonstrating Integrity and Respect
Effective Written Communication
Effective Oral Communication
Analytical Thinking
Teamwork
Showing Initiative and being action oriented

ABILITIES

Ability to develop reports with Microsoft Power BI Report.
Ability to develop models with Microsoft SSAS Tabular.
Ability to develop dimensional data modeling.
Ability to program with SQL.
Ability to program with DAX.
Ability to program with Power Query(M).

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

ASSET EXPERIENCE

Experience in using one or more of the following products in a production environment: Microsoft Power BI service, Azure Data Lake, Azure SQL Managed Instance, Azure Synapse, Azure Synapse Pipelines, Self-Hosted Integration Runtime (SHIR),On-Premises Data Gateway.

Experience with writing Authority to Operate (ATO) documents including Concept of Operations (CONOPS) and Standard Operation Procedures (SOP).

OPERATIONAL REQUIREMENTS
Willingness to work overtime occasionally and on short notice.

Conditions of employment

Reliability Status security clearance - Condition(s) of employment

Security clearance: Reliability

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

Candidates must clearly demonstrate in their responses that they meet the essential education and experience qualifications. It is NOT sufficient to only state that the qualifications are met or to provide a listing of current or past responsibilities. Rather you must clearly demonstrate HOW, WHEN, and WHERE the qualification was met through substantiation by examples. Information on your described skills, experience, etc. provided in the screening questions should be supported by your resume. Failure to provide sufficient information will result in the candidate being screened out and rejected from the process.

We may assess the essential and asset qualifications using interviews, written tests (take home assignments or other), references or a combination of these or other assessment methods. Other sources of information (such as performance agreements, work samples, board member knowledge, etc.) may be used to assess the criteria identified on the Statement of Merit Criteria.

Please identify clearly for which position(s) you are submitting an application.

An assignment, secondment, or acting appointment requires approval of your supervisor.

You must be able to provide proof of your education credentials.

Persons are entitled to participate in the appointment process in the official language(s) of their choice.

For this selection process, we will communicate with you by email. You must provide a valid email address to which you wish to receive communication regarding this selection process. It is your responsibility to inform of any change of address, telephone number and / or email address. You must ensure to check/view your email accounts including spam, promotion or other folders regularly as there may be a deadline for responses. Candidates who respond past the deadline risk being removed from the selection process.

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.

Contact information

Apply online