IBMi Application Specialist (SQL, RPG, CL, DB2)

First Canadian is a national organization and we are experiencing unprecedented growth!

We aim to hire bright, hard-working people who share our values. We seek employees who are committed to learning, career growth, and opportunity. We take pride in being an organization that our employees support long-term. We believe in our employees and celebrate their success by asking for employee opinions and feedback so that we continue to be a Great Place to Work.

We award our team with the following:

• Off work 1 hour early on Fridays.


• Earned Time-Off Program and vacation.


• Group Retirement Savings Plan with employer match.


• Hybrid work options may be available.


• On-site gym including free weekly classes with a qualified trainer.


• Newly renovated facility with ergonomic desks/chairs.


• Educational assistance and career development.


• Employee benefits.


• Health and Wellness spending account.


• Employee Assistance Program (EAP).


• Employee discount programs.


• A Culture Team dedicated to diversity, inclusion, and employee programs.


• Employee recognition and appreciation events.

Check out our company page for all the information on why we believe First Canadian is an employer of choice!

If you are motivated to succeed by helping people, then this is the opportunity for you!

Under the direction of the Manager of Business Systems - Alberta, the IBMi Application Specialist - Alberta is responsible for program design, coding, testing, debugging, documenting business system software, and the maintenance of new/legacy application software including technical support. 

Essential Responsibilities:

• 
  

  Develop and maintain applications and databases by evaluating business needs; analyzing requirements; and developing software systems.

  
  


• 
  

  Gather and evaluate business requirements by use of analytic skills and personal rapport with business department heads.

  
  


• 
  

  Identify project requirements by analyzing business needs and the preparation of a workflow using knowledge of computer capabilities, subject matter, programming language, and logic.

  
  


• 
  

  Execute the development of applications by programming system features and functionality.

  
  


• 
  

  Verify the correct system program operations by conducting testing and completing any modifications to program operations per testing results.

  
  


• 
  

  Maintain workplace professionalism and contribution to team-related efforts.

  
  


• 
  

  Follow programming guidelines and corporate business policies and procedures.

  
  


• 
  

  Provide technical support and solutions.

  
  


• 
  

  Provide occasional after-hours support to maintain business continuity and address critical system issues when necessary.

  
  


• 
  

  Other duties as required.

  
  

Qualifications:

• 
  

  Post-Secondary Diploma/Degree in Business Administration, Information Technology or a related field, is required.

  
  


• 
  

  A minimum of 0-2 years working with SQL and DB2.

  
  


• 
  

  5+ years working in an IBM AS400 or IBMi, RPG, RPGLE, RPG-FREE, CL, and Query is an asset.

  
  


• 
  

  Experience in an IT development role within the automotive or insurance industry is an asset.

  
  


• 
  

  A background working with accounting, financial and insurance practices is an asset

  
  


• 
  

  Intermediate skill with Microsoft Office (Word/Excel) is required.

  
  


• 
  

  Fluent in English with proven competencies in verbal and written communication is required.

  
  


• 
  

  Fluent in French with proven competencies in verbal and written communication is an asset.

  
  


• 
  

  Successful completion of a criminal background check, education verification, license and certification verification (where applicable), and employment reference checks is required before employment.

  
  

Thank you for considering our organization.

We are an equal opportunities employer and welcome applications from all suitably qualified persons. Accommodations are available upon request.