Location Toronto, ON (Hybrid, 1-2 day per week in office, while other days will be remote.)

Duration 12+ Months

What You’ll Be Doing

The role is responsible for leading the functional design and development of ETL flow for Databricks across multiple teams. The resource also provides technical leadership to develop steps and standards for the ETL using current best practices.

In the team, the main functionality of the candidate will be to manage a Databricks platform built for Capital Markets to act as a central data hub and analytics tool. The candidate will be in charge of managing ETL for the applications and technologies relating to Global Funding and Resources Management. They will work with different technology to team to enable and simplify data flow into the central Databricks platform while building standards and procedures to follow and ease the transfer of data.

How You’ll Succeed

Ownership and End to End Delivery:

Understand the requirements and find avenues to fill any gaps within them. Deploy code changes and unit tests along with assisting BAs to perform functional testing. Assist QA with regression testing and make sure code is part of release timeline/package and instructions are provided to release managers. Finally verify and or assist release manager/management with deployment if necessary.

Strategic Development & Execution:

Perform and coordinate solution design activities.



Understand the requirements and translate them into system and application design that is aligned with our technology roadmap, using best practices and standards within the team and the enterprise. Design and document the technical functionality, infrastructure, interfaces, and integrations.

Strategy and Roadmap:

Contribute to technology roadmaps that are aligned with the bank’s vision, strategy, and business objectives. Lead multiple complex technology solutions while maintaining consistency across the platform, adopting best practices and pushing forward continuous improvements.

Stakeholder Management:

Act as the solution lead and interface with the project/technology teams by driving and moderating design review sessions to walk stakeholders through and ensure that the overall design aligns with business requirements as well as architectural directions.

Required Skills and Experience Critical Requirements (2+ years’ experience)

Python

SQL

ETL Processes

Good to haves:

Databricks/Snowflake (any data and analytics platform)

UI Design and Reporting

Plotly

DEVOPS – CI/CD

Other beneficial knowledge:

Banking/Financial Industry Experience (Particularly Capital Markets)

SQL Server Integration Service (SSIS)

WebAPI/Rest Services

Messaging Services (Solace/MQ)

Seniority level Mid-Senior level

Employment type Contract

Job function Information Technology

Industries Banking, Investment Banking, and Financial Services

#J-18808-Ljbffr

📌 Data Engineer (Toronto)
🏢 SPECTRAFORCE
📍 Toronto