We're looking for a Senior BI Specialist for a 215-day contract. This is a hybrid position where you'll work 7.25 hours per day, with the possibility of both on-site and remote work as directed. You'll be a key member of the data team, responsible for building a new data warehouse/lakehouse and delivering a minimum viable product (MVP) for reporting. You will leverage your expertise in Power BI, Dynamics 365, and data warehousing concepts to provide critical business insights.
...
Advantages
- Play a central role in a major data modernization project.
- Opportunity to work with and influence the design of a new data warehouse/lakehouse on Microsoft Azure.
- Work in a fast-paced environment with a focus on delivering tangible results.
- Gain experience with a wide range of data technologies.
Responsibilities
- Data Warehouse/Lakehouse Design: Analyze business requirements and design an efficient data warehouse/lakehouse on Microsoft Azure.
- Data Integration and ETL: Develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse.
- Data Modeling: Create logical and physical data models that align with the project's reporting needs.
- Reporting and Visualization: Develop reports, dashboards, and visualizations using Power BI, ensuring the quality and integrity of the data.
- Performance Optimization: Fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
- Data Security and Governance: Implement security controls to protect sensitive data within the data warehouse.
Qualifications
- Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and using advanced features like DAX and Power Query.
- Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.
- Strong understanding of data warehousing/lakehouse principles, including data modeling, ETL processes, data integration, and data governance.
- Strong SQL skills for writing complex queries and optimizing database performance.
- Experience with Azure data management tools, including Azure Synapse Workspaces and Azure Data Factory (ADF).
- Knowledge of technologies commonly used with Dynamics 365, such as DataVerse and Data Entities.
- Ability to create visually appealing and informative reports and dashboards.
- Excellent communication and collaboration skills to work with cross-functional teams.
- Azure cloud certifications are considered a significant asset.
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.
show more
We're looking for a Senior BI Specialist for a 215-day contract. This is a hybrid position where you'll work 7.25 hours per day, with the possibility of both on-site and remote work as directed. You'll be a key member of the data team, responsible for building a new data warehouse/lakehouse and delivering a minimum viable product (MVP) for reporting. You will leverage your expertise in Power BI, Dynamics 365, and data warehousing concepts to provide critical business insights.
Advantages
- Play a central role in a major data modernization project.
- Opportunity to work with and influence the design of a new data warehouse/lakehouse on Microsoft Azure.
- Work in a fast-paced environment with a focus on delivering tangible results.
- Gain experience with a wide range of data technologies.
Responsibilities
- Data Warehouse/Lakehouse Design: Analyze business requirements and design an efficient data warehouse/lakehouse on Microsoft Azure.
- Data Integration and ETL: Develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse.
...
- Data Modeling: Create logical and physical data models that align with the project's reporting needs.
- Reporting and Visualization: Develop reports, dashboards, and visualizations using Power BI, ensuring the quality and integrity of the data.
- Performance Optimization: Fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
- Data Security and Governance: Implement security controls to protect sensitive data within the data warehouse.
Qualifications
- Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and using advanced features like DAX and Power Query.
- Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.
- Strong understanding of data warehousing/lakehouse principles, including data modeling, ETL processes, data integration, and data governance.
- Strong SQL skills for writing complex queries and optimizing database performance.
- Experience with Azure data management tools, including Azure Synapse Workspaces and Azure Data Factory (ADF).
- Knowledge of technologies commonly used with Dynamics 365, such as DataVerse and Data Entities.
- Ability to create visually appealing and informative reports and dashboards.
- Excellent communication and collaboration skills to work with cross-functional teams.
- Azure cloud certifications are considered a significant asset.
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.
show more
