Data and Analytics Specialist

Recruiting In Motion - Eastern Ontario; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

Recruiting In Motion - Eastern Ontario is seeking a Data and Analytics Specialist for a downtown Toronto engagement. This six-month contract may extend and offers exposure to modern analytics platforms.

The ideal candidate has 5+ years in SQL, Power BI, and Databricks, with experience building dashboards and collaborating with business units across Student Services. Strong communication and data integrity skills are essential.

Qualifications

• Requires 5+ years of SQL development, data warehousing or DataMart work.
• 5+ years building Power BI reports, including paginated reports.
• 3+ years using Databricks or equivalent (Unity Catalog, Hive Metastore, SQL Editor).
• 3+ years building CRM reports (Salesforce or Microsoft Dynamics).
• Excellent interpersonal and presentation skills for technical and non-technical audiences.

Responsibilities

• Build both operational and analytical data solutions, including datasets, queries, visualizations, KPIs and dashboards that support projects and daily needs.
• Design and maintain reporting across current and new Education Programs, ensuring continuity across legacy and new data sources.
• Develop solutions with strong data integrity, applying best practices in testing, validation, and documentation.

Skills

SQL proficiency

Data visualization

Stakeholder comms

Analytical mindset

Cross-functional collaboration

Education

Bachelor's degree in CS/IT/Analytics/Math

Tools

Power BI

Databricks

Salesforce

Job description

About Our Client

Our client, a professional services firm located in downtown Toronto, is looking to hire a Data and Analytics Specialist for an initial 6 month contract with the possibility of extension.

Responsibilities

• Build both operational and analytical data solutions, including datasets and queries, visualizations, KPIs and dashboards, and operational reports that support project, day-to-day and ad hoc business needs across Student Services.
• Design and maintain reporting across both the current Education Program and the new Education Program, navigating between legacy and new data sources to ensure continuity and accuracy throughout the transformation.
• Develop solutions that reflect the highest standards of analytical rigor and data integrity, applying best practices in test design, analysis, validation, and documentation across every deliverable.
• Partner with business units to gain a detailed understanding of data solutions requirements and source system functionality, and translate those needs into clear, well-designed reporting and analytics deliverables.
• Develop a thorough understanding of the organization's business processes, source system usage and available internal and external data sources, and produce thorough requirements and solutions documentation to support long-term maintainability.

Requirements

• Successful completion of a post-secondary degree or diploma, preferably in Computer Science, Information Technology, Analytics and/or Mathematics.
• 5+ years of experience in SQL programming, including querying data and building objects such as tables, views, stored procedures and functions.
• Experience in data warehousing or DataMart development using SQL as an ETL delivery implementation is preferred.
• 5+ years of experience using Power BI, including building paginated reports using Power BI Report Builder.
• 3+ years of experience with Databricks or equivalent for query building and procedure writing, including work in Unity Catalog, Hive Metastore, SQL Editor and Notebooks.
• 3+ years of experience building reports within a CRM system, such as Salesforce (preferred) or Microsoft Dynamics.
• Excellent interpersonal, communication, relationship-building and presentation skills, with a proven ability to communicate effectively with both technical and non-technical audiences at coordinator, specialist, manager and director levels.

AI may be used to support certain administrative aspects of our recruitment process. However, all applications and resumes are reviewed by qualified human reviewers, and all screening and hiring decisions are made solely by the hiring team.

The posted salary range reflects expected compensation for this role in accordance with Ontario pay transparency requirements. Actual compensation will be determined based on the successful candidate's experience, skills, and qualifications and may fall anywhere within the range.