Job Postings
Sr. Business Systems Analyst: SQL, Spark
at
TD
Sr. Business Systems Analyst: SQL, Spark
  • Company
    TD
  • Location
    Toronto, Ontario, Canada
  • Type
    Full-time
  • Date Posted
    December 25, 2024
**Job Posting: Data Analyst - Treasury Analytics Group**

**Location:** Toronto, Ontario, Canada
**Hours:** 37.5
**Line of Business:** Technology Solutions
**Salary Range:** $76,800 - $115,200 CAD

TD is committed to providing fair and equitable compensation opportunities and encourages open dialogue regarding remuneration.

**Department Overview:**
The Treasury Analytics Group is responsible for the measurement and management of market risk for the Bank's retail portfolios. The team is embarking on a new initiative to build a strategic platform for risk, valuations, and analytics. This exciting opportunity involves working with cutting-edge technologies such as Big Data and NoSQL databases.

**Key Responsibilities:**
- Analyze, document, and validate business rules requirements from users.
- Write and test Spark SQL statements to translate business requirements into programming code.
- Optimize performance and tune Spark SQL statements.
- Use Visual Studio (SQL Integration Services) to analyze SSIS packages.
- Collaborate with the technology team to implement project requirements.
- Participate in standup and planning meetings in an Agile framework.

**Qualifications:**

**Mandatory Skills:**
- Over 3 years of data analysis experience.
- Experience working on large-scale projects.
- Familiarity with SQL optimization and performance tuning.
- Knowledge of RDBMS (Oracle, SQL Server).
- Strong relationship-building and communication skills.
- Ability to manage multiple tasks and work in distributed teams.
- Bachelor's degree in Computer Science, Electrical Engineering, Information Technology, or Statistics.

**Preferred Qualifications:**
- Experience in the financial services industry, specifically in Capital Markets and Treasury.
- Familiarity with Big Data and NoSQL databases and Spark SQL.

**Additional Information:**
- Inspire a positive work environment and collaborate with both technical and non-technical professionals.
- Build trust with business and technology partners.
- Participate in TD's commitment to productivity and operational efficiency.

**Total Rewards Package:**
TD offers a competitive Total Rewards package, including base salary, variable compensation, health benefits, savings programs, paid time off, and career development opportunities.

**Colleague Development:**
Regular career conversations, training programs, and support for your professional growth are part of our commitment to your success.

**Application Process:**
Candidates of interest will be contacted for an interview. Please inform us of any accessibility requirements during the interview process.

We look forward to hearing from you!