Technical Advisor **Amendment to Closing Date**

Intent of the process

A pool of partially or fully qualified candidates may be established to staff similar or identical positions at Indigenous and Northern Affairs Canada (INAC) with various linguistic profile (French essential, English Essential, Bilingual Imperative BBB/BBB,CBC/CBC, CCC/CCC) and/or requirement as well as tenures and/or the security clearance (reliability or Secret), which may vary according to the position being staffed.

“The pool could be used to offer acting appointments under exceptional circumstances in order to protect employee’s indeterminate status.”

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:

Successful completion of two (2) 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 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 education 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 in which the manager has specified this alternative.

Degree equivalency

EXPERIENCES:

Minimum of five (5) years of experience in the IM/IT field.

Significant* experience in developing or maintaining or implementing Business Intelligence (BI) or analytics solutions.

Recent** experience doing options analysis and making recommendations within a BI, analytics or enterprise data warehouse environment.

Experience leading or providing key technical expertise to a technology installation or upgrading projects within a BI, analytics or enterprise data warehouse environment.

Recent** experience in developing IT project work estimates and development schedules.

Recent** experience in working with service providers to ensure the on-going maintenance or sustainability of an IT Infrastructure (hardware or software) for a BI or analytics environment including, but not limited to, DBAs, vendors or Shared Services Canada.

Experience in researching new technologies and providing recommendations to management and clients.

NOTES:

1. Significant experience is understood to mean the depth and breadth of experience normally associated with having performed a broad range of complex activities related to this task, which are normally acquired over a period of three (3) years.

2. Recent experience is understood to mean within the last five (5) years.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

ASSET QUALIFICATIONS

EDUCATION:

University or College degree or certification in Computer Science, Information Technology, Information Management or another specialty relevant to the position to be staffed.

OCCUPATIONAL CERTIFICATION:

CAP – Certified Analytics Professional.
CBAP – Certified Business Analyst Professional.
CBIP – Certified Business Intelligence Professional.
CDMP – Certified Data Management Professional.
CIMP – Certified Information Management Professional.
Professional Certification Program from IBM.
TOGAF – The Open Group Architecture Framework.

Degree equivalency

EXPERIENCES:

Experience in preparing technical documentation (e.g. software and architecture documents, User guides, etc.).

Experience working as part of a BI reporting team with an enterprise data warehouse.

Experience installing and configuring Cognos products.

Hands-on experience in developing BI solutions using Cognos 11/analytics, Business Intelligence suite of products.

Experience in developing active reports in Cognos BI suite of products.

Experience in developing dashboards that integrate data from various sources using Cognos 11/analytics.

Experience developing data visualization reports using Cognos 11/ analytics.

Experience in developing IM/IT plans or architecture components in alignment with business goals and strategies.

Experience in maintenance or application development using Oracle 11g.

Experience in using IBM InfoSphere suite of products, such as DataStage for Extract, Transform, and Load (ETL), to develop BI solutions.

Experience managing or developing solutions in an SAP Business Objects Enterprise suite of products.

Experience in the configuration, administration, and maintenance of SAP Business Objects Enterprise suite of products.

Experience as the senior resource responsible for the maintenance of IT infrastructure, including but not limited to hardware and software to support a Business Intelligence (BI) service.

Experience working to up-grade an IT infrastructure.

Experience working with Supervisors (Manager, Director and above) in planning the on-going sustainability of an IT infrastructure.

Experience in verifying licence allocations and usage, including the review and approval of annual support and maintenance contracts.

Experience working with IT Security to ensure that an IT infrastructure meets organizational security standards.

Experience developing reporting solutions against SAP financial.

Experience developing reporting solutions against PeopleSoft.

Experience working on IBM Cognos development projects.

Experience working with SAP Business Objects Enterprise reporting solutions.

Experience working with Crystal Reports development projects.

Experience working with geo-spatial and mapping reporting solutions, including ESRI Maps for Cognos.

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

Various language requirements

Information on language requirements

KNOWLEDGE:

Knowledge of IT best practices affecting the domain of business intelligence.

Knowledge of hardware & software capabilities and techniques used in implementing Cognos Business Intelligence solutions.

Knowledge of System Development Life Cycle (SDLC).

Knowledge of IM/IT methodologies, best practices, and trends.

ABILITIES:

Ability to analyze complex issues, formulate options or solutions, and make recommendations.

Ability to communicate effectively orally.

Ability to communicate effectively in writing.

Ability to plan, prioritize and organize workload effectively to meet deliverables on time.

Ability to negotiate and influence.

COMPETENCIES:

Integrity and Respect.
Results Oriented.
Initiative.
Judgement.
Interpersonal Relations.

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

CURRENT AND/OR FUTURE ORGANIZATIONAL NEEDS

Indigenous and Northern Affairs Canada is committed to having a skilled and diversified workforce representative of the population we serve. In support of our strategy to achieve our employment equity goals, selection may be limited to candidates self-identifying as belonging to one of the following Employment Equity groups: Women, Aboriginal Persons, Visible Minorities, and Persons with Disability.

OPERATIONAL REQUIREMENTS:

Willing and able to travel, on occasion.
Willing and able to work overtime, if required.

Conditions of employment

Reliability Status security clearance

Other information

(1) Reference checks may be sought.

(2) An interview may be administered.

(3) A test may be administered.

(4) You must provide proof of your education credentials.

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

(6) Communication for this process will be sent via email. It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required.

(7) Acknowledgment of receipt of applications will not be sent; we will contact candidates when the screening process is completed.

(8) Please note that asset qualifications may be used at the screening stage or any stage during the 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.

Information on the preference to veterans

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