Senior Consultant, Retirement and Benefits Technology Solutions

Senior Consultant, Administrative Solutions – TELUS Health

What You’ll Do

• Database Solutions & Reporting:
  • Develop SQL queries and reports to solve real‑world client challenges.
  • Build automated reporting solutions using SQL Server Integration Services (SSIS) to allow the team to focus on higher‑value support.
  • Create self‑service reports with SQL Server Reporting Services (SSRS) that empower clients and internal users.
  • Prepare ad hoc analyses and support data clean‑up initiatives that improve data quality.
• Process Improvement & Problem‑Solving:
  • Identify opportunities to work smarter, not harder.
  • Collaborate with business partners to understand challenges and design automated solutions that streamline workflows and improve standard operating procedures.
  • Ask "Why do we do this manually?" and build solutions that save hours each week.
• Team Leadership & Mentoring:
  • Mentor colleagues in troubleshooting complex technical challenges and developing expertise in database solutions and client communication.
  • Manage ticket queue priorities, ensure adherence to incident and deliverable SLAs, and maintain quality control across team deliverables.
  • Help teammates grow technically while supporting them through challenging client situations.
• Documentation & Communication:
  • Create clear technical and user documentation for procedures and technologies, ensuring knowledge is accessible to the whole team.
  • Translate complex technical concepts into language that resonates with non‑technical audiences.

Required Skills

• Must‑Have Technical Skills
  • Expertise with SQL (on‑demand query tools, database architecture, query optimization).
  • Hands‑on experience with SSRS or similar web‑based reporting applications.
  • Proficiency in Microsoft Excel and Access for data analysis and reporting.
  • Solid understanding of Microsoft Office suite fundamentals.
• Must‑Have Experience
  • 3+ years in a data reporting role, database support role, or customer support environment with technical problem‑solving responsibility.
  • Proven experience with ticketing/incident management systems.
  • Track record of explaining complex technical concepts to non‑technical audiences.
• Must‑Have Qualities
  • Excellent written and verbal communication skills.
  • Strong customer service orientation and commitment to supporting colleagues and clients.
  • Exceptional analytical and problem‑solving abilities.
  • Ability to prioritize effectively, meet deadlines, and juggle multiple projects without losing quality.
  • Self‑motivated and able to work independently and collaboratively.
  • Detail‑oriented with creativity in approaching solutions.
  • Quick learner with genuine enthusiasm for new technical challenges.
• Nice to Have
  • Experience in Health & Welfare, benefits administration, or pension services industry.
  • Background leading or mentoring technical team members.Familiarity with data visualization tools.
  • Knowledge of agile methodologies or experience working in agile environments.
  • Experience with SSIS.
  • Background in a customer‑facing support role.

Compensation & Benefits

Salary Range: $80,000 – $110,000 (determined by knowledge, skills, performance, and experience).

Benefits include a comprehensive total rewards package, minimum 3 weeks vacation, flexible benefits plan, company‑matched pension, flexible work arrangements (office, virtual, hybrid), career growth and learning opportunities, and more.

EEO Statement

We are committed to fair employment practices and all qualified applicants will receive consideration for employment. We offer accommodation for applicants with disabilities, as required, during the recruitment process.