Business System Analyst – Wealth

Business System Analyst – Wealth

ProViso Consulting

Story behind the need:

• Business group: The Wealth ETL team within the client Wealth Management technology area is key to meeting the operational data needs of the various stake holders within Wealth Management.
• Project: The Business Systems Analyst will be joining a team that is key in sourcing the data from the key wealth systems and transforming the data to meet the business objectives. Working on multiple projects; the candidate will analyze data sources, map the data as per business needs, create technical specifications and work with the developers to transform data to meet business requirements

Candidate Value Proposition

• The successful candidate will be working with cutting edge technology in a large enterprise environment. Supporting multiple business lines, the candidate will be exposed to various groups within Wealth Management.

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/Requirements:

• 5+ years’ experience in technical system analysis in Wealth domain
• 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 ETL tools such as DataStage
• Knowledge of scheduling tools such as Autosys
• Recent project experience using Broadridge book of record*

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

Job Details



6 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend