Senior BI Developer - Retail Liquidity Risk

Red Pico; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading financial institution seeks a Senior BI Developer to join the Retail Liquidity development team in Toronto. This role involves developing ETL processes, designing automated reports, and ensuring compliance with regulatory requirements. Candidates should have extensive experience with SQL Server and BI tools, alongside a proactive approach to project management and team collaboration.

Qualifications

• 5 years of experience in Business Intelligence / Data Warehousing on SQL Server 2012 or above.
• 5 years of experience designing and developing SSIS packages for ETL processes.
• 5 years of experience in developing automated reports using SSRS.

Responsibilities

• Transform business requirements into effective delivery solutions.
• Design and develop SSIS packages and SQL code.
• Contribute to project plans, estimations, and status updates.

Skills

Business Intelligence

SQL

ETL

Data Warehousing

SSIS

SSRS

Data Modeling

Microsoft SQL Server

Education

Undergraduate Degree or Technical Certificate

Tools

Entity Framework

Web API 2

BitBucket

Jenkins

SonarQube

Job description

The Toronto-Dominion Bank is offering a 6 Month Contract.

Work Model

2 / 3 Days a week onsite

Description

TBSM Technology Team (TTT) is looking for a Senior BI Developer to join the Retail Liquidity development team. We are looking for someone to embrace a broad range of tasks associated with developing application and systems solutions to address business challenges.

Sitting in this position will help expand your knowledge strengthen your expertise and introduce you to the inner workings of our Treasury alongside a team of seasoned diversely-skilled technology and finance professionals. Our team is made up of dynamic and strong technical leads developers and BSAs who build and maintain critical technology platforms in an Agile environment. Youll be exposed to stretch assignments as you take on large-scale complex and / or enterprise-wide projects built on the .NET stack.

TDS requires support on the following initiatives :

o Modularly rebuilding US Collateral Dashboard and ILST internal Reporting and reconciliation capabilities within TD-made application

o Rebuild will need to also consolidate wholesale and retail collateral details and implement data controls through reconciliation with 2052A.

o Leverage existing wholesale stress testing application for stress testing consolidation controls and governance capabilities including audit functionality role-based access controls completeness checks discards and exceptions.

Heres some of what you may be asked to perform :

Transform business requirements and research into winning delivery solutions that meet performance goals.

Design and develop SSIS packages for ETL processes to integrate data from various source systems.

Develop and maintain Microsoft SSAS multidimensional data cubes.

Develop SQL code / stored procedures / SQL Agent Jobs on SQL Server / MDX queries.

Design and develop automated reports using SSRS.

Design and enhance relational and dimensional data models.

Aim for defect-free programming create and maintain quality code provide support during testing cycles and post-production deployment engage in peer code reviews.

Contribute to project plans estimations and status updates.

Identify issues develop and maintain processes that address and resolve them (and be sure to communicate / alert stakeholders as needed).

Primarily focus on day-to-day activities.

Make enhancements and troubleshoot.

Configure and develop custom components with technology partners (analysts developers designers etc.) to meet requirements and goals.

Ensure applications are free of common coding vulnerabilities (and follow standard security practices).

Proactively put forward ideas that speak to project objectives (e.g. development testing solutions and tools).

Complete unit and integration testing per standards and design specs.

Take part in scope assessment risk and cost analysis.

Respect TDs technology delivery practices and standards project management disciplines.

Stay on top of state-of-health monitoring and monthly SLA targets.

Apply and share technical expertise during incident management life cycle (e.g. analyzes reports and outages perform impact assessments facilitate stakeholder communication).

Some further expectations are :

Demonstrate high level of proactivity and strong ownership.

Play technical leadership role and guide other team members.

Communicate effectively both inside and outside the team to achieve results and build strong relationships.

Develop a good understanding of Market Risk management processes in the Banking business.

Must Haves :

1) 5 years of experience in Business Intelligence / Data Warehousing on SQL Server 2012 or above

2) 5 years of experience designing and developing SSIS packages for ETL processes to integrate data from various source systems.

3) 5 Years of experience designing and developing automated reports using SSRS.

4) 5 years of develop SQL code / stored procedures / SQL Agent Jobs on SQL Server / MDX queries.

5) 5 years of experience working in financial services with a focus in capital markets investments or capital markets risk management

Nice to Haves :

1) 3-5 years of solid hands-on C# programming experience on the Microsoft stack including MVC development.

Workplace Type

Hybrid

Experience Level

The resource will have the opportunity to gain exposure to US Liquidity Risk principles and be a part of a leading delivery team to solve complex regulatory initiatives and strategic initiatives in the portfolio.

This is a fast paced and deadline driven environment to meet regulatory compliance. The resource will be exposed to a various stakeholder departments in a collaborative environment.

Additional Skills & Qualifications

Undergraduate Degree or Technical Certificate.

Experience in Entity Framework and Web API 2.

Working knowledge of BitBucket Jenkins and SonarQube

Advanced and extensive knowledge of the business (or organization) technical environment standards processes procedures programming languages and operating systems.

Readiness and motivation (as senior or lead developer and valued subject matter expert) to address and resolve highly complex and multifaceted development-related issues often independently.

Strength in coaching and advising clients partners and project teams.

Commitment to and belief in the quality of your deliverables.

Interview Information

Business Challenge

US FED Regulatory Requirements and Liquidity Risk Stress Testing requirements to be regulatory compliance imposed on TD Securities. Further to support liquidity risk in the US where technology and capabilities are under invested.

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse