Programmer/Analyst, Application Development

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

Tips for candidates who wish to apply:
* The application process will take approximately 30 to 60 minutes to complete.
* A cover letter is not required for this selection process.
* When submitting your application, you will be asked for information about your education and experience. Some questions will prompt for “Yes/No” responses only, and other questions may also require that you provide additional details in a written text response. The system will prompt you with specific questions for each qualification, so ensure to answer the questions, if applicable.
* For this part of the screening process, resumes will only be used as a secondary source to validate the essential experience.
* Please note that written communication may also be assessed through your application submission.

Duties

We are currently looking for dynamic, dedicated, innovative and client-focused individuals to be part of the growing team of the Centre of Excellence (CoE). The team provides Reporting, Planning and Analytic tools, support and advice related to the SAP financial reporting systems as well as related services to CoE and to end users nationally.
The main duties will be to assist the team with various tasks such as:
• software upgrades
• design, build and document new BI content
• support and maintain existing BI content

Work environment

As the country’s leader for agriculture policies, services and programs, our mission is to provide leadership in the growth and development of a competitive, innovative and sustainable Canadian agriculture and agri-food sector. Working at Agriculture and Agri-Food Canada (AAFC) offers an opportunity to be part of this exciting agenda. As one of Canada’s Best Diversity Employers, AAFC is proud to celebrate our achievement in creating a diverse, respectful, and positive workplace where all employees are valued and recognized for their unique qualities, ideas, voices and perspectives.

AAFC offers great benefits, competitive salaries, retirement pension, opportunities for advancement, and so much more!

The work location for this position is in the National Capital Region, on the Central Experimental Farm, building 34 near the Carling Avenue and Maple Drive intersection.

Intent of the process

Immediate Need: Agriculture and Agri-Food Canada has an immediate need for a programmer/analyst in Ottawa to fill an English Essential position.
A pool of partially and/or fully qualified candidates may be established and may be used to staff similar positions at AAFC with various tenures as well as various linguistic requirements.

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)

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.

Degree equivalency

E1. Experience in analyzing client requirements and implementing solutions using SAP Business Intelligence applications or other similar BI tools;
E2. Experience in data analysis and developing Business Intelligence reports using SAP BI Suite or similar applications;
E3. Experience in systems analysis and design, including drafting functional requirements, technical specifications, or test specifications and recommending solutions;
E4. Experience in providing advice on Business Intelligence applications.

K1. Knowledge of a System Development Life Cycle (SDLC)
K2. Knowledge of Testing practices and procedures
K3. Knowledge and ability to apply the principles of business analysis in the planning, reengineering, requirement gathering, operations, processes and practices

C1: Analytical Thinking
C2: Client Focus
C3: Communication: Oral
C4: Communications: Written
C5: Teamwork
C6: Values and Ethics

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

Graduation with a university degree in Computer Science, Computer Engineering, or related fields

Degree equivalency

AQ1. Experience in developing scripts and reports using SAP ABAP programming language or Structured Query Language (SQL).
AQ2. Experience in Relational Database Management Systems (RDBMS)
AQ3. Experience in testing SAP software product and patch upgrades
AQ4. Experience in troubleshooting and optimizing report and database performance issues
AQ5. Experience in data warehousing and managing ETL (extract, transform, load) processes

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

Various language requirements
*English Essential
Bilingual Imperative BBB/BBB

*Immediate need

Information on language requirements

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

• Ability and willingness to work overtime as required
• Ability and willingness to work flexible hours
• Ability and willingness to work virtually

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

Applications submitted by email will not be accepted. You must apply through the "Apply online" link below. Persons are entitled to participate in the appointment process in the official language(s) of their choice. Applicants are asked to indicate their preferred official language(s) in their application.

Persons with disabilities preventing them from applying on-line are asked to contact 1-800-645-5605.

Communication for this process will be sent via email. It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required. Candidates who apply to this selection process should include an email address that accepts email from unknown users (some email systems block these types of email).

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.

All information obtained throughout the selection process, from the time of application to close of process, may be used to evaluate the candidates. A written examination and an interview may be administered. Reference checks may be sought. Proof of your education credentials will be required at a later date.

Appointment decisions may be based on one or more of the following criteria:
- Matching of the individual's experience or qualifications to the strengths and weaknesses of the work team.
- Matching of the individual's experience or qualifications to the specific duties of the position being staffed.
- Depth, breadth, type of work-specific experience.
- Level/degree of one or more competencies/qualifications.

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.