We are seeking a Senior Business Intelligence Specialist to join a modernization project focused on building a next-generation data architecture. In this role, you will be a key member of the data team, responsible for designing and implementing a new Data Warehouse/Lakehouse and delivering a Reporting MVP (Minimum Viable Product). You will bridge the gap between complex data migration from legacy systems and the creation of high-impact visualizations that drive business decisions.
...
Pay Rate: $560.07- $595.56/Diem
Advantages
- Modern Tech Stack: Work with cutting-edge Azure cloud technologies including Synapse and Lakehouse architectures.
- High-Impact Project: Play a leading role in the modernization of essential public service applications and data systems.
- Hybrid Flexibility: Enjoy a balanced work environment with a mix of onsite collaboration and remote flexibility.
- Leadership Opportunity: Take ownership of the Reporting MVP and influence the "golden layer" design for a major organization.
Responsibilities
- Architectural Design: Analyze business requirements to design an efficient data warehouse/lakehouse and "golden layer" architecture on Microsoft Azure.
- ETL & Integration: Develop and automate ETL processes to move data from Dynamics 365 (CE and F&O) into bronze, silver, and golden layers of the lakehouse.
- Data Modeling: Create logical and physical data models (Star and Snowflake schemas) that align with analytical needs using tools like ERWIN.
- Advanced Visualization: Develop interactive Power BI reports and dashboards, utilizing DAX, Power Query, and best practices in data storytelling.
- Optimization: Fine-tune the data warehouse and reporting processes to maximize query performance and overall system efficiency.
- Governance & Security: Implement strict security controls to protect sensitive data and ensure compliance with technical standards.
- Collaboration: Provide ongoing knowledge transfer to internal staff and document all tasks and processes within Azure DevOps Wiki.
Qualifications
- Core BI Skills: Advanced proficiency in Power BI (including DAX and Power Query) and extensive experience with SSIS and SSRS.
- Data Warehousing: Strong expertise in Data Warehouse/Lakehouse principles, including data modeling, ETL/ELT pipelines, and data governance.
- Azure Ecosystem: Hands-on experience with Azure Synapse Analytics, Azure Data Factory (ADF), Data Lake Storage, and Synapse Studio.
- Database Expertise: High-level SQL skills (T-SQL/PL-SQL) for complex querying, performance tuning, and troubleshooting across SQL Server and Oracle environments.
- Dynamics 365 Knowledge: Solid understanding of the Dynamics 365 data model, entities, and integration technologies like DataVerse (CDS).
- Certifications (Nice to Have): Azure Fundamentals or Azure Power BI Data Analyst Associate certifications are highly preferred.
- Platform Experience: Familiarity with the PowerApps platform, Power Automate, and Azure DevOps for version control.
Summary
If you're interested in the Senior Business Intelligence Specialist role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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.
This posting is for existing and upcoming vacancies.
show more
We are seeking a Senior Business Intelligence Specialist to join a modernization project focused on building a next-generation data architecture. In this role, you will be a key member of the data team, responsible for designing and implementing a new Data Warehouse/Lakehouse and delivering a Reporting MVP (Minimum Viable Product). You will bridge the gap between complex data migration from legacy systems and the creation of high-impact visualizations that drive business decisions.
Pay Rate: $560.07- $595.56/Diem
Advantages
- Modern Tech Stack: Work with cutting-edge Azure cloud technologies including Synapse and Lakehouse architectures.
- High-Impact Project: Play a leading role in the modernization of essential public service applications and data systems.
- Hybrid Flexibility: Enjoy a balanced work environment with a mix of onsite collaboration and remote flexibility.
- Leadership Opportunity: Take ownership of the Reporting MVP and influence the "golden layer" design for a major organization.
Responsibilities
- Architectural Design: Analyze business requirements to design an efficient data warehouse/lakehouse and "golden layer" architecture on Microsoft Azure.
...
- ETL & Integration: Develop and automate ETL processes to move data from Dynamics 365 (CE and F&O) into bronze, silver, and golden layers of the lakehouse.
- Data Modeling: Create logical and physical data models (Star and Snowflake schemas) that align with analytical needs using tools like ERWIN.
- Advanced Visualization: Develop interactive Power BI reports and dashboards, utilizing DAX, Power Query, and best practices in data storytelling.
- Optimization: Fine-tune the data warehouse and reporting processes to maximize query performance and overall system efficiency.
- Governance & Security: Implement strict security controls to protect sensitive data and ensure compliance with technical standards.
- Collaboration: Provide ongoing knowledge transfer to internal staff and document all tasks and processes within Azure DevOps Wiki.
Qualifications
- Core BI Skills: Advanced proficiency in Power BI (including DAX and Power Query) and extensive experience with SSIS and SSRS.
- Data Warehousing: Strong expertise in Data Warehouse/Lakehouse principles, including data modeling, ETL/ELT pipelines, and data governance.
- Azure Ecosystem: Hands-on experience with Azure Synapse Analytics, Azure Data Factory (ADF), Data Lake Storage, and Synapse Studio.
- Database Expertise: High-level SQL skills (T-SQL/PL-SQL) for complex querying, performance tuning, and troubleshooting across SQL Server and Oracle environments.
- Dynamics 365 Knowledge: Solid understanding of the Dynamics 365 data model, entities, and integration technologies like DataVerse (CDS).
- Certifications (Nice to Have): Azure Fundamentals or Azure Power BI Data Analyst Associate certifications are highly preferred.
- Platform Experience: Familiarity with the PowerApps platform, Power Automate, and Azure DevOps for version control.
Summary
If you're interested in the Senior Business Intelligence Specialist role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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.
This posting is for existing and upcoming vacancies.
show more
