Data Engineer

Location

Toronto, ON (Hybrid, 1-2 day per week on-site, 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