Data Engineer – Power BI & SSAS

Data Engineer – Power BI & SSAS

ProViso Consulting

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:

• Maintain and support existing Business Intelligence solutions built in Power BI Report Server, SQL Server, SSIS and SSAS
• Design and build performance-oriented BI and ETL architectures for applications handling very large volumes of data from diverse data sources
• Create wire frame and mock-ups of BI dashboards following organizational design patterns
• Design and develop Power BI dashboards and reports based on business requirements
• End-to-end testing of BI projects proofing data integrity, data consistency and optimal performance
• Compliance with organizational policies, procedures and IT Security regulations
• Write detailed technical documentation

Candidate Requirements/Must Have Skills:

• 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.
• Solid working experience of SQL Server, SSIS and SSAS. Experience with Tabular modeling with SSAS

Nice-To-Have Skills:

• Working experience with Microsoft Azure technologies in the context of Business Intelligence projects
• Power BI Embedded experience. PowerShell scripting
• Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
• MCSA BI Reporting certification or Microsoft Data Analyst certification
• Working experience in the financial industry
• Web development is an asset
• Working experience with Git and Bitbucket
• 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:
o 1st round – 1 hour panel interview with skills assessment
o 2nd round – if multiple candidates successful

Job Details



12 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend