Senior Data Engineer

About

Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers bank’s Corporate, Investment Banking, and Capital Markets businesses.

GBME is searching for a Senior Data Engineer who is a continuous learner and is eager to boost the capabilities of capital markets data and analytics platforms. The successful candidate will have a strong engineering mindset and will work closely with business, platform, and cloud teams to deliver scalable and reliable data solutions.

Team being assembled to build a brand new application from scratch – profitability model.

Typical Day in Role

• Work closely with end users and business teams to understand data requirements, conduct gap analysis, and perform requirements assessments.
• Design and lead implementation of scalable batch and real-time data pipelines (e.g., Pub/Sub, Dataflow, Dataproc).
• Own the end-to-end lifecycle of ETL solutions, from design through development, deployment, and production support.
• Experience working with databases including Postgre SQL, SQL Server, and distributed data stores (e.g., Cloud SQL) in support of data and application platforms.
• Partner with Platform, Cloud, CRM, and Architecture teams on solution design and integration.
• Develop and maintain data models, ingestion, transformation, and validation logic.
• Define and enforce data quality, reconciliation, monitoring, and alerting standards.
• Optimize pipelines for performance, resiliency, scalability, and cost efficiency, including containerized deployments on Kubernetes / GKE where applicable.
• Support production data solutions, troubleshoot issues, and perform root-cause analysis as needed.
• Improve end-user experience by delivering reliable data products and addressing complex ad-hoc data requests.
• Effectively communicate with technical and non-technical audiences.
• Participate in SCRUM / Agile ceremonies.

Candidate Value Proposition

The successful candidate will have the opportunity to start from the ground up on a new application, on a very agile, rapid project, quick engagement with the business; looking at AI for code development so would have exposure to that, for a top 5 Canadian Bank.

Candidate Requirements/Must Have Skills

• 7+ years of experience in data engineering or ETL development roles, with hands-on experience designing and supporting enterprise-scale data pipelines.
• Advanced proficiency in SQL and experience with Python and/or Java.
• Experience integrating data via APIs, messaging systems (e.g., Pub/Sub), and file-based ingestion.
• Experience with open source workflow orchestration and scheduling tools (e.g., Cloud Composer (Airflow)).
• Experience designing, building, and supporting integrations between Salesforce and external systems (e.g., ERP, data platforms, internal services).

Nice-To-Have Skills

• Experience working with cloud platforms, preferably GCP or Azure (e.g., GKE, Cloud SQL, Pub/Sub, Dataflow, Dataproc, Cloud Composer (Airflow)).
• Experience with relational and analytical databases.
• Experience with vendor financial data providers and delivering high-quality reports, dashboards, and ad-hoc data analysis.
• Experience with CI/CD pipelines and Bitbucket-based source control.
• Experience working in regulated or financial services environments is an asset.

Education

Bachelor’s

Best VS. Average Candidate

• Past hands on experience with end to end solutions
• Hosting and developing solutions on Cloud, Kubernetes and containers
• Experience with large Salesforce implementations and solutions – around APIs, bandwidth limits etc not looking for a specific Salesforce cloud module – whether it is CDC or platform integration and knowing which to use when

Candidate Review & Selection – Interview Process

• 2-3 rounds – Teams and in Person (at least 1 face to face) – 44 King – 45 minutes interviews
  • 1st – project team
  • 2nd - tech SMEs
  • 3rd – panel

Disclaimer

• AI may be used in evaluating candidates.
• This posting is for an existing vacancy.