Senior Data Analytical Specialist​/Scientist

Are you an experienced Senior Data Analytics Specialist/Scientist with hands-on expertise in designing and delivering advanced BI and data engineering solutions using Microsoft Azure services, Power BI, and modern data warehouse platforms? This hybrid role will play a key part in supporting strategic data initiatives across critical program areas through the development of robust data pipelines, dashboards, and analytics products.

Our client is seeking a Senior Data Analytical Specialist/Scientist for a 6-month contract based in Toronto, with on-site attendance required as per the hiring manager’s direction, generally following a hybrid work model. This role initially spans 50 working days, with a possible extension.

• Design, develop, and implement scalable data pipelines, ETLs/ELTs, and data warehouse/lakehouse solutions
• Lead business requirement analysis and stakeholder consultations
• Develop Power BI dashboards and visualizations to deliver actionable insights
• Analyze data trends, patterns, and anomalies to drive business intelligence
• Document data dictionaries, workflows, and reporting standards
• Facilitate demos, training, and knowledge transfer sessions for users
• Support UAT, test plans, documentation, and validation activities
• Align analytics solutions with evolving project objectives and IT standards
• Act as a subject matter expert on data engineering and analytics best practices
• Collaborate with internal/external stakeholders and multidisciplinary project teams
• Conduct continuous reviews and enhancements to BI solutions

• Minimum 5 years of experience as a Data Engineer/ETL Developer building BI products
• Proficiency in Azure Synapse, Azure Data Factory, and Databricks
• Hands-on experience with Microsoft SQL Server, Snowflake, and Azure Data Lake/Delta Lake
• Strong Power BI development skills for dashboards and self-serve reporting
• Knowledge of data mining techniques: clustering, regression, classification, etc.
• Advanced SQL querying and data modeling experience
• Experience with data integration across diverse formats and sources
• Proven ability to interpret data and present actionable insights
• Familiarity with Python, R, or SAS for data analysis (Pandas, Num Py, Sci Py, etc.)

• Strong written documentation skills (data dictionaries, specs, business requirements)
• Excellent communication and presentation abilities
• Experience facilitating cross-functional team collaborations
• Stakeholder management and expectation setting
• Experience navigating dynamic and hybrid public sector environments
• Critical thinking and conflict resolution abilities
• Effective time management and prioritization in fast-paced settings

This is a high-impact opportunity for a data-driven professional to shape and implement advanced analytics solutions that directly inform public-facing program decisions. You will work with leading cloud technologies in a hybrid setup, translating complex data into accessible, strategic insights.

If you are passionate about modern data architecture, visualization, and collaborative innovation, apply now via  Only shortlisted candidates will be contacted.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada and promoting equity, diversity, and inclusion. We support accessibility and accommodation needs throughout the employment process; please email  for assistance.