Senior Business Intelligence Specialist

Do you have proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features? Do you have demonstrated experience with data analytics and reporting from Dynamics 365 CE and / or F&O? If so, this would be a great opportunity for you!

Our client is looking for a Senior Business Intelligence Specialist for a 10 month contract in Toronto.

This is an onsite role.

Advantages

• Earn a competitive rate within the industry.
• Location : Working 7.25 hours per calendar day, sometime between 8 : 00 AM and 5 : 00 PM (excluding breaks) Monday to Friday inclusive.

Responsibilities

Qualifications

Must Haves :

Nice To have :

Desired Skills and Experience

Data Warehouse / Lakehouse Concepts : Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.

Power BI : Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.

Knowledge of technologies commonly used with Dynamics 365, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.

SQL and Query Optimization : Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.

Data Modeling and Design : Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.

Data Visualization : Ability to create visually appealing and informative reports and dashboards using Power BI, understanding best practices for data visualization, and storytelling with data.

Data Security and Governance : Knowledge of data security principles, data governance practices, data quality management, and data lifecycle management.

Analytical and Problem-Solving Skills : Strong analytical thinking and problem-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.

Communication and Collaboration : Effective communication skills to interact with stakeholders, gather requirements, and present findings. Collaboration skills to work with cross-functional teams, such as data engineers, data analysts, and business stakeholders.

Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.

Experience with SQL Server Management Studio, Azure data management tools, data modeling tools

Experience with SSIS, SSRS

Summary

If you are interested in the Senior Business Intelligence Specialist role in Toronto, 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.