Job Description

Competition number: C0823-0234

Location of position: Ottawa, Ontario

Job status: Determinate (Anticipatory)

Number of positions being staffed: 1

Classification: GR-06

Salary: $68,575 to $82,622 per year

Language requirements:

Various languages

Open To:

Persons legally entitled to work in Canada and residing in the National Capital Region (Preference will be given to Canadian citizens and permanent residents.)

Closing date: September 18, 2023

Special posting considerations: The intent of this advertisement is to establish a pool of partially qualified and qualified candidates that may be used to staff similar positions on a determinate or indeterminate status within NSERC or SSHRC, following the results of the competition.

A written examination and an interview will be administered.
If you are looking for a dynamic and challenging work environment with a fun, diverse and dedicated team, the Social Sciences and Humanities Research Council (SSHRC) and Natural Science and Engineering Research Council\'s (NSERC) is the place for you! We are growing our team and looking for dedicated professionals.

Visit our career page at www.sshrc-crsh.gc.ca or www.nserc-crsng.gc.ca to learn more about SSHRC and NSERC and meet some of our employees. In addition to the excellent benefits provided by the federal government, you will enjoy work-life balance with offices in the heart of Ottawa\'s new and upcoming Zibi business district.

• We currently follow a hybrid working model. Our hybrid work model facilitates flexibility, collaboration, and work-life balance.

Job Summary

Provide business intelligence software solutions to the Research Councils and to the Information and Innovation Solutions Division (IISD) by participating in the requirements gathering, analysis, design, development, and implementation of flexible reporting solutions that satisfy the informational requirements of both the internal and external client communities.

Statement of Qualifications

Education

Successful completion of two (2) years of an acceptable post-secondary educational program in computer science, information technology or in a field of study relevant to the position being staffed, or an acceptable combination of education, training, or experience.

Experience

Experience in using complex relational databases;
Experience managing deliverables within a multidisciplinary team;
Experience in the field of Business Intelligence, providing operational/strategic reporting solutions and maintaining semantic layers considered an asset;
Experience in participating in the administration of a Business Intelligence system considered an asset.

Knowledge

Knowledge of current and emerging trends related to Business Intelligence;
Knowledge of Business Intelligence Reporting platforms such as SAP Business Objects, SQL Server Reporting Services and Power BI;
Knowledge of database management systems such as SQL Server and Sybase.;
Strong knowledge of SQL data definition language (DDL) and data manipulation language (DML);
Knowledge of SQL performance tuning;
Knowledge of project management practices and principles;
Knowledge of computer science theories, engineering methods and principles, in order design, develop, test, and, implement internal and/or externally focused Business Intelligence solutions utilizing information technology.

Personal Suitability

Strong interpersonal skills
Team oriented
Client Services oriented

Competencies

Strong communication both written and spoken
Prioritize and multitasking abilities
Plan and organizing resources
Conflict management
Translate business needs into analytics/reporting requirements

Condition(s) of Employment

Security Clearance: Reliability
Willingness to keep skills current and to learn new technology

We are committed to inclusive, barrier-free recruitment processes and work environments. If contacted regarding this competition, please advise us in a timely fashion, of any accommodation assistance you require to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.

Organizational Needs

Selection may be limited to members of the following Employment Equity groups: Indigenous Peoples, persons with disabilities, visible minorities, women.

Acknowledgment of receipt of applications will be sent. Only those selected for an exam/interview will be contacted.

If you require additional information on the position, please contact us at .

We thank all of you for your interest in this employment opportunity.

Social Sciences and Humanities Research Council