Senior Consultant, Retirement and Benefits Technology Solutions (SQL)

Location: Toronto, Ontario, Canada. Flexibility to work in-office, virtually, or in a combination of both.

Salary: $80,000–$110,000 per year.

Company

hirify.global provides technology-enabled physical, mental, and financial health solutions, including automated retirement and benefits administration for organizations across Canada and the United States.

What you will do

• Design and build SQL queries, database solutions, and reports supporting client operations.
• Automate reporting workflows with SQL Server Integration Services and create self-service reports with SQL Server Reporting Services.
• Perform ad hoc analysis and support data-cleanup initiatives to improve data quality.
• Identify process improvements and develop automated solutions that streamline workflows and standard operating procedures.
• Mentor technical colleagues, help troubleshoot complex issues, prioritize ticket queues, and support incident and deliverable SLAs.
• Create technical and user documentation and explain complex technical concepts to clients and non-technical stakeholders.

Requirements

• Strong expertise in SQL, including query tools, database architecture, and query optimization.
• Hands-on experience with SSRS or similar web-based reporting applications.
• Proficiency in Microsoft Excel, Access, and core Microsoft Office applications.
• At least 3 years of experience in data reporting, database support, or technically focused customer support.
• Experience with ticketing or incident management systems and explaining technical concepts to non-technical audiences.
• Strong communication, customer service, analytical, prioritization, problem-solving, and independent working skills.

Nice to have

• Experience in health and welfare, benefits administration, or pension services.
• Experience leading or mentoring technical team members.
• Familiarity with data visualization tools, agile methodologies, SSIS, or customer-facing support.

Culture & Benefits

• Comprehensive total rewards package with salary and bonus structures.
• Minimum three weeks of vacation and a flexible benefits plan.
• Company-matched pension plan.
• Flexible in-office, virtual, or combined work arrangements.
• Career growth, learning, and development opportunities.
• Opportunities to contribute to local communities.