Technical Analyst – SQL

Technical Analyst – SQL

ProViso Consulting

Story behind the need:

• This Project is kicking off in November and will take roughly 2 years which opens the possibility for extension.
• Business Group: The Enterprise Risk Management Solutions team provides risk based analysis to multiple high profile groups throughout client.
• Project: Technical Analyst will work closely with Audit business to review and assess business needs for improving or enhancing their audit functions from IT perspective.
• Technical analyst activities include data analysis, business requirement, solution determination, documentation and supporting system enhancements development and implementation.
• To join our team, the candidate must be proactive and dynamic, demonstrate initiative, have an eagerness to learn, be adaptable to a high-paced environment, and thrive on challenge

Candidate Value Proposition

• The successful candidate will have the opportunity to work on an expansion in the international wealth management space at one of the Big Five Banks in Canada.

Typical Day in the Role:

• Working closely with Business Analyst with regards to project needs. This would include developing solutions, overseeing installations and implementation within the applications
• Attending working sessions with the team regarding project updates
• Conducting Data Analysis and identifying any gaps within the system
• The following tools will be utilized: Microsoft OS Virtual Machines, SQL Server Databases, Microsoft Power Apps, and Teammate Plus (Wolters Kluwers)
• The technical analyst will be responsible for project documentation and communication of gaps in service and resolutions

Must Have Skills:

• 5 -7 years’ experience as a Technical Analyst
• 5-7 years’ experience working with queries
• Working experience with SQL Server Data Bases, Scripting Language, Knowledge of Data architecture and design and VM Cloud Integrations
• Experience with Application Dev. (specifically connecting Front End with Back End), system administration, & workflow and process analysis
• Analyze existing databases, Development in PLSQL

Nice to Have:

• Experience with Microsoft Power Apps
• Experience with Teammate Plus

Soft Skills:

• Communications, the successful candidates will need to effectively communicate as bridge between teams. They will be conveying project information between the BA and IT teams.

Best Vs Average:

• Experience in application dev. Installing into existing systems and implementation, system purchased and implemented into a banking environment

Degrees or certifications:

• Bachelor’s degree in Computer Science or an equivalent degree


• 1 round interview

Job Details



6 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend