Sr.SQL Analyst (US)

Work Location:

Mount Laurel, New Jersey, United States of America

Hours:

40

Pay Details:

$87,000 - $164,000 USD

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs. 

As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

Line of Business:

Technology Solutions

Job Description:

The Sr. SQL Analyst performs systems analysis assignments with varying degrees of supervision. The Sr. SQL Analyst also provides complex technical business support to clients that utilize small/midsize/enterprise level systems.

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
 
Day to day :

• Onboarding new feeds to ensure completeness and accuracy of TBSM metrics.
• Build extraction pipelines from Indigo to other applications to support regulatory or business requirements.
• Integrate third party vendor based upstream data sources or downstream analytics with Indigo.
• Migrate Indigo to the Azure Cloud.
• Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production.
• 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
• Work with members of the team to put together estimates for work packages.
• Assess business process and system inefficiencies
• Develop a solid understanding of the Indigo platform and adjacent applications including both strengths and limitations, so that the candidate can become a voice of authority and a strategic influencer.
• Participate in standup and planning meeting as part of the Agile methodology framework
• Coach, mentor and/or lead a team of junior SQL Analysts.
• Review work of junior SQL Analysts. 

Depth & Scope:

• Communicates with programmers to ensure understanding of business processes and requirements of the users. Works with programmers to ensure that the delivered system matches the specified features and functions
• Assesses available technologies recommending innovative and cost-effective solutions
• Analyzes business challenges and recommends appropriate IT solutions and services
• Maps current business processes to new systems and supports the transition to the new solution
• Determines interface requirements for effective system transition
• Resolves issues that cross multiple systems or departments that may affect the business process
• Develops detailed specification documents that include features and functions of the new system
• Develops test plans and test case scenarios to guarantee the new system design meets business requirements
• Implements new system installations, upgrade and conversions
• Documents selected system parameters, file layouts and application design layouts. Tracks open issues and resolution of issues

Education & Experience:

• 4 Year Degree or equivalent experience
• 7+ Years of related experience
• Excellent communications, problem-solving and decision making skills
• Progressively responsible experience in large scale corporate systems analysis
• Previous management experience required
• Ability to work with systems users or potential users to develop system specifications and requirements, applying business systems knowledge to ensure relevant areas of research are addressed
• Ability to independently translate user requirements into technical specifications

Preferred Qualifications:

• Experience leading a team of SQL Analysts.
• 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

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.

Our Total Rewards Package

Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical and mental well-being goals. Total Rewards at TD includes base salary and variable compensation/incentive awards (e.g., eligibility for cash and/or equity incentive awards, generally through participation in an incentive plan) and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off (including Vacation PTO, Flex PTO, and Holiday PTO), banking benefits and discounts, career development, and reward and recognition. Learn more

Additional Information:
We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Colleague Development
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.

Training & Onboarding
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process
We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation

If you are an applicant with a disability and need accommodations to complete the application process, email the TD Bank US Workplace Accommodations Program at USWAPTDO@td.com. Include your full name, best way to reach you, and the accommodation needed to assist you with the application process.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.