Location: WFH, Toronto
Contract Duration: 6 months
Story Behind the Need
Project Summary: The main function of the Applications Developer is to design, develop, implement, and support applications using Microsoft Power Platform and MS-SQL (e.g. PowerBI, PowerApps, PowerAutomate, MS-SQL) to support business requirements.
Job Responsibilities:
• Understand and support data sources, data models, production jobs and documentation
• Ensure production jobs run according to schedule. Monitor and fix issues coordinating with MIS counterparts in Canada, LATAM, and Caribbean if needed
• Leverage various data repositories and tooling to produce timely and impactful reports and metrics that measure the productivity, efficiency, and risk posture within Global Collections
• Design, develop, test, deploy, maintain and improve current reports, dashboards, and KPI scorecards using Power BI
• Analyze, design, develop dashboards, views, data models, DAX measures, documentation for reporting and analytics in Power BI
• Translate data into informative visuals and reports
• Validate the quality and integrity of the data included in the Reporting Packages and Dashboards
• Collaborate with data team members to automate, optimize, improve, and augment data services / capabilities
• Enhance report and data capabilities by leveraging data-oriented technologies such as Microsoft Power Platform
• Communicate effectively with divisional and local teams across the Bank
• Collaborate with Business partners, business lines to bring relevant data for analytics purposes, document and support integration of data to current date models.
Qualifications of Must Have Skills:
1. 5-7 years of hands on working experience in writing complex DAX, and SQL statements
2. 5-7 years of hands on development experience in PowerBI is required. PowerApps and PowerAutomate is desirable
3. 3+ years’ experience in SQL2008/2012/2014//2017 (SSIS, SSRS, SSAS, PL/SQL, T-SQL queries, stored procedures, functions, cursors, user defined functions, triggers, index, view).
4. Hands on experience in designing, developing and successful deployment of large scale projects from end-to-end
5. Hands on experience in following the iterative and agile SDLC
Nice to Have:
1. MSCA, MSCE, or any other MS certification is a plus
2. FI or Banking background
3. Experience with VBA scripts and SAS
4. PowerPlatform Fundamentals Certifications is an asset
Education:
Bachelor's degree in a technical field such as computer science, computer engineering or related field required