Intermediate System Analysts (PL/SQL) – Information Technology

Alberta Blue Cross; Edmonton, Calgary; Hybrid; CAD 75,000 - 105,000; Full time

Job summary

Alberta Blue Cross is seeking an Intermediate System Analyst for a one-year temporary full-time role in a hybrid setup, traveling weekly to Edmonton and/or Calgary offices. The job focuses on gathering business requirements, designing, developing, supporting, and documenting Oracle-based applications, primarily using PL/SQL.

The ideal candidate has a bachelor’s degree or diploma in Computer Science or related discipline and 3–5 years of hands-on PL/SQL development, with knowledge of Java and

Qualifications

• Bachelor’s degree or diploma in Computer Science or related technical discipline.
• Minimum of three to five years of hands-on experience in development, design, and implementation of small to large-scale applications involving complex coding using PL/SQL.
• Experience with Java and Bash desirable.
• Ability to write efficient, complex queries against very large data sets.
• Applied knowledge of Oracle development tools.

Responsibilities

• Work with multiple teams across the organization.
• Communicate effectively with team, team manager and business customers.
• Contribute to team activities and workload management.
• Maintain applications to ensure they run properly and efficiently.
• Produce and maintain program code (mostly PL/SQL) and documentation.
• Understand, design, build and test change requests.
• Troubleshoot and resolve issues.
• Assess root cause of issues and recommend changes.
• Perform systems testing with IT and business customers.
• Prepare documentation and instructions for execution of programs.
• Review requirements with users and estimate task completion.
• Work as part of a project team as required.
• Follow IT Controls practices and Systems Development Life Cycle best practices.
• Provide on-call production support as required.
• Continual learning of application environment and integrations.
• Could include data management activities such as data interfaces and data models.

Skills

Communication

Team collaboration

Problem solving

Analytical thinking

Education

Bachelor’s degree in Computer Science or related

Diploma in a technical discipline

Tools

PL/SQL

Java

Bash

Oracle development tools

SQL queries

Job description

Alberta Blue Cross® is an Alberta based organization dedicated to delivering exceptional customer experience and community leadership. We’re committed to providing the best health coverage to over 1.8 million members and take an active role in promoting wellness. We believe in what we do—and place trust in our employees to deliver our vision.

Working at Alberta Blue Cross® means having a career where you’ll be recognized for your contributions. We value diversity, encourage our team members to maintain a healthy work-life balance and provide opportunities for career growth.

OVERVIEW:

With over 300 employees in our IT department, individuals contribute to the maintenance, enhancement, and new development of applications that serve both our internal and external customers. Alberta Blue Cross has an immediate opportunity for a one-year temporary full-time Intermediate System Analyst to join our team. This position will gather business requirements, perform design, development, support and documentation activities in an Oracle application environment.

In this hybrid role, you will be required to travel to the Edmonton and or Calgary office weekly.

WHAT YOU WILL DO:

• Work collaboratively with multiple teams across the organization.
• Communicate effectively with your team, team manager and business customers.
• Contribute and be accountable to your team’s activities and workload management.
• Maintain applications ensuring they are running properly and efficiently.
• Produce and maintain program code (mostly PL/SQL) and documentation.
• Understand, design, build and test change requests.
• Troubleshoot and resolve issues.
• Assess the root cause of issues and recommend changes.
• Perform systems testing with both IT and business customers. Provide support during various phases of testing.
• Prepare documentation and instructions for the execution of application programs.
• Reviews requirements with the users and provides time estimates for task completion.
• Work as part of a project team as required.
• Follow IT Controls practices (e.g. IT Governance, Data Privacy) to ensure quality output.
• Follow Systems Development Life Cycle best practices.
• Provides on-call production support as required.
• Continual learning and understanding of the application environment, interdependencies, and integrations with other systems.
• Could include data management activities such as designing and building data interfaces and extracts, forms and reports, and designing logical and physical data models.

WHAT YOU WILL HAVE:

• A bachelor’s degree or diploma in Computer Science or related technical discipline.
• Minimum of three to five years of hands-on experience in the development, design, and implementation of small to large-scale applications involving complex coding utilizing PL/SQL.
• Experience with other programming languages such as Java and Bash are desirable.
• Ability to write efficient, complex queries against very large data sets.
• Applied knowledge of Oracle development tools.
• Working knowledge of database environments would be considered an asset.
• Exceptional consultation skills are critical, with the ability to convey technical ideas to both technical and non-technical audiences.
• A mindset for contributing to a healthy culture in a supportive and collaborative team environment.
• Strong interpersonal, verbal and written communication skills are required.
• Exceptional planning, organizational, analytical, problem-solving skills.

This position will remain open until a suitable candidate is selected.

Alberta Blue Cross® is an inclusive employer committed to a workplace that reflects the diversity of the communities we serve. We empower and are advocates for our team members by welcoming, respecting and valuing their unique perspectives, backgrounds, and experiences.

We offer the opportunity to work in an innovative, high-energy team-focused environment.

A criminal record check satisfactory to Alberta Blue Cross will be required as a condition of employment, following a conditional offer.