Senior Business Intelligence Specialist

Are you an experienced BI Specialist passionate about building modern data warehouse/lakehouse solutions and reporting systems? Our client is looking for a Senior BI Specialist (Power BI & Azure) for a hybrid contract of 7 months based in Toronto , requiring 2 days onsite per week. In this role, you will be instrumental in developing a next-generation data warehouse and delivering key reporting solutions using Power BI and Azure Synapse. You will work with dynamic datasets from Dynamics 365 CE and F&O, designing data models, ETL pipelines, and building interactive dashboards that drive data-driven decisions. Security clearance (CRJMC + Credit Check) is mandatory for this role. Advantages Hybrid flexibility: 2 days onsite, 3 days remote Hands-on work with Power BI, Azure Synapse, and Dynamics 365 data Influence architecture and design for a new enterprise-grade data platform Opportunity to work on high-impact government modernization initiatives Exposure to cutting-edge tech: Power Platform, Azure Data Factory, DevOps Knowledge transfer opportunities and continuous learning culture Responsibilities Design and develop a new data warehouse/lakehouse using Azure Synapse Analytics Create ETL pipelines to load and transform data from Dynamics 365 CE and F&O Build robust, interactive Power BI dashboards and reports, ensuring data integrity and visualization best practices Design and implement data models (star/snowflake schemas) aligned to analytical and reporting needs Configure Power BI gateways, DAX, and Power Query for complex reporting use cases Apply best practices in data governance, security, and access management Conduct SQL performance tuning, data profiling, and optimize queries for fast retrieval Collaborate with cross-functional teams (data engineers, analysts, business users) to gather requirements and translate into technical solutions Document all work in Azure DevOps Wiki/Boards and support ongoing knowledge transfer Participate in project planning, backlog grooming, and reporting MVP definition Qualifications Must Have: 5+ years of experience with Power BI: data modeling, dashboards, DAX, Power Query Strong knowledge of data warehousing/lakehouse principles: ETL, schema design, governance Experience reporting from Dynamics 365 CE and/or F&O data sources Proficient in SQL Server, Azure SQL, and optimizing queries for performance Experience using Azure Synapse, Azure Data Factory, or similar cloud data services Understanding of data governance practices and data lifecycle management Strong documentation and collaboration skills using Azure DevOps Nice to Have: Azure certifications (e.g., Azure Fundamentals, Power BI Data Analyst Associate) Experience with Power Platform, PowerApps, and Power Automate Familiarity with Dataverse, Common Data Service (CDS), and REST APIs Experience with SSIS/SSRS, T-SQL, and PL/SQL Understanding of performance tuning, indexing, and query plan optimization Experience with data security protocols and data classification Summary This contract offers a chance to lead the implementation of a modern reporting and analytics platform powered by Power BI, Azure, and Dynamics 365. If you have a deep understanding of data modeling, ETL design, and Power BI reporting, and love transforming raw data into actionable insights, this role provides a great opportunity to make a tangible impact in a hybrid, enterprise-grade data team. If interested, please apply online at . Qualified candidates will be contacted. Randstad Canada is committed to fostering a diverse and inclusive workforce and supporting accessibility needs. Please identify any accommodation requirements by emailing . #J-18808-Ljbffr