Senior Business Data Analyst

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

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

Do you like logic puzzles?

The Public Prosecution Service of Canada (PPSC) is looking for a Senior Business Data Analyst at the AS-05 level to join our guild of Data Wizards.

In our team, you would be:

• extracting and manipulating data using SQL Server
• producing data tables and graphs with MS Excel
• liaising with senior management and providing advice
• constantly learning (seriously, it never stops)

As a smaller organization with a powerful mandate, PPSC is great for “getting your name out there”. We’re also conveniently located in downtown Ottawa and within walking distance of almost everything.

If you have experience with SQL, we want to hear from you!

Intent of the process

The immediate need is to staff one (1) position for a specified period of one (1) year.

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 Public Prosecution Service of Canada.

Positions to be filled: 1

Information you must provide

Your résumé.

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

Education:
- A secondary school diploma or an acceptable combination of education, training and/or experience.

Degree equivalency

Experience:
- Recent* experience conducting research and data analysis.
- Recent* experience in developing or maintaining a database using Structured Query Language (SQL).
- Recent* experience in data manipulation activities including extracting data from a database, transforming data and producing data tables or graphs in Excel.

*Recent experience is defined as having performed the activities 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 Qualification - Education:
- Graduation with a degree from a recognized post-secondary institution with acceptable specialization in economics, sociology, statistics, or computer science.

Degree equivalency

Asset Qualifications - Experience:
- Experience scripting using Structured Query Language (SQL).
- Experience using SQL Server.

Organizational Needs:
- The organization is committed to establishing and maintaining a representative workforce. Qualified applicants who self-declare as members of a visible minority group, Indigenous peoples, persons with disabilities and/or women, may be selected for appointment to fulfill organizational needs.

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

English essential

Information on language requirements

Knowledge:
- Knowledge of programming language – SQL.

Competencies:
- Demonstrating integrity and respect
- Thinking things through
- Working effectively with others
- Showing initiative and being action-oriented
- Communications (oral and writing)

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

Asset Qualifications - Abilities:
- Ability to script using Structured Query Language (SQL).
- Ability to use SQL Server.

Operational Requirements:
- Willing and able to travel on occasion.
- Willing and able to work overtime on occasion, including on weekends and statutory holidays.

Conditions of employment

Secret security clearance

Other information

The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.

Information on employment equity

Preference

Preference will be given to veterans and to Canadian citizens, in that order, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Information on the preference to veterans

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