We are seeking an expert Senior Business Intelligence Specialist to drive the auditing and reporting capabilities of an enterprise-level platform. In this role, you will take ownership of defining and building data-driven solutions that turn complex backend records into actionable business insights. Operating within a high-performing data delivery ecosystem, you will bridge the gap between large transactional ERP/CRM applications, centralized cloud lakehouses, and modern visual dashboards to ensure the highest standards of data governance, system performance, and metric accuracy.
...
Location: Toronto, ON (Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)
Duration: 10-month contract.
Advantages
Niche Enterprise Stack: Advance your market visibility by engineering analytics platforms pulling from integrated tier-1 systems (Dynamics 365 CE/F&O).
Strategic Cloud Execution: Command data lakehouse configurations by utilizing leading-edge Azure cloud management architectures.
End-to-End Metric Ownership: Drive data strategy directly—from backend schema modeling and raw pipeline ingestion to final front-end visualization design.
Stable Daytime Schedule: Benefit from a highly reliable, standard daytime framework within a professional workspace.
Responsibilities
Reporting & Visualization: Architect, develop, and maintain interactive enterprise dashboards, reports, and visualization layers that convey critical business performance trends.
Data Modeling & Architecture: Design, build, and optimize logical and physical data models, establishing efficient data relationships, hierarchies, and storage schemas tailored for analytical parsing.
Extraction & Pipeline Integration: Build and support robust Extraction, Transformation, and Load (ETL) data pipelines to securely ingest information from flat files, relational databases, and enterprise APIs into a centralized data warehouse.
Database Optimization: Write, test, and tune complex SQL queries to profile underlying datasets and systematically eliminate system bottlenecks by reviewing indexing and partitioning strategies.
Cross-Functional Collaboration: Partner with cross-functional technical teams, business analysts, and operational stakeholders to extract reporting parameters and translate business needs into technical specifications.
Data Security & Governance: Implement strict role-based data security controls and compliance rules to maximize data integrity and safeguard highly sensitive transactional information.
Quality Assurance & Verification: Monitor, validate, and audit data accuracy across production systems to preserve consistency between source layers and front-end reports.
Knowledge Transfer: Maintain clean, detailed system documentation and deliver technical skills training to permanent data teams to facilitate smooth post-implementation support.
Qualifications
Core Analytics Seniority: 8+ years of progressive professional experience architecting, developing, and operating Business Intelligence and data warehouse solutions.
Power BI Mastery: Elite proficiency using Power BI, including advanced data modeling, data gateway configurations, and complex calculations utilizing DAX and Power Query.
ERP/CRM Domain Expertise: Proven experience constructing analytical reports utilizing backend data models directly from Dynamics 365 Customer Experience (CE) and Finance & Operations (F&O) environments.
Cloud ETL Engineering: Practical experience handling cloud data integration techniques, source-to-target mapping, and building automated pipelines using Azure Synapse or similar enterprise ETL tools.
Advanced Query Programming: Expert-level SQL scripting capabilities with deep structural knowledge of performance troubleshooting, query optimization plans, and indexing frameworks.
Technical Engineering Tooling: Familiarity operating with database management applications such as SQL Server Management Studio (SSMS), SQL4CDS, and Azure data management utilities.
Agile Code Governance: Working knowledge of code repository version control and backlog management within Azure Repos and Azure DevOps.
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 an expert Senior Business Intelligence Specialist to drive the auditing and reporting capabilities of an enterprise-level platform. In this role, you will take ownership of defining and building data-driven solutions that turn complex backend records into actionable business insights. Operating within a high-performing data delivery ecosystem, you will bridge the gap between large transactional ERP/CRM applications, centralized cloud lakehouses, and modern visual dashboards to ensure the highest standards of data governance, system performance, and metric accuracy.
Location: Toronto, ON (Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)
Duration: 10-month contract.
Advantages
Niche Enterprise Stack: Advance your market visibility by engineering analytics platforms pulling from integrated tier-1 systems (Dynamics 365 CE/F&O).
Strategic Cloud Execution: Command data lakehouse configurations by utilizing leading-edge Azure cloud management architectures.
End-to-End Metric Ownership: Drive data strategy directly—from backend schema modeling and raw pipeline ingestion to final front-end visualization design.
...
Stable Daytime Schedule: Benefit from a highly reliable, standard daytime framework within a professional workspace.
Responsibilities
Reporting & Visualization: Architect, develop, and maintain interactive enterprise dashboards, reports, and visualization layers that convey critical business performance trends.
Data Modeling & Architecture: Design, build, and optimize logical and physical data models, establishing efficient data relationships, hierarchies, and storage schemas tailored for analytical parsing.
Extraction & Pipeline Integration: Build and support robust Extraction, Transformation, and Load (ETL) data pipelines to securely ingest information from flat files, relational databases, and enterprise APIs into a centralized data warehouse.
Database Optimization: Write, test, and tune complex SQL queries to profile underlying datasets and systematically eliminate system bottlenecks by reviewing indexing and partitioning strategies.
Cross-Functional Collaboration: Partner with cross-functional technical teams, business analysts, and operational stakeholders to extract reporting parameters and translate business needs into technical specifications.
Data Security & Governance: Implement strict role-based data security controls and compliance rules to maximize data integrity and safeguard highly sensitive transactional information.
Quality Assurance & Verification: Monitor, validate, and audit data accuracy across production systems to preserve consistency between source layers and front-end reports.
Knowledge Transfer: Maintain clean, detailed system documentation and deliver technical skills training to permanent data teams to facilitate smooth post-implementation support.
Qualifications
Core Analytics Seniority: 8+ years of progressive professional experience architecting, developing, and operating Business Intelligence and data warehouse solutions.
Power BI Mastery: Elite proficiency using Power BI, including advanced data modeling, data gateway configurations, and complex calculations utilizing DAX and Power Query.
ERP/CRM Domain Expertise: Proven experience constructing analytical reports utilizing backend data models directly from Dynamics 365 Customer Experience (CE) and Finance & Operations (F&O) environments.
Cloud ETL Engineering: Practical experience handling cloud data integration techniques, source-to-target mapping, and building automated pipelines using Azure Synapse or similar enterprise ETL tools.
Advanced Query Programming: Expert-level SQL scripting capabilities with deep structural knowledge of performance troubleshooting, query optimization plans, and indexing frameworks.
Technical Engineering Tooling: Familiarity operating with database management applications such as SQL Server Management Studio (SSMS), SQL4CDS, and Azure data management utilities.
Agile Code Governance: Working knowledge of code repository version control and backlog management within Azure Repos and Azure DevOps.
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
