Intermediate System Analysts (PL/SQL) – Information Technology

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

Job summary

Alberta Blue Cross is seeking an Intermediate System Analyst to join our IT team on a one-year temporary full-time basis. The role focuses on requirements gathering, design, development, support and documentation in an Oracle environment, with PL/SQL coding and collaboration across departments.

This hybrid position requires weekly travel to Edmonton and/or Calgary offices. Ideal candidates have a bachelor's in Computer Science and 3–5 years of PL/SQL development experience, plus familiarity with

Qualifications

• Bachelor's degree in Computer Science or related field.
• 3–5 years hands-on PL/SQL development experience.
• Experience with Java and Bash is desirable.
• Ability to design and optimize queries for large data sets.

Responsibilities

• Collaborate with multiple teams across the organization to gather requirements and deliver solutions.
• Develop and maintain PL/SQL code and Oracle-based applications.
• Troubleshoot and resolve issues in production and development environments.
• Prepare documentation and user instructions for application programs.
• Assist in design, testing, and implementation of change requests.
• Provide on-call production support as required.

Skills

PL/SQL

Java

Bash

SQL queries

Education

Bachelor's degree in Computer Science

Tools

Oracle development tools

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.