Td Bank Sr Business Systems Analyst Canada, Ontario, Toronto 113827988
Job Description:
Within TBSM Technology, the Treasury Analytics Group (TAG) is dedicated to support the Treasury and Balance Sheet Management (TBSM) department in measuring and managing balance sheet, market and liquidity risks for the Bank's portfolios, both in Canada and US. This group manages technology infrastructure, processes and projects required to support various functional teams in TBSM
Examples of projects/work activities include (but not limited to):
- Onboarding new feeds to ensure completeness and accuracy of TBSM metrics
- Build extraction pipelines to support regulatory or business requirements
- Integrate third party vendor based upstream data sources or downstream analytics with Indigo
- Migration activities to the Azure Cloud
- Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production
About this Role:
- Analyze, document and validate business rules requirements from business users
- As Spark SQL is used as a programming language for the business rules, a successful candidate is required to be able to write, test Spark SQL statements to translate the business requirements into the programming code.
- Optimize performance and tune Spark SQL statements
- Use Visual Studio (SQL Integration Services) to analyze SSIS packages
- Analyze multiple system builds by completing and updating project requirements documentation; understanding project scope; determining project priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths
- Collaborate closely with the technology team to implement the requirements, provide necessary guidance to testers during QA process
- Assess business process and system inefficiencies
- Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes
- Participate in standup and planning meeting as part of the Agile methodology framework
- Works independently as the senior or lead system analyst and coaches/guides members within area of expertise
- Subject matter expert and consults with clients and/or project teams
- Reports to a Manager, Senior Manager, or Practice Lead
Experience and/or Education
- Undergraduate degree or Technical Certificate
- 5 -7 relevant experience working on large scale projects as well as handling day-to-day operational requests from the business
- Hands on experience in Advanced Excel
- SDLC / Agile methodology experience
- Over 3 years of data analysis
- Familiarity with the general concepts of optimization and performance tuning of SQL statements
- Familiaritywith RDBMS (Oracle, SQL Server)
- Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
- Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
- Being comfortable working in a distributed teams environment
- Strong problem solving skills
- Experience working in Agile
Nice to Have Skills:
- Experience in financial services industry, specifically in Capital Markets and Treasury
- Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus
- Bachelor’s degree in a STEM field
Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.
If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.
משרות נוספות שיכולות לעניין אותך
