Role ; BSA _with Strong SQL

Location: Toronto, ON (Hybrid)

Term: Fulltime

• Lead a team of BSA to analyze and understand business and data requirements to develop complete Intraday Liquidity data conform/matching process, including data models (entity relationship diagrams, dimensional data models), ETL and business rules, data lineage, metadata and reporting elements.
• Participate in data analysis and project testing across numerous environments on various technology platforms including TD trading and payment systems.
• Transform business requirements and research into winning delivery solutions that meet performance goals.
• Develop effective and efficient solutions by researching/analyzing issues, defining opportunities for business process improvements and making recommendations within assigned area of responsibility.
• Define, document, and translate high level business requirements into detailed function specifications as outlined by managers and/or stakeholders.
• Review technical deliverables for quality throughout detailed design and development phase, identify gaps or redesign as needed.
• Define metrics and performance goals with technology partners and peers.
• Identify ways to minimize cost, play a role in introducing strategic solutions to support cost effectiveness and enhance stakeholder experience.
• Identify and address any issue that affects the integrity of the application (e.g. cross-capability/release issues).
• Demonstrate high level of proactivity and strong ownership.
• Communicate effectively both inside and outside the team to achieve results and build strong relationships.

Job Requirements

• 8 to 10 years relevant experience.
• Hands on experience in doing analysis for delivering trade messaging components/solutions for trading workflows across a variety of capital market asset classes like FX, Equity, Fixed Income, Derivatives, etc.
• Strong knowledge of end-to-end bank's payment lifecycle/workflows for multiple asset classes, protocols as SWIFT, etc.
• Experience and strong knowledge in writing complex SQL statements.
• Data mappings and transformations across multiple systems.
• Strong keenness in completing the data onboarding and analysis by validating/testing with business stakeholders.
• Strong communication, verbal, written, and presentation skills.
• Advanced knowledge of tools (e.g. Microsoft Office Excel, Word, Power Point, Jira, and Confluence).
• Sound to advanced knowledge of business analysis principles and project lifecycles.
• Commitment to applying advanced to expert knowledge of business technology delivery practices and standards and related expertise, including design, development, testing and project management.
• Advanced to expert knowledge of system analysis process and techniques, as well as system components, functionality, interfaces, data flows and business rules.
• Talent in identifying risks both within and across projects and recommending ways to mitigate them.
• Strength at managing and directing activities related to analysis, design, testing, deployment, and support of technical business solutions on larger projects.
• Commitment to and beliefs in the quality of your deliverables.

Other Qualifications/Skills/Experience:

• Experience with Scrum/Agile development methodology.
• Proactive, organized, excellent analytical and problem-solving skills.

Works well independently, as well as within a team