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 Requirements8 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 banks 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
Job Title
Lead Business Analyst – Capital Markets & SQL