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

Work environment

Do you like logic puzzles?

The Public Prosecution Service of Canada (PPSC) is looking for a Senior Business Data Analyst at the EC-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 and a degree from a recognized post-secondary institution, we want to hear from you!

Positions to be filled: 1

Information you must provide

Your résumé.

A covering letter in 2,000 words (maximum)

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

Education:
Graduation with a degree from a recognized post-secondary institution with acceptable specialization in economics, sociology or statistics.

Candidates must always have a degree. The courses for the specialization must be acceptable and may have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization. The specialization may also be obtained through 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 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, Aboriginal peoples, persons with disabilities and/or women, may be selected for appointment to fulfill organizational needs.

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

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

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.