IT Technical Advisor, Business Intelligence Architect

No endorsement of any products or services is expressed or implied.IT Technical Advisor, Business Intelligence ArchitectReference number: PEN24J-023690-000080Selection process number: 2024-PEN-EA-NHQ-190736-1Correctional Service Canada - Information Management ServicesOttawa (Ontario)IT-03$99,108 to $123,137For further information on the organization, please visit Correctional Service Canada.Closing date: 10 September 2024 - 23:59, Pacific TimeWho can apply: Persons residing in Canada, and Canadian citizens and Permanent residents abroad.Apply onlineWe 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.It is the responsibility of the candidate to clearly outline that they meet each of the screening criteria. 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.DutiesThe 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 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 environmentAbout 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. 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 processA 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: 1Information you must provideContact information for 2 references.In order to be considered, your application must clearly explain how you meet the following (essential qualifications)EDUCATIONGraduation 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. 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.EXPERIENCERecent 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 experience with SQL. Recent experience using DAX and Power Query(M) languages.The following will be applied / assessed at a later date (essential for the job)COMPETENCIESDemonstrating Integrity and Respect, Effective Written Communication, Effective Oral Communication, Analytical Thinking, Teamwork, Showing Initiative and being action-oriented.ABILITIESAbility 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 EXPERIENCEExperience 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 Operating Procedures (SOP).OPERATIONAL REQUIREMENTSWillingness to work overtime occasionally and on short notice.Conditions of employmentReliability Status security clearance - Condition(s) of employmentSecurity clearance: ReliabilityOther informationThe 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. 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.PreferencePreference 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.We thank all those who apply. Only those selected for further consideration will be contacted.Contact information

#J-18808-Ljbffr