RQ09728 Sr. Business Intelligence Specialist

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

RQ09728 - Sr. Business Intelligence Specialist

Onsite / 595 Bay Street Toronto (Managers discretion for hybrid)

Contract (8 months)

CRJMC Credit Check (Must get clearance before start date)

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-haves:

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

RQ09728 - Sr. Business Intelligence Specialist Onsite / 595 Bay Street Toronto (Managers discretion for hybrid) Contract (8 months)CRJMC Credit Check (Must get clearance before start date) As a member of the data team you will be responsible to help define the MVP for reporting build the new data w...