Intermediate System Analysts (PL/SQL) – Information Technology

Posted 7 Days Ago
Be an Early Applicant
Hiring Remotely in Alberta, AB, CAN
Remote
Mid level
Insurance
The Role
Mid-level system analyst responsible for gathering requirements, designing, developing and supporting Oracle-based applications (primarily PL/SQL). Duties include coding, testing, troubleshooting, documentation, on-call production support, and building data interfaces, reports, and models. Hybrid role requiring weekly travel to Edmonton or Calgary offices.
Summary Generated by Built In

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. If you have the qualifications we are looking for, apply online at careers.ab.bluecross.ca

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

Skills Required

  • Bachelor's degree or diploma in Computer Science or related technical discipline
  • 3-5 years hands-on experience developing, designing, and implementing applications using PL/SQL
  • Ability to write efficient, complex queries against very large data sets
  • Applied knowledge of Oracle development tools
  • Experience with Java and Bash
  • Working knowledge of database environments
  • Exceptional consultation, interpersonal, verbal and written communication skills
  • Strong planning, organizational, analytical and problem-solving skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Edmonton, Alberta
1,124 Employees
Year Founded: 1948

What We Do

We believe that people, workplaces and communities deserve to be and live well—and we can help. As a benefits provider and wellness leader, we have the opportunity to play an important role in fostering the health and well-being of our customers across their lifetimes. We provide benefits to more than 1.8 million Albertans through group, government and individual plans. Alberta-based, not-for-profit, wellness-driven, customer committed. Living our values Our values represent who we are, what we stand for and the culture that guides us. In all we do, we keep our values at the forefront. Integrity and trust We are respectful, ethical, honest and inclusive in all that we do. Wellness and flexibility We promote and inspire a healthy culture of support, adaptability and compassion across our workplace and our communities. Customer committed We are accountable and committed to our customers and passionate in the delivery of an exceptional customer experience. Empowering potential We support learning and growth while fostering a diverse environment that cultivates collaboration and innovation.

Similar Jobs

Dropbox Logo Dropbox

Director, Head of Scaled Sales

Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
Remote
Canada
2500 Employees

MongoDB Logo MongoDB

Software Engineer

Big Data • Cloud • Software • Database
Easy Apply
Remote or Hybrid
4 Locations
5550 Employees
122K-170K Annually

Enverus Logo Enverus

Senior Data Engineer

Big Data • Information Technology • Software • Analytics • Energy
In-Office or Remote
2 Locations
1800 Employees

Enverus Logo Enverus

Director, Research - Power Markets - 26149D

Big Data • Information Technology • Software • Analytics • Energy
In-Office or Remote
2 Locations
1800 Employees

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 Employees
MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account