Senior Consultant Administrative Solutions

TL;DR

Senior Consultant Administrative Solutions (SQL Reporting): Managing database operations and reporting for health and welfare plan administration with an accent on automation, process improvement, and team support. Focus on developing SSRS/SSIS reports, automating data clean-up, mentoring team on technical challenges, and ensuring SLA adherence in ticket management.

Toronto, Ontario, Canada or Boston, Massachusetts, USA. Flexibility to work in-office, virtually, or a combination of both.

$80,000 - $110,000

Company

hirify.global is a global-leading health and well-being provider administering pension and benefits plans for millions of members across Canada and the United States using automated platforms.

What you will do

• Create, automate, and schedule reports using Microsoft SQL, SSIS, and SSRS, including ad hoc reports and data clean-up.
• Collaborate with business partners to gather requirements and identify automation opportunities for processes and SOPs.
• Mentor team members on technical challenges, work prioritization, ticket queue management, and SLA adherence.
• Ensure quality control of deliverables and manage database integrity.
• Draft technical and user documentation and respond to administration team, client, and internal user requests.

Requirements

• Diploma in Computer Science or equivalent relevant education/work experience.
• 3-5 years in a similar role, including ticketing systems experience.
• Experience with SQL query tools, database architecture, SSRS or web applications.
• Proficiency in Microsoft Office (Excel, Access) and Windows environments.
• Excellent communication skills to explain technical concepts to non-technical audiences.
• Strong analytical, problem-solving skills; ability to manage priorities and multiple projects independently or in a team.

Nice to have

• Experience in Health & Welfare industry.
• Knowledge of data visualization tools.
• Familiarity with agile methodologies.

Culture & Benefits

• Comprehensive rewards including competitive salary, bonus, minimum 3 weeks vacation, flexible benefits, and company-matched pension.
• Flexible work options: in-office, virtual, or hybrid.
• Career growth, learning & development opportunities.
• Opportunities to give back to communities.