This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Our client is looking for a Senior Business Intelligence Specialist for a 7 month contract in Toronto. This is an onsite role.
Job Responsibility:
Data Warehouse Design: analyze business requirements and design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure
Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse/lakehouse (bronze/silver/golden layers). Help integrate data from diverse sources into the new data warehouse
Data Modeling: create logical and physical data models that align with the project’s reporting and analytical needs
Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse
Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports
Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency
Other duties as assigned
Requirements:
Proficiency in Power BI, including data modeling, creating interactive reports and dashboards and utilizing advanced features
Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O
Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance
Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues
Proficiency in designing logical and physical data models
Ability to create visually appealing and informative reports and dashboards using Power BI
Knowledge of data security principles, data governance practices, data quality management, and data lifecycle management
Strong analytical thinking and problem-solving abilities
Effective communication skills
Collaboration skills to work with cross-functional teams
Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps)
Experience with SQL Server Management Studio, Azure data management tools, data modeling tools
Experience with SSIS, SSRS
Nice to have:
Azure cloud certifications (e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)
Experience with PowerApps platform, Power Automate, Dynamics CE and F&O
What we offer:
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