Job Description :
RQ00722 - Business Intelligence Specialist Senior Start Date - 2021-02-01 End Date - 2022-03-31 Security Level - CRJMC # Business Days - 297.00 Location: Toronto, ON Title - Business Intelligence Specialist Description MSP Notes Shortlisting Date: Friday, January 22nd at 2:00 pm EST Maximum number of Candidate Submissions: 1 (One) Role: - Ministry needs some support to augment their BI team. Currently they have a team of BI specialists that work on a number of priorities and are looking for an extra resource to add capacity for this team. Specific projects this resource will be working on: Running data warehouse and data services, Enabling and making use of our ETL tool, enabling system integrations that need access to that data, new reporting and data presentations services, setting up a Power BI services for a group of users that need real-time dashboarding. Must-haves 3-5+ years of Microsoft Cloud experience Experience with ETL and Power BI Note Assignment Type: This position is currently listed as "Onsite" due to COVID-19 related WFH direction. Once OPS staff are required to return to the office, the resource under this request will be required to work onsite as well. The resource will work with the HR Data Services and Reporting team on the following priorities: o Enabling secure, automated extraction, transformation and loading of data into the HR data warehouse from existing systems o Automating direct integrations with secondary systems requiring access to HR data to support their operations or deliver services o Enabling easier, more direct access to data, reports or data presentation services (PowerBI), based on the needs of each program area The resource supports wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized query applications which analyze key business data. Also develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of "opportunity" and "key-trend" alerts. Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.