détails d'emploi
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 opportunity offers a chance to lead the implementation of a modern reporting and analytics platform powered by Power BI, Azure, and Dynamics 365 as a Senior Business Intelligence Specialist. 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 the perfect environment to make a tangible impact in a hybrid, enterprise-grade data team.
If you are interested in this role, please apply online at www.randstad.ca. Qualified candidates will be contacted.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
voir plus
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 opportunity offers a chance to lead the implementation of a modern reporting and analytics platform powered by Power BI, Azure, and Dynamics 365 as a Senior Business Intelligence Specialist. 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 the perfect environment to make a tangible impact in a hybrid, enterprise-grade data team.
If you are interested in this role, please apply online at www.randstad.ca. Qualified candidates will be contacted.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
voir pluspartager l'offre d'emploi
