RQ09728 - Sr. Business Intelligence Specialist

RQ09728 - Sr. Business Intelligence Specialist

Onsite / 595 Bay Street, Toronto (Manager's 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