ANTICIPATORY - Administrative Officer – VBA Developer

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

OUR COMMITMENT TO ANTI-RACISM: https://www.canada.ca/en/immigration-refugees-citizenship/corporate/mandate/anti-racism.html

Work environment

We're hiring superheroes to design and develop awesomeness! Will you join us?

We are seeking for a candidate who:
• has extensive expertise in VBA (Visual Basic for Application) programming;
• thrives in a fast-paced and dynamic working environment;
• is flexible and able to adapt easily to new and emerging priorities;
• likes to be challenged;
• is interested to explore new technologies;
• has a positive customer service attitude; and
• has solid analytical, troubleshooting and problem solving skills.

The candidate will be selected for their ability to position IRCC at the forefront of financial process modernization for years to come. We are looking for commitment and a willingness to support our clients with innovative approaches that provide increased business intelligence in the management and sharing of financial data.

KEY ACTIVITIES

The position main tasks are as follow:

•Support the Financial Modernization Division in the realization of transformation projects;
•Design, implement, document, test, verify and integrate tracking and reconciliation tools using the VBA programming language;
•Translate business needs into technical solutions;
•Present options for the design and implementation of financial business processes;
•Develop integrated business solutions to automate manual tasks; and
•Participate in a strong collaborative and customer service culture that reflects accountability and transparency at all levels.

Intent of the process

This process will be used to establish a pool of candidates that may be used to staff similar positions at an identical or equivalent group and level with the same official language proficiencies (Bilingual Imperative BBB/BBB), various security profiles (Reliability Status, Secret), various tenures (Indeterminate, Temporary) using various staffing mechanisms (Indeterminate appointment, Term appointment, Acting appointment, Deployment, Secondment, Assignment) at Immigration, Refugees and Citizenship 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
Ed1. A secondary school diploma OR an acceptable combination of education, training and/or experience

Degree equivalency

EXPERIENCE
E1. Significant and recent* experience in Visual Basic for Application (VBA) programming
E2. Significant and recent* experience in process/tool design using VBA
E3. Experience with MS Excel application – Pivot Tables, Formulas, etc.

*Significant and recent experience: two (2) years within the last five (5) years

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

Bilingual - Imperative (BBB/BBB)
The position to be staff is Bilingual Imperative BBB/BBB (intermediate), which mean that you must be bilingual at this level at the moment of the appointment.

Information on language requirements

Second Language Writing Skills Self-Assessment
In order to help you decide if you should apply to a bilingual position, an optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.

For more information, please consult:
Unsupervised Internet Test of Second Language Writing Skills

ABILITIES
A1. Ability to communicate effectively orally
A2. Ability to communicate effectively in writing

COMPETENCIES
C1. Cooperation and Collaboration
C2. Judgement/Analytical Thinking
C3. Adaptability and Flexibility
C4. Values and Ethics
C5. Client Service Orientation

PERSONAL SUITABILITY
PS1. Reliability

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

At IRCC, diversity is our strength. If you are an indigenous person, a person with a disability or a visible minority, we encourage you to complete the Employment Equity (EE) section in your application.

OPERATIONAL REQUIREMENTS
Availability, willingness and ability to work overtime, sometimes on short notice.

Conditions of employment

Reliability Status security clearance - This factor is not used at the prescreening stage. The hiring department is responsible for the security clearance process.

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

RECEIPT OF APPLICATIONS WILL NOT BE SENT; ONLY CANDIDATES SUCCESSFUL IN THE SCREENING PROCESS WILL BE CONTACTED.

Must be willing to relocate. NOTE: telework or flexible work arrangements are possible (as a result of COVID-19 pandemic, our employees are teleworking on a full-time basis; this may change upon reintegration to the workplace).

Candidates from outside the federal public service may be required to pay for their own travel and relocation expenses.

ASSESSMENT INFORMATION

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.

Various assessment tools can be used, such as interviews, tests, references, knowledge of the members of the selection committee.

All communication relating to this process, including email correspondence may be used in the assessment of qualifications.

A random or top down selection of candidates may be used in the determination of those to be given further consideration in the assessment process.

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.

IMPORTANT: Candidates will need to provide proof of their education credentials at a LATER TIME in the process. Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca/indexe.stm

APPLICATION & CORRESPONDENCE INFORMATION

Applications submitted by email will not be accepted. You must apply on-line through www.jobs.gc.ca.

Persons with disabilities preventing them from applying on-line are asked to contact the email referenced below under "Contact Information".

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.

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

Preference

Preference will be given to veterans first and then to Canadian citizens and permanent residents, 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.