Job Title: Business Systems Analyst
Location: Toronto, ON
Duration: until Jan 31st

Our large financial client's Global Wealth Technology Group is seeking a Senior Technical Business Systems Analyst who will play an important part in the team and help the team achieve the desired goal. The project is already in flight and is anticipated to go on till the end of FY21.

Large, high-visibility program for Canada's biggest international bank
Opportunity to work with newer technology stacks

Typical Day in Role:

• Contributes towards identifying, documenting and mapping sources for existing data as well as new data sources. Very good understanding of databases and writing complex queries • Provide ad hoc data queries or reports to the business for analysis using variety of query tools • Evaluation of data identified from multiple sources, reconcile conflicts and classification of data in logical categories • Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats • Improves systems by studying current practices; designing modifications.

• Participate in technical design sessions, working with technical resources, to provide insight during solution development • Recommends controls by identifying problems; writing improved procedures • Participate in Sprint planning and estimation efforts to implement the user story • Work with the team members in the team and other analytics team members to understand business data and analytics objectives and help create reports using BI tools

Must Have Skills

5+ years’ experience in technical system analysis in wealth management/ financial industry
5+ years’ experience with relational databases with a good knowledge of SQL Scripting, database structures, principles and design theories
Advanced skills using Excel spreadsheet and VBA (Highly analytical and good understanding of databases, technical architecture and query tools) – 5+ years of hands on experience
Experience gathering requirements (will need to interface with Business Partners & Stakeholders – should be able to connect and communicate well with them), system analysis and creating technical specifications – 5+ years of experience
Ability to effectively convey ideas to business and technical teams – 5+ years of hands on experience
Experience working in Agile/ Lean delivery teams- 3+ years

Nice to Have Skills:

– Knowledge of Data Lake or Big Data technologies

Soft Skills:

• Excellent verbal, written and presentation skills (will be gathering requirements from Business Partners and Stakeholders) • Ability to adapt and quickly adjust to change • Ability to work with cross functional teams • Should be a team player and work collaboratively

Education/Certificates:

– Degree in Computer Science or related field or equivalent experience.

Interview Process:

– 2-Step Process: 15-30 min phone screening with Hiring Manager & 1hour Technical Skype interview with 2 BSA Leads + Architect

o Panel interview – questions associated to Wealth (knowledge of securities, what are transactions, positions, holding, different services offered (i.e. retail brokerage), high level business lines

– Interviews to take place ASAP

Additional Notes:

– Want to ensure the candidates have strong technical experience, not just BA with only business experience

– Need someone who has worked in development environments as opposed to the business side

– Should understand how market value is calculated and the assets client can hold

– Will be doing a lot of Wealth Analysis