Power BI Developer
Location Address: WFH (Toronto)
Contract Duration: 1 year
Extension: Yes, based on performance and funding
FTE: No
Number of Positions: 1
Schedule Hours: 8:30am-5pm, Monday-Friday
Story Behind the Need
• Business group: Operations Design & Solutions
• Project: We require a Data Engineer to build a back end and front end of a Reporting Process and create Front end Dashboard.
• Reason for request: The developer is required to work on a project. Funding has already been approved on respective business case.
Candidate Value Proposition
• The successful candidate will have the opportunity for exposure to business lines and gain familiarity with the business processes at the bank.
Typical Day in Role
1) Maintain and support existing Business Intelligence solutions built in Power BI Report Server, SQL Server, SSIS and SSAS
2) Design and build performance-oriented BI and ETL architectures for applications handling very large volumes of data from diverse data sources
3) Create wire frame and mock-ups of BI dashboards following organizational design patterns
4) Design and develop Power BI dashboards and reports based on business requirements
5) End-to-end testing of BI projects proofing data integrity, data consistency and optimal performance
6) Compliance with organizational policies, procedures and IT Security regulations
7) Write detailed technical documentation
Candidate Requirements/Must Have Skills:
1) At least 3+ years of work experience developing with Power BI Report Server and DAX and data analysis with, but not limited to, Microsoft Technology.
2) Solid working experience of SQL Server, SSIS and SSAS. Experience with Tabular modeling with SSAS is a must
Nice-To-Have Skills:
1) Working experience with Microsoft Azure technologies in the context of Business Intelligence projects
2) Power BI Embedded experience. PowerShell scripting
3) Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
4) MCSA BI Reporting certification or Microsoft Data Analyst certification
5) Working experience in the financial industry
6) Web development is an asset
7) Working experience with Git and Bitbucket
8) Project management skills desirable
Soft Skills:
• Strong communication skills, verbal and written
Best vs Average:
• Ability to understand business complexities and translate them into technical terms to solve problems
Degrees or certifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
Candidate Review & Selection
• Structure and Format:
• 1st round – 1 hour panel interview with skills assessment
• 2nd round – if multiple candidates successful