Senior Business Data Analyst - AMENDED

Update: Hello,

Please note that we have extended the application period to next Monday, October 8th.

We are looking forward to hearing from you and have the opportunity to consider your application and determine how you can contribute to the success of our team.

Best of luck,
The hiring team

Important messages

INSTRUCTIONS FOR THE SCREENING QUESTIONS:

In addition to your application, you are required to answer screening questions in order to clearly demonstrate with concrete examples how you meet each essential education and experience qualification, as well as any asset qualifications. Resumes will only be used as a secondary source to validate the information provided in your answers to the screening questions. Failure to clearly demonstrate how you meet the essential screening criteria will result in the rejection of your application. Candidates will not be solicited for incomplete or missing information.

Please note that responses such as "See CV" or "Refer to résumé" are unacceptable responses to any of the questions. Failure to provide sufficient information will result in the rejection of your application.

Work environment

About PBIIMS

What do Albert Einstein and Thomas Jefferson have in common?
Both have been the subject of work at the Patent Branch!

Would you like to be part of a team where your work will support creativity, improve innovation, and contribute to Canada’s economic success? Would you enjoy working in a fast-paced environment filled with new and exciting challenges?

Then please consider joining Patent Business Information & Information Management (PBIIMS). We are a small, flexible group of highly trained and motivated professionals. PBIIMS is tasked with providing a multitude of services to the clients of the department of Business and Strategic Affairs for the Canadian Intellectual Property Office (CIPO).

We do:
- Data analysis and data mining of huge databases;
- Scripting and coding of desktop applications;
- Ad-hoc reporting and system troubleshooting.

Why should you consider working with us?
- Your contributions can have far-reaching impact;
- Many opportunities for continuous learning and growing your skillset;
- Be part of a nurturing environment for new ideas and solutions; and
- Our team also loves doughnuts and other sweets…

Don't wait any longer and submit your application!

Intent of the process

The intent of this process is to staff 2 positions, one for a determinate period and one for an indeterminate period.

A pool of partially or fully qualified candidates will be created and may be used to staff similar positions at the AS-05 group and level with various tenures and various linguistic profiles within Innovation, Science and Economic Development Canada.

Positions to be filled: 2

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
A secondary school diploma

Degree equivalency

EXPERIENCE
E1: Significant* experience in developing designs in order to capture and translate business requirements into applications, interfaces or work tools.
E2: Significant* and recent** experience in the development of comprehensive documentation such as user manuals, technical manual or training material.
E3: Significant* and recent** experience in complex SQL (Structured Query Language) techniques
E4: Significant* and recent** experience in VBA, VBS, and XML languages

*Significant experience refers to the depth and breadth of experience normally associated with having performed a broad range of various, complex related activities as the MAIN function.
** "Recent" is defined as acquired within the last five (5) years.

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

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

Information on language requirements

KNOWLEDGE
K1: Knowledge of SQL (Structured Query Language) techniques.
K2: Knowledge of VBA, VBS or XML languages.

ABILITIES
A1: Ability to work on multiple projects simultaneously.
A2: Ability to communicate effectively orally.
A3: Ability to communicate effectively in writing.

PERSONAL SUITABILITY
PS1: Effective interpersonal skills;
PS2: Judgment;
PS3: Autonomous;
PS4: Client service orientation.

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

EDUCATION
Successful completion of a post-secondary program with specialization in Computer Sciences and/or Information Technology

Degree equivalency

EXPERIENCE
AE1: Experience using IBM Cognos 8 and up to build or validate reports
AE2: Experience in programming using one or more of the following languages: VB.NET, JavaScript
AE3: Experience creating tables, databases, forms, macros and reports using MS Access

OPERATIONAL REQUIREMENT
Ability and willingness to work overtime occasionally.

Conditions of employment

Reliability Status security clearance

Other information

1) Only online applications will be accepted. All job applications must therefore be submitted through the Public Service Resourcing System.

2) You must provide proof of your education credentials.

3) Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

4) Acknowledgment of receipt of applications will not be sent. Please note that we will only contact candidates who meet the education and the experience criteria once the screening process is completed.

5) Our intention is to communicate with the candidates by email. Candidates who apply to this selection process must include in their application a valid email address and make sure that this address is functional at all times and accepts messages from unknown users (some email systems block these types of email).

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.