Business Intelligence Specialist – Senior

Toronto, ON (Onsite)

Contract position

Duration: 229 days

Closing Date/Time 2025-07-16, 1:30 p.m.

Max no of submission- 3(three)

Must haves:

Power BI: 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.;

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

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;

Criteria 1: Data Warehouse - 25 Points

- Demonstrated experience developing reports in a Data Warehouse/ Lakehouse.

Experience with supporting a data warehouse in a production environment

- Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.





- Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools.

Criteria 2: PowerBI - 25 Points

- Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.

Criteria 3: SQL / DB - 20 Points

- Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning

- Demonstrated experience with SQL Server, Oracle, Azure SQL Databases

- Experience with SSIS, SSRS

Criteria 4: Dynamics 365 - 20 Points

- Robust understanding of the Dynamics 365 data model, entities, and relationships.

- Experience developing reports from source data from Dynamics 365 CE or F&O.;

- Familiarity with Dataverse and Power Platform application development.

Criteria 5: Azure Platform - 10 Points

- Experience with Azure Data Factory (ADF) and Synapse Workspaces

- Demonstrated experience Azure data management tools, DevOps,

- Azure cloud certifications

📌 Business Intelligence Specialist – Senior (Toronto)
🏢 Damco Solutions
📍 Toronto