Business Intelligence

📢 Hiring – RQ10945 | Business Intelligence Specialist - Senior
Client: Ministry of Public and Business Service Delivery and Procurement
📍 Location: 595 Bay Street, Toronto, Ontario (Onsite)
📅 Contract Duration: June 2026 – March 2027 (Extension Possible)
⏰ Hours: 7.25 Hours/Day
🔒 Security Clearance: CRJMC + Credit Check

Must Have:
• 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 and utilizing advanced features.
• Data Integration: Knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse. Proven experience with ETL tools and technologies, such as Azure Synapse.
• Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).

Experience and Skill Set Requirements

Criteria 1: Data Warehouse/Lakehouse - 25 Points
• Demonstrated experience developing reports in a Data Warehouse/Lakehouse.
• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.

Criteria 2: Power BI Experiences - 25 Points
• Demonstrated knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse.
• Familiarity with ETL tools and technologies, such as Azure Synapse.
• Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.

Criteria 3: Data Integration and Extraction - 25 Points
• Demonstrated knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse.
• Familiarity with ETL tools and technologies, such as Azure Synapse.
• Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.

Criteria 4: D365/Azure Knowledge - 25 Points
• Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
• 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.