Bus Sys Analysis Specialist at TD Bank
Toronto, ON, Canada -
Full Time


Start Date

Immediate

Expiry Date

14 Sep, 25

Salary

91200.0

Posted On

16 Jun, 25

Experience

7 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Business Requirements, Large Scale Projects, Sql, Tuning, Big Data, Capital Markets, Programming Languages, Oracle, Optimization, Communication Skills, Agile Environment, Sql Server

Industry

Information Technology/IT

Description

REQUIREMENTS:

  • Undergraduate Degree or Technical Certificate
  • 7+ years relevant experience
  • Experience working on large scale projects as well as handling day-to-day operational requests from the business stakeholders
  • Strong RDBMS (Oracle, SQL Server) hands on experience; SQL language
  • Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
  • Ability to work independently and as part of the team in Agile environment
  • Strong problem-solving skills
  • Familiarity with the general concepts of optimization and performance tuning of SQL statements
  • 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 with strong problem solving skills

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
  • Familiarity with other programming languages is a plus (e.g., Python)

WHO WE ARE:

TD is one of the world’s leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.
TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

Responsibilities
  • Lead business requirements elicitation, analysis, and documentation efforts
  • Assist technology team in Azure cloud solution implementation; write Spark SQL queries to analyze and transform data; provide feedback to User Interface team; testing and documentation
  • Analyze solution requirements; understand project scope; determine project priorities; ensure efficient and on-time delivery of project tasks and milestones; follow proper escalation paths
  • Look for opportunities for process improvement and automation
  • 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
Loading...