Sql database administrator Jobs in Edmonton, AB

Job Description

Job Description

Company Overview

Ellement Consulting Group (Ellement) is a privately-owned consulting firm established in 1996. We provide actuarial, administration, software programming, and consulting solutions for pension, benefits, and investment programs for individuals, corporations, unions, associations, and governments across Canada.

At Ellement, we empower our clients with informed choices and expert advice. Our mission centers on delivering purposeful, accessible experiences that prioritize customer obsession and operational excellence. We are committed to integrity, strategic foresight, and fostering symbiotic partnerships where challenges are met with collective brilliance and innovative solutions.

Our approach is straightforward and client-centric, ensuring that every interaction is clear, helpful, and devoid of unnecessary jargon. Confident and authentic, we strive to be more than consultants—we are reliable partners in our clients' success.

Position Summary

The Benefits Administrator plays a pivotal role in ensuring the integrity and accuracy of member, employer, and service provider records within our organization. This position is crucial for the timely setup and ongoing maintenance of these records. The Benefits Administrator collaborates closely with various departments to validate data accuracy, ensuring that all service standards are consistently met. This role demands a detail-oriented and proactive approach to facilitate efficient operations and maintain the highest level of data integrity.

Key Responsibilities

• Set Up and Maintain Records : Establish and continuously update records for members, service providers, and employers to ensure accurate and up-to-date information is available.
• Quality Assurance : Perform quality assurance checks on all data entries to verify accuracy and completeness.
• Update Eligibility and Member Records : Regularly update eligibility statuses and make necessary adjustments to member records as required.
• Track and Mail Drug Cards : Manage the tracking system for drug cards and ensure timely mailing to members.
• Weekly CDA Report Uploads : Upload Client Data Administrator (CDA) reports on a weekly basis to maintain current data flows.
• Process Health & Welfare Self-Payments : Handle the processing of self-payments for Health & Welfare benefits, ensuring accuracy and timely record-keeping.
• Create and Mail Correspondence : Generate and dispatch New Eligible and Self-Pay letters to inform and guide members regarding their benefits.
• Interdepartmental Inquiries : Respond promptly to inquiries from other departments, providing necessary information and support.
• Weekly HCSA Load : Manage the Health Care Spending Account (HCSA) data loading on a weekly basis to ensure funds are accurately allocated.
• Monthly Report Generation : Run various reports on a monthly basis to support departmental functions and provide insights into operations.
• Document Creation and Maintenance : Create and maintain detailed spreadsheets and documents that support the tracking and administration of benefits.
• Problem Analysis and Resolution : Analyze issues that arise and develop effective solutions to address these problems efficiently.
• Optimization of Processes : Continually analyze current processes for efficiency improvements, seeking smarter ways of executing tasks to enhance productivity.

Qualifications and Attributes

Benefits

At Ellement, we’re all about investing in our business, and our biggest investment is our people!

We’re committed to our employees growth and well-being, offering ongoing education, training, and all the support you need to thrive. We offer a comprehensive benefits package, along with a positive, team-oriented work environment.

Join our vibrant and dynamic team today!