Senior Data & Analytics Solutions Specialist:

On behalf of our Financial Services client, Procom is searching for a Senior Data & Analytics Solutions Specialist for a full-time/permanent role. This position is a remote position based in Toronto, Ontario, Canada.

Senior Data & Analytics Solutions Specialist - Job Description:

The Senior Data & Analytics Solutions Specialist will focus on designing and delivering scalable analytics datasets and reporting models to enable data-driven decision-making. This role involves hands-on analytics delivery, translating business requirements into structured reporting assets, and optimizing SQL and Power BI solutions.

Senior Data & Analytics Solutions Specialist - Responsibilities:

• Design and deliver analytics datasets and reporting models for enterprise reporting use cases.
• Develop and optimize SQL for large-scale reporting, focusing on efficient query patterns.
• Build and maintain dashboards and semantic layers in Power BI/Tableau.
• Establish “reporting-safe” access patterns and workload guardrails.
• Partner with technical teams on database objects and production environment dependencies.
• Develop reusable analytics assets and automated refresh processes.
• Engage with business stakeholders to gather requirements and communicate insights.
• Contribute to the evolution of client’s analytics environment and best practices.

Senior Data & Analytics Solutions Specialist - Mandatory Skills:

• 7+ years of experience in designing and delivering analytics and reporting solutions.
• Advanced SQL expertise, including query optimization and dimensional modeling.
• Strong experience with stored procedures and performance tuning.
• Hands-on Power BI experience with enterprise dashboards.
• Ability to translate business needs into reliable reporting assets.
• Strong stakeholder management and communication skills.

Senior Data & Analytics Solutions Specialist – Nice-to-Have Skills:

• Experience working in an AWS cloud environment.
• Proficiency in Python for analytics or automation.
• Experience in insurance, fraud, claims, investigations, or risk analytics.
• Exposure to AI/ML data preparation environments.

Senior Data & Analytics Solutions Specialist – Assignment Length:

This is a permanent position.

Senior Data & Analytics Solutions Specialist - Start Date:

ASAP.

Senior Data & Analytics Solutions Specialist - Assignment Location:

Toronto, Ontario, Canada - Remote.