Technical Business System Analyst – SQL

Technical Business System Analyst – SQL

ProViso Consulting

Story Behind of the Need:

• Business Group: IT Risk is seeking a Technical Business System Analyst to work on a Microsoft solution to build a data repository and reporting based on it
• The BSA is required to collect requirements, build test cases, liaise with stakeholders, coordinate the project
• Project: The group is working on Regulatory Reviews that are anticipated to be completed Q1 2023

Candidate Value Proposition:

• The successful candidate will have the opportunity to gain exposure to multiple bank streams while analyzing and ensuring regulatory data is accurate for business users.
• The successful contractor will be on a long term engagement for upwards of two years

Typical day in Role:

• Works with key stakeholders within all business functions to align technology solutions with business strategies
• Creates, defines and document business requirements, models and functional specifications to ensure that operational requirements are accurately represented in the design and delivery of Microsoft products and solutions (SQL Server and Power BI)
• Demonstrates understanding of the problems that need solving and capability to capitalize on improvement opportunities
• Oversee the design, development and implementation of system changes and upgrades while partnering with a team of developers, testers, QA and Project Managers
• Leads timely delivery of the project
• Serves as a liaison between the various groups in the organization in order to provide the best technical solutions to meet user needs
• Develops and documents processes based on information collected

Must have skills:

• 5+ years of professional experience as a Business Systems Analyst
• 5+ years of hands on experience gathering business requirements and translating them into technical requirements
• 3+ years of hands on experience understanding of how databases work – file mapping, software mapping
• 3+ years of hands on experience of Technical/Formal Documentation
• 2+ years of hands on experience PowerBI

Nice to have:

• Financial Industry experience with Regulations
• SQL experience is a plus and will be prioritized


• Bachelor’s degree in a technical field such as computer science, computer engineering or related field required. MBA or other related advanced degree


• Microsoft Teams Interview: 1 Interview through teams Situational + Behavioural (potential 2nd for top candidates)
• Decision Date: Target decision date by July 16th

Additional Notes:

• Open to resources from any industry is as long as they have relevant experience
• Manager needs someone who can hit the ground running and can start for the first week of August
• OFSI Review for the bank, leading to new demands and specifically needed to fill gap for issue management reporting
• Data management (needed for the ETL Developer – 70 – 75%) – analyze data being collected
• BSA – 70 – 75% of role will be liaising would be collecting requirements, identify sources, look for project, looking for someone who can work with skills (maybe some PM skills) to analyze data and work with stakeholders and fill gap
• BSA would be collecting data from data source owners from Directors mainly and technical team will be two developers (one PowerBI and one ETL)

Job Details



12 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend