Programmer 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

IITB is a national organization, with a wide variety of work that can be performed regardless of geographic location. However, certain positions may require a physical presence at a specific location.

IITB’s Hub locations outside of the NCR are located in: St-John’s, Dartmouth, Charlottetown, Bathurst, Fredericton, Miramichi, Moncton, Saint John, Boucherville, Jonquière, Laval, Montréal, Québec, Shawinigan, Belleville, Chatham, Cornwall, London, Toronto, Mississauga, Windsor, Vaughan, Winnipeg, Regina, Edmonton, Calgary and Vancouver.

We strongly encourage applicants to submit their applications online.

Following are some of the benefits associated with applying on-line:
• Applicants can create and manage their accounts and apply to job opportunities as long as an internet connection is available.
• 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/resume at any time BEFORE the closing date indicated on the job advertisement.

Should you be unable to apply on-line onjobs.gc.ca, please submit your application,
quoting the Selection Process Number, to the application contact listed on the poster on or before the closing date.

By answering online screening questions, it is your responsibility, as a candidate, to provide CONCRETE AND DETAILED EXAMPLES to clearly demonstrate how you meet the education, experience and competencies requirements listed in the Essential Qualifications and Other Qualifications sections.

Your answers must include where and how you obtained the required education or experience, as well as the period(s) in which you performed the functions of the position(s). Your answer must include the date format of Month-Year to Month-Year. Failure to provide the above information in the format required may result in your application being rejected from the process.

Information on your described education, experience, etc. provided in the screening
questions should be supported by your resume.

You may save your application as a draft and return to it at a later date. Your application
must be completed and submitted in order to be considered. Partially completed applications, or those in draft cannot be considered. You can make modifications to your submitted application at any time, but once your application has been selected for screening, you will no longer be able to make modifications and your submission will be considered final.

Duties

A Business Intelligence/Advanced Analytics Developer/Analyst hired by Employment and Social Development Canada (ESDC) will be working with Program Areas which strive to improve the standard of living and quality of life for all Canadians.

Business Intelligence/Advanced Analytics Developer/Analyst are IT professionals who play the vital role of integrating and managing a variety of COTS and Open-Source Business Intelligence & Advanced Analytics software solutions. These Developer/Analysts blend the areas software development and software administration to ensure scalability, reliability and performance of software platform releases.

At ESDC Business Intelligence and Advanced Analytics software platforms are used by a range of department programs for workloads such as, machine learning, advanced statistical analysis and data visualization.

Intent of the process

Immediate need is to fill indeterminate positions within Innovation, Information and Technology Branch.

Pool of qualified candidates will also be established and could be used to staff identical or similar positions with various tenures and/or various security requirements within the Department of Employment and Social Development Canada.

Positions to be filled: 8

Information you must provide

Your résumé.

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

Stream A: ETL DEVELOPER/ANALYST
Stream B: BI/ADVANCED ANALYTIC DEVELOPER/ANALYST
Stream C: BUSINESS INTELLIGENCE

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

Notes:
1.Indeterminate period incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above, are deemed to meet the minimum education standards based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the CS group.

2.It is the recognized educational institution (e.g. community college, CÉGEP or university) that determines if the courses taken by a candidate correspond to two years of a post-secondary program at the institution.

3.At the manager's discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum post-secondary education stated above. Whenever the minimum education is met using this alternative, it is met for the specific position only and must be re-assessed for other positions for which this alternative has been specified by the manager.

Degree equivalency

EXPERIENCE
STREAM A: ETL DEVELOPER / ANALYST
EX1- Recent* and significant** experience developing applications using Oracle 11g or higher.
EX2- Recent* and significant** experience in developing and maintaining PL/SQL or SQL database scripts.
EX3- Experience in dealing with clients or external stakeholders in support of IM/IT Systems.
EX4- Experience in providing IT support to clients.
EX5- Experience with Data warehouses.
EX6- Experience performance tuning SQL scripts.
EX7- Experience with DataMart and Data Warehouse.
EX8- Experience in Data Validation, Data Mapping, Data Migration.
EX9- Experience with dimensional modeling.

*Recent is defined as experience normally acquired within the last three (3) years.
** Significant experience is defined as depth and breadth of experience normally associated with the performance of those duties on a regular, full time basis for a period of approximately two (2) years.

STREAM B: BI / ADVANCED ANALYTIC DEVELOPER / ANALYST
EX1- Experience in one or more of the following:
• Experience with statistical analysis software such as but not limited SAS, IBM SPSS, IBM Cognos Analytics.
• Experience in Geomatics/GIS COTS.
• Experience with the Hadoop ecosystem (HDFS, Ranger, Yarn, Atlas, Hive, HBase etc.,).
• Experience development using open-source languages for data science such as but not limited to R, Python, Julia.
• Experience using self-service data visualization tools such as but not limited to Tableau, Microsoft PowerBI, SAS Visual Analytics.
• Experience with enterprise data governance tools such as but not limited to InfoSphere - Information Governance Catalog, Colibra.

STREAM C: BUSINESS INTELLIGENCE
EX1- Experience in one or more of the following:
• Experience in IBM Cognos 10.x and higher.
• Experience in data and database management systems with SQL language skills.
• Experience in programming and analyzing reporting packages.

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

Various language requirements
Bilingual Imperative BBB/BBB
English essential
French essential

Information on language requirements

KNOWLEDGE:
STREAM A: ETL DEVELOPER / ANALYST
K1- Knowledge of Oracle database principles.
K2- Knowledge of UNIX and/or LINUX.
K3- Knowledge of designing and developing with Extract, Transformation and Load (ETL) tools.
K4- Knowledge of designing and developing data quality, master data management or similar solutions.

STREAM C: BUSINESS INTELLIGENCE
K1- Knowledge of SQL queries.
K2- Knowledge of ETL processes/framework, and data warehousing principles.

COMPETENCIES
ALL STREAMS
C1 - Communication
C2 - Analytic Thinking
C3 - Teamwork
C4 - Client Focus
C5 - Results Orientation
C6 - Application Development/Support and Maintenance

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

ASSET QUALIFICATIONS - EXPERIENCE
ALL STREAMS
AEX1- Recent* Experience in PL/SQL (Oracle) or in T-SQL (MS SQL Server) or PostgreSQL.
AEX2- Experience in Unix/Linux scripting (bash, sh, ksh, tsch, etc).
AEX3- Experience with any of the following: TOAD, SQL Developer, SQL *Plus or Team Foundation Server (TFS).
AEX4- Experience with PowerShell scripting.

ORGANIZATIONAL NEEDS
Employment and Social Development Canada is committed to employment equity (EE). In order to achieve a representative workforce, selection may be based on qualified candidates self-declaring as being a member of one or more of the following EE groups: Aboriginal peoples, persons with disabilities, women and visible minorities.

OPERATIONAL REQUIREMENTS
• Willingness to work overtime, often on short notice.

CONDITIONS OF EMPLOYMENT
• Reliability Status security clearance
• 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

***************************
Application process
***************************
We strongly encourage applicants to submit their applications online.

Following are some of the benefits associated with applying on-line:
• Applicants can create and manage their accounts and apply to job opportunities as long as an internet connection is available.
• 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/resume at any time BEFORE the closing date indicated on the job advertisement.

Should you be unable to apply on-line onjobs.gc.ca, please submit your application,
quoting the Selection Process Number, to the application contact listed on the poster on or before the closing date.

By answering online screening questions, it is your responsibility, as a candidate, to provide CONCRETE AND DETAILED EXAMPLES to clearly demonstrate how you meet the education, experience and competencies requirements listed in the Essential Qualifications and Other Qualifications sections.

Your answers must include where and how you obtained the required education or experience, as well as the period(s) in which you performed the functions of the position(s). Your answer must include the date format of Month-Year to Month-Year. Failure to provide the above information in the format required may result in your application being rejected from the process.

Information on your described education, experience, etc. provided in the screening
questions should be supported by your resume.

You may save your application as a draft and return to it at a later date. Your application
must be completed and submitted in order to be considered. Partially completed applications, or those in draft cannot be considered. You can make modifications to your submitted application at any time, but once your application has been selected for screening, you will no longer be able to make modifications and your submission will be considered final.

**************************
Assessment
***************************
A variety of assessment tools may be used in the assessment of candidates, such as: written test, practical test, situational exercise, oral interview, simulation, presentation, role play, work samples, performance appraisals, reference checks, and/or assessment board member personal/direct knowledge of candidates’ qualifications. Some assessment tools may be administered electronically, others, in-person.

Please note that asset qualifications, top-down and/or random selection may be used to identify which applications will be given further consideration.

Candidates must meet the essential qualifications to be appointed to a position. The
essential qualifications that are listed in the statement of merit criteria are mandatory.
Applicants may be appointed to the position even though he/she does not meet any or all of the asset qualifications. However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed. In the event that there are as many applicants who meet the essential qualifications as there are vacancies, the manager may decide not to assess some or all of the asset qualifications.

Pass marks will be established for each qualification. However, achieving the pass mark
is not a guarantee of an appointment or that candidates will be put through the next stages of the assessment process. A cut-off score or a top-down approach may be used at any step if there is a sufficient number of candidates to meet immediate and anticipated staffing needs.

All information obtained throughout the selection process, from the time of application
to close of process, may be used to evaluate the candidates.

***************************
Travel status - Travel costs
***************************
Please note you will not be considered to be in travel status or on government business and that travel costs will not be reimbursed.
Consequently, you will be responsible for travel costs.



***************************
Proof of education
***************************
You must provide proof of your education credentials.

Candidates with foreign education credentials are required to provide proof of Canadian
equivalency.

Foreign certificates and/or diplomas must be assessed against Canadian education standards. The federal public service will accept any Foreign Educational Credentials as long as they are deemed comparable to Canadian standards, determined by a recognized credential assessment service.

The Canadian Information Centre for International Credentials (CICIC) assists
persons who wish to obtain an assessment of their educational, professional, and occupational credentials by referring them to the appropriate organizations.

You can access the CICIC website at: https://www.cicic.ca/. This website provides
links to a number of Canadian organizations that provide equivalency assessments.

Original diplomas, degrees or certified transcripts may be required and must be
presented upon request. Failure to produce required documents will result in your
application not being considered.

***************************
Communication
***************************
Acknowledgment of receipt of applications will not be sent.

PLEASE NOTE: Our intention is to communicate with applicants by e-mail for
screening/assessment purposes. It is imperative that you provide a current email address that accepts e-mail from unknown users (some email systems block these types of email). Candidates are strongly encouraged to check their email on a regular basis. It is entirely your responsibility to inform us at all times of any changes regarding your contact information.

***************************
Official languages- Bilingual positions
***************************
Persons are entitled to participate in the appointment process in the official language of
their choice. Applicants will be asked to indicate in their on-line application their preferred official language for each of the following: a) correspondence, b) written exam, and c) interview.

To be considered for a Bilingual Imperative position, you must be willing to undergo Second Language Evaluation testing OR you must already have Second Language Evaluation results (proof will be required).

If you have undertaken Second Language Evaluation by the Public Service Commission, you can obtain a copy of the SLE results, by requesting it at the following website: https://www.canada.ca/en/public-servicecommission/
corporate/about-us/contactus. html#sle.

For more information on SLE, visit the following web-site: https://www.canada.ca/en/publicservice-
commission/services/second-languagetesting- public-service.html

An optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.
https://www.canada.ca/en/public-servicecommission/ services/second-language-testingpublic-service/self-assessment-tests.html

***************************
Other informations
***************************
An assignment, secondment or an acting appointment is a temporary resourcing option.
The approval of your substantive supervisor will be required before an offer can be made.

***************************
What do you need to know about diversity and accommodation?
***************************
Employment and Social Development Canada is committed to employment equity (EE). In order to achieve a representative workforce, selection may be based on qualified candidates selfdeclaring as being a member of one or more of the following EE groups: Aboriginal peoples, persons with disabilities, women and visible minorities.

If you are selected for further consideration, please advise the person who will contact you of any accommodations you may require during the selection process.

The Public Service of Canada is committed to building a skilled, diverse workforce reflective of Canadian society. As a result, it promotes employment equity and encourages candidates to indicate voluntarily on their application if they are a woman, an Aboriginal person, a person with a disability or a member of a visible minority group.

The Public Service of Canada is also committed to developing inclusive, barrier-free selection processes and work environments. If contacted in relation to a job opportunity or testing, you should advise the Public Service Commission or the departmental official in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.

Preference

Preference will be given to veterans and to Canadian citizens, in that order, 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.