Senior Data Analyst to provide business intelligence support using Power BI, SQL and AI with one of our major banking clients-
Office Location : Hybrid 2-3 days in office (Wednesdays and Thursdays or on any need basis) - Toronto
Contract Duration : 6 months (Possibility of Extension)
Hours : Monday-Friday, 8 : 30AM-5PM (7.5 hours / day)
Story Behind the Need :
- Credit Risk Data & Analytics Responsible for GRM business banking, data consolidation, data governance and risk reporting.
- The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.
The candidate will be working on multiple projects during the assignment.
Typical Day in Role :
- Collaborate with cross-functional teams to design and implement Business Intelligence solutions.
- Design, implement, automate and maintain large scale enterprise data ETL processes
- Create and maintain comprehensive documentation, including process maps, requirements specifications, and user guides.
- Design, develop, and maintain Power BI dashboards to visualize key business metrics.
- Perform data analysis to support decision-making and strategic planning.
- Monitor and evaluate the effectiveness of implemented solutions and recommend adjustments as needed.
- Provide ongoing support and training to end-users.
- Lead efforts to troubleshoot any issues or discrepancies between expected results and actual results
Must-Have skills :
- 10+ years of experience as a Business Analyst, Data Analyst , or in a similar role.
- 10+ years of experience in business analysis tools and software (e.g., Microsoft Excel, SQL).
- 10+ experience with Power BI or any business intelligence tool including creating and managing dashboards.
Nice-To-Have Skills :
Experience working on Artificial intelligence (AI) solutions (GENERATIVE AI) is a plus.
Best vs. Average Candidate :
The best candidate is someone with the combination of knowing SQL, Power BI and has a background in the financial sector.
The best candidate is someone with hands-on experience with BI Data Modelling (Not only concepts) and someone who meets the soft skills.
Education :
Bachelor’s degree in business administration, Information Technology, or a related field.
Candidate Review & Selection
- 1st round MS Teams video Panel interview HM (45 minutes)
- Introductions Technical round to determine skills and match with the team and role.
- 2nd round MS Teams video interview Hiring manager, Senior manager and Director (30 Mins)
- Discuss candidate’s skills / experience and gauge the depth of their knowledge, behavioural questions.
- Technical questions
- Assess match for team culture