Intermediate System Analyst, PL/SQL – Information Technology

Alberta Blue Cross

Intermediate System Analyst gathering business requirements and maintaining Oracle applications for Alberta Blue Cross. Collaborating with teams and overseeing the execution of application programs in a hybrid work environment.

Posted 4/22/2026full-time🇨🇦 CanadaJuniorMid-LevelWebsite

Tech Stack

Tools & technologies

JavaJavaScriptOracleSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

A bachelor’s degree or diploma in Computer Science or related technical discipline
Two or more years of progressive experience developing and designing implementations with small to large scale applications with data manipulation components preferably using PL/SQL or similar languages
Experience with other programming languages such as Java, JavaScript, 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

Benefits

Comp & perks

Work-life balance
Opportunities for career growth
Inclusive employer that values diversity

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PL/SQLJavaJavaScriptBashdata manipulationcomplex queriesOracle development toolssystems testingapplication program documentationSystems Development Life Cycle

Soft Skills

consultation skillscommunication skillsinterpersonal skillsorganizational skillsanalytical skillsproblem-solving skillscollaborative mindsetaccountabilityworkload managementeffective communication

Certifications

bachelor’s degree in Computer Sciencediploma in Computer Science