Senior Business Intelligence Specialist

Job title: Senior Business Intelligence Specialist

Company: Randstad


Job description: 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 cultureResponsibilities

• 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 classificationSummary
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.

Expected salary:

Location: Toronto, ON

Job date: Sun, 13 Jul 2025 23:16:16 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck