Location Address: WFH, Toronto
Contract Duration: 6 months + possibility of extension
Story Behind the Need
• Business group: The group is supporting the technology implementations of multiple risk modelling initiatives. This project focuses on enhancements required in OFSI and NCR Reporting Methodology. New Project involving creating Power BI decks language from tableau for liquidity risk group
Candidate Value Proposition
• The successful candidate will have the opportunity to build long lasting relationships within Canadian and Global Markets. This candidate will be a key driver in ensuring stakeholders communication with the IT team is streamlined.
Typical Day in the Role:
– Gathering report requirements from the business users to translate into useful, senior-management level report visualizations
– Developing visual reports, dashboards and KPI scorecards using Power BI desktop involving pre-load and post-report parameters
– Connecting to data sources, importing, and transforming data using M Language and DAX
– Conversion of data sources, reports, and dashboards from Tableau to Power BI
– Dataflow and Data Transformation documentation of reports built for Power BI
– Able to integrate Power BI reports into other applications using embedded analytics
Must Have:
1. 5 years’ experience creating reports, dashboards with Power BI
2. 5 + years' data prep using M language to convert data with Power BI
3. 5 + years’ data transformation using Power BI
Soft Skills:
– Good communication skills required to work with the business users to explain and guide the end users
Degrees or certifications:
• Bachelor's degree required in a technical field (Computer Science, Engineering etc.)
Nice to have:
– Capital Markets experience is a plus, within Liquidity Risk
– Knowledge in tableau is nice to have *
– MS Power Apps is a plus (might be used in the feature)
– SharePoint knowledge is a plus