Senior Advisor (Data Services) *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 profiles (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: Number to be determined

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 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

EXPERIENCE:

Minimum of eight (8) years of experience in the IM/IT field.

Minimum of five (5) years of experience working in a data related capacity to support, design, develop, and maintain IT enabled solutions that meet business requirements.

Significant* experience designing, developing and maintaining data models (logical and physical) that integrate data from multiple sources.

Significant* experience in meeting with clients to review their data-related requirements and the resulting implications on their business.

Significant* experience in providing recommendations to senior management (Director and above) in one or more of the following areas: data modelling, data management, data architecture, data warehousing, or data analytics.

Experience establishing standards and best practices in at least one of the following areas: data modelling, data management, data architecture, data warehousing or data analytics.

Note:

*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.

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

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

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:

CDMP – Certified Data Management Professional

CIMP – Certified Information Management Professional

CBIP – Certified Business Intelligence Professional

CAP – Certified Analytics Professional

CBAP – Certified Business Analyst Professional

TOGAF – The Open Group Architecture Framework

EXPERIENCE:

Experience developing enterprise data models.

Experience developing logical and physical data models to support an enterprise data warehouse.

Experience working with ERWIN to develop and maintain logical and physical data models.

Experience in data management working to design, develop, and maintain IT enabled solutions that meet organizational business needs.

Experience in data architecture working to design, develop, and maintain IT enabled solutions that meet organizational business needs.

Experience working within the discipline of enterprise architecture in one or more of the following architecture domains: business architecture, data architecture, application architecture, or technology architecture.

Experience conducting data analysis using tools such as PL/SQL Developer.

Experience using automated tools to profile, assess and measure data quality.

Experience developing ETL specifications to support ETL development.

Experience validating ETL specifications to support ETL development.

Experience leading or managing an activity or initiative to implement data management methodologies, standards and best practices.

Experience working on Business Intelligence (BI) or analytics projects or activities.

Experience working on GIS projects or activities.

Experience working on data visualization projects, activities or initiatives.

Experience working to support data discovery.

Experience working to design, develop or support an enterprise data warehouse environment.

Degree equivalency

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

English or French

Information on language requirements

KNOWLEDGE:

Knowledge of trends and best practices that affect the management and delivery of IM/IT services.

Knowledge of best practices and industry standards regarding data modelling.

Knowledge of best practices and industry standards regarding data management.

ABILITIES:

Ability to analyze complex issues, formulate options/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.

Ability to develop and deliver briefing material, such as briefing notes and presentations.

PERSONAL SUITABILITIES:

Integrity and Respect.

Results Oriented.

Initiative.

Judgment.

Interpersonal Relationships.

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

CURRENT AND/OR FUTURE ORGANIZATIONAL NEEDS
( Not essential, but preference may be given to candidates who possess the 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

A written examination may be administered.

An interview may be administered.

Reference checks may be sought.

You must provide proof of your education credentials.

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

Please note that asset qualifications may be used at the screening stage or any stage during the process.

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

PLEASE NOTE: For this selection process, our intention is to communicate with applicants by e-mail for screening/assessment purposes (including issuing screening results, and sending invitations for written tests and interviews). Applicants who apply to this selection process must include in their application a valid e-mail address and make sure this address is functional at all times and accepts messages from unknown users.

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.