Location Address: Hybrid - Downtown Toronto – 1 day/week (Wednesdays, subject to change to increase to 3 days in October) – need candidates in GTA
Contract Duration: 1 year
Possibility of extension
Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week
Reason: Backfill
Typical Day in Role:
• Design, develop and deploy Power BI/data visualization solutions (simple to sophisticated) to designed user requirements/specifications.
• Conduct requirements analysis and translate data into informative reports, dashboards and KPI’s.
• Connect to data sources, import data, and transform data for Business Intelligence.
• Support data model enhancements with analysis and solution recommendations.
• Research, analyze, recommend & implement new methods for developing Power BI solutions.
• Support steady-state Power BI reports.
• Develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects. Create exploratory data analysis, reports, dashboards to surface data for different stakeholders.
• Collaborate with IT team to develop/maintain/manage SQL Server database Global Operational Risk entities.
• Provide data to business users from SQL Server on ad-hoc basis.
• Perform data integrity checks for data completeness.
• Act as a bridge between IT team and GOR for any database needs.
• Support project delivery with database analytics, mapping, profile comparison, PowerBI reporting enhancements.
• Escalate to Senior Manager for assistance and/or escalation purposes, to quickly analyze problems and resolve escalated issues, and provide recommendations to management regarding resolution
• Database work and visualization for creating dashboards
• Extract and design data, and build dashboards accordingly
Candidate Requirements/Must Have Skills:
1. 8+ years of expert experience in designing, developing, and deploying Power BI/data visualization solutions i.e., reports and dashboards (simple to sophisticated) by translating business requirements to design data models and develop visualizations
2. 8+ years’ experience as a Developer using SQL and Power BI
3. 8+ years’ of demonstrated experience with data analysis
4. 8+ years’ experience with data visualization, data modeling & UX standard methodologies
5. Expert proficiency in Excel
Nice-To-Have Skills:
1. Experience with Operational Risk - Understanding of Operational Risk processes and metrics will be a plus
2. Business analysis & consulting ability - Experience at writing business & user requirements
3. Experience in data extraction, transformation and loading process (ETL)
Soft Skills Required:
• Ability to translate technical knowledge into business value.
• Strong communication skills to be able to communicate with various stakeholders/external teams
• Working collaboratively – strong team player
• Capable of adapting quickly, managing multiple demands & competing priorities, while delivering deadlines
• Proven abilities to take initiative and be innovative.
Education:
Undergraduate Degree or higher and /or 8+ years of relevant functional and/or technical experience
Best VS. Average Candidate:
The best candidate will be an expert using SQL; power BI and strong data analysis skills and will have excellent communication skills; able to create dashboard in BI and design data models that provide actionable insights.
Candidate Review & Selection
1 round – In person Interview – 45 minutes – with HM and another team member
Background and experience, examples from previous jobs, behavioral and technical questions; possible technical component of demonstrating solutions in interview