Senior Business Intelligence Specialist

We’re Hiring: Senior Business Intelligence Specialist (RQ09728 )*
hashtag#CANADA hashtag#TORONTO
📍 Location: 595 Bay Street, Toronto, ON (Onsite/Hybrid)
🏢 Client: Ministry of Public and Business Service Delivery and Procurement
📅 Start Date: October 20, 2025
📅 End Date: March 31, 2026 (extension probable)
⏰ Hours: 7.25 per day | Security: CRJMC + Credit Check

We’re looking for a Senior BI Specialist with strong Power BI expertise and hands-on experience with Dynamics 365 (CE/F&O) and data warehouse/lakehouse solutions. This role will be key in designing, building, and optimizing a new Azure-based data warehouse while delivering impactful reporting solutions for the Office of the Public Guardian and Trustee (OPGT).

✅ Must-Have Skills:

Advanced Power BI (data modeling, dashboards, DAX, Power Query)

Data analytics/reporting from Dynamics 365 CE and/or F&O

Strong knowledge of data warehouse/lakehouse concepts, ETL, and governance

Proficiency with SQL (T-SQL/PL-SQL), query tuning, and database platforms (SQL Server, Oracle, Azure SQL)

⭐ Nice-to-Haves:

Azure certifications (Azure Fundamentals, Power BI Data Analyst Associate)

Experience with PowerApps, Power Automate, Dataverse

Knowledge of Azure Data Factory, Synapse, DevOps

📌 Key Responsibilities:

Design and implement a new Azure-based data warehouse/lakehouse

Develop and automate ETL pipelines from Dynamics 365 CE & F&O

Build interactive Power BI dashboards & reports

Implement data governance & security controls

Optimize performance for scalability and efficiency

📄 Interested?
If this sounds like a fit, please send your updated resume, references, expected hourly rate, visa status, and LinkedIn ID to:
📧 malleshvadlakonda@smsoftconsulting.com
| hrsmss@smsoftconsulting.com