Senior Consultant, Retirement and Benefits Technology Solutions

Job description

TELUS Health is empowering every person to live their healthiest life. Guided by our vision, we are leveraging the power of our leading edge technology and focusing on the uniqueness of each individual to create the future of health. As a global-leading health and well-being provider – encompassing physical, mental and financial health – TELUS Health is improving health outcomes for consumers, patients, healthcare professionals, employers and employees. Join our team and what we'll accomplish together Help 9 million plan members stay connected to the benefits they depend on. TELUS Health Retirement and Benefits Solutions has been delivering automated administration and support for nearly 30 years — managing pension and benefits plans for corporations, government organizations, and multi-employer plans across Canada and the United States. Our post-implementation support team is the backbone of that promise. We don't just process tickets; we solve the technical and operational challenges that keep our clients and their members connected to critical resources. We're looking for a Senior Consultant, Administrative Solutions who combines technical expertise with a genuine passion for mentoring others and improving how we serve our clients. In this role, you'll own database solutions, mentor a talented technical team, and collaborate with colleagues across Health & Welfare plan administration and implementation. You'll work with cutting-edge platforms like our Ariel administration system, tackle complex data challenges, and help eliminate the friction that prevents members from accessing the Health & Welfare portal and other critical resources. If you thrive in solving technical problems, love helping colleagues grow, and want to make a tangible impact on how millions of people access their benefits, let's talk. What you'll do Database Solutions & Reporting You'll be the go-to person for designing and building data solutions that power client operations. Your week might include: Developing SQL queries and reports to solve real-world client challenges Building automated reporting solutions using SQL Server Integration Services (SSIS) so the team can focus on higher-value support Creating self-service reports with SQL Server Reporting Services (SSRS) that empower clients and internal users Preparing ad hoc analyses and supporting data clean-up initiatives that improve data quality Process Improvement & Problem-Solving You'll identify opportunities to work smarter, not harder. You'll collaborate with business partners to understand their challenges, then design automated solutions that streamline workflows and improve standard operating procedures. You'll be the person who asks "Why do we do this manually?" and then builds the solution that saves hours each week. Team Leadership & Mentoring As a senior voice on the team, you'll mentor colleagues in troubleshooting complex technical challenges, developing their expertise in database solutions and client communication. You'll manage ticket queue priorities, ensure adherence to incident and deliverable SLAs, and maintain quality control across team deliverables. You'll help your teammates grow technically while supporting them through challenging client situations. Documentation & Communication You'll create clear technical and user documentation for procedures and technologies, ensuring knowledge is accessible to the whole team. You'll respond to requests from the administration team, clients, and internal stakeholders — translating complex technical concepts into language that resonates with non-technical audiences. What you bring Must-Have Technical Skills Strong expertise with SQL (on-demand query tools, database architecture, query optimization) Hands-on experience with SSRS (SQL Server Reporting Services) 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 SQL Server Integration Services (SSIS) Background in a customer-facing support role Salary Range: $ 80,000 - $110,000 Actual total compensation will be determined based on factors such as knowledge, skills, performance and experience. We encourage all qualified candidates to apply, even if the posted salary range doesn't match your expectations. We're open to discussing competitive compensation packages tailored to your experience level and expertise. TELUS Health offers rewarding benefits, which may vary per job function, such as: Comprehensive total rewards package highlighting competitive salary and bonus structures, minimum 3 weeks of vacation, and flexible benefits plan to meet the needs of you and your family Flexibility to work in-office, virtually or a combination of both Generous company matched pension Opportunity to give back to communities in which we work, live and serve Career growth and learning & development opportunities to develop your skills And much more… Job Type: This is for a current vacancy. A bit about us We’re a people-focused, customer-first, purpose-driven team who works together every day to innovate and do good. We improve lives through our technology solutions and foster a culture of innovation that empowers team members to solve complex problems and create remarkable human outcomes in a digital world. TELUS is proud to foster an inclusive culture that embraces diversity. 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. Disclaimer: In accordance with the TELUS Health Solutions Data Center Security Policy, as a condition of employment, all team members whose job functions require they work at a Data Center and/or have access to detailed knowledge of technology related to client service delivery, are subject to a Personnel Security Screening conducted through the Government of Canada. Note for Quebec candidates: if knowledge of English is required for this position, it is because the team member will be asked, on a regular basis, to interact in English with external or internal parties or to use English applications or software as part of their tasks. By applying to this role, you understand and agree that your information will be shared with the TELUS Group of Companies’ Talent Acquisition team(s) and/or any leader(s) who will be part of the selection process.