PowerBi/SQL Developer

Location Address: Hybrid - Downtown Toronto – 1 day/week (Wednesdays, subject to change to increase to 3 days in October) – need candidates in GTAContract Duration: 1 yearPossibility of extensionSchedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/weekReason: BackfillTypical 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 accordinglyCandidate 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 visualizations2. 8+ years’ experience as a Developer using SQL and Power BI3. 8+ years’ of demonstrated experience with data analysis4. 8+ years’ experience with data visualization, data modeling & UX standard methodologies5. Expert proficiency in ExcelNice-To-Have Skills:1. Experience with Operational Risk - Understanding of Operational Risk processes and metrics will be a plus2. Business analysis & consulting ability - Experience at writing business & user requirements3. 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 experienceBest 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 & Selection1 round – In person Interview – 45 minutes – with HM and another team memberBackground and experience, examples from previous jobs, behavioral and technical questions; possible technical component of demonstrating solutions in interview