Systems Analyst/ Applications Development (anticipatory)

Important messages

When you apply to this selection process, you are not applying for a specific job, but to an inventory for future vacancies. As positions become available, applicants who meet the qualifications may be contacted for further assessment.

Positions to be filled: 1

Information you must provide

Your résumé.

You must meet all essential qualifications in order to be appointed to the position. Other qualifications may be a deciding factor in choosing the person to be appointed. Some essential and other qualifications will be assessed through your application. It is your responsibility to provide appropriate examples that illustrate how you meet each qualification. Failing to do so could result in your application being rejected.

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

Education

Graduation with a degree from a recognized post-secondary institution with acceptable specialization in Computer Science, Information Technology, or a related IT field, or an acceptable combination of education and relevant experience in IT.

Degree equivalency

Experience

EX1 – Extensive* experience working collaboratively with multi-disciplinary teams on IM/IT projects.

EX2 – Extensive* experience data management and SAS programming experience performing all the following tasks:

- Oversee systematic importation of data from various external sources to SAS format;
- Creation and management of SAS data resources;
- Developing methods and processes to ensure data quality and integrity ;
- Use of SAS to manipulate data into formats required for analysis using Sort, Merge, Summary and other SAS procedures;
- Data modelling and data table relationships;
- Manipulation of large datasets efficiently;
- Production of comprehensive documentation of data resources for use by both programmers and analysts;
- Development of analysis methodology for economic research;
- Performance of data analysis for economic research;
- Export of data from SAS to various external sources;
- SAS Graphics tools;
- Providing programming support and data consultation service to analysts.

* Extensive means the depth and breadth of experience normally associated with having performed a broad range of complex related activities for a minimum of three (3) years within the last (5) years.

EX3 – Experience in troubleshooting and resolving technical issues related to data sources, data models and structure, data analysis, programming.

EX4 – Extensive* experience writing for the purposes of preparing technical and user documentation and data analysis reports.

EX5 – Management of technical staff and consultants.

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

Bilingual - Imperative (BBB/BBB)

Information on language requirements

Knowledge

K1 – Knowledge of IT project management, which may include Project Management theory, IT trends and IT best practices.

K2 – Knowledge of trends and best practices with respect to data and database administration.

Essential Competencies

C1 – Analytical Thinking
C2 – Communication
C3 – Creative Thinking
C4 – Teamwork
C5 – Client Focus
C6 – Continuous Learning

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

Other qualifications:
Asset – Education

AED 1 – Successful completion of a university degree from a recognized university in Computer Science, Information Technology or a related IT field.

Degree equivalency

Asset – Experience:

AEX 1 – (SQL Server) Database Administration experience as pertaining to the development and maintenance of a data warehouse.

AEX 2 – Data modelling as pertaining to the development, creation and maintenance of a data warehouse or Extensive data repository used for analysis purposes.

AEX 3 – Data warehouse development and implementation experience.

AEX 4 – Business Intelligence development and implementation experience.

AEX 5 – Experience using SDLC (Systems Development Lifecycle) and Project Management methodologies.

AEX 6 – Experience with SAS ODS and up-to-date SAS Graphics tools for data presentation, SAS Enterprise Guide.

Conditions of employment

Secret security clearance

Other information

Reference checks may be sought.

An interview will be administered.

A written examination may be administered.

Candidates must meet the essential qualifications to be appointed to a position.

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

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.

Information on the preference to veterans

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