Intermediate System Analysts (PL/SQL & Java) – Information Technology

Alberta Blue Cross•Remote, AB

2d•Onsite

About The Position

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.

Requirements

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
Ability to write efficient, complex PL/SQL queries against very large data sets.
Applied knowledge of Oracle development tools.
Experience with version control systems (e.g., Git)
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.

Nice To Haves

Experience with other programming languages such as Java, JavaScript, and Bash are desirable.
Working knowledge of database environments would be considered an asset.

Responsibilities

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 using PL/SQL and Java along with associated 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.
Design and develop Java-based components, APIs, and services that integrate with PL/SQL code and oracle database.
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.