RQ10090 Business Intelligence Specialist Senior

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

RQ10090 - Business Intelligence Specialist - Senior

8-month contract

Onsite / 595 Bay Street Toronto

1 Opening - 1 Submission

Justice Technology Services - Ministry of Public and Business Service Delivery and Procurement

Security Level: CRJMC Credit Check

Scope

The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer to help build a new data warehouse/lakehouse and deliver the reporting MVP (minimum viable product).

Assignment Deliverables

As a member of the data team you will be responsible to help define the MVP for reporting build the new data warehouse/lakehouse and deliver the required reporting. A high-level list of deliverables for the data migration team follows:

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 projects 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.

Must have:

Power BI: Proficiency in Power BI including data modelling 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

RQ10090 - Business Intelligence Specialist - Senior 8-month contract Onsite / 595 Bay Street Toronto1 Opening - 1 Submission Justice Technology Services - Ministry of Public and Business Service Delivery and Procurement Security Level: CRJMC Credit Check Scope The Office of the Public Guardian and...