Data Engineer

Montreal

Offre publiée le 2025-03-10

Soho Square Solutions

Job Title : Data Engineer

Department : TEDRA (Trade Enrichment Data Reporting & Allocations)

Contract Duration : 1 Year

Work Arrangement : 3 Days Onsite, 2 Days Remote

Position Overview :

The TEDRA department is part of the Institutional Securities Technology (IST) Division. TEDRA is responsible for maintaining, distributing, and reporting on trading, revenue, risk, and reference data (client, product, and pricing). As the authoritative source of key data sets, we are at the forefront of database technology and are heavily involved in data engineering, data science, data visualization, and machine learning efforts across the Firm.

Primary Responsibilities :

  • Translate Business Requirements :
  • Create queries against relational tables and produce reports based on business needs.
  • Database Design :
  • Design and build scalable and performant databases.
  • ETL Development :
  • Develop and maintain ETL processes, including stored procedures, queries, performance tuning, and archiving using Python, SQL, and ETL tools.
  • Automation :
  • Build efficient automation scripts using Python.
  • Collaboration :
  • Work closely with globally distributed business owners, subject matter experts, and support partners.
  • Agile Methodology :
  • Participate in Agile practices such as time boxing, daily scrum meetings, retrospectives, continuous integration, refactoring, and unit testing.

Required Skills :

  • Relational Database Skills :
  • Strong experience with DB2, Postgres, and Greenplum.
  • Proficiency in creating high-quality and optimized stored procedures and queries.
  • Knowledge of relational database performance and tuning (indices, database statistics, de-normalization).
  • Big Data Tools :
  • Knowledge of Spark, Snowflake, and Databricks is desirable.
  • Modeling Tools :
  • Experience with Power Designer or similar tools.
  • Programming :
  • Proficiency in Python and Unix / K-Shell.
  • Trade Lifecycle :
  • Familiarity with the lifecycle of a trade and data flows in investment banking operations.
  • Agile Development :
  • Experience with Agile methodologies (Scrum, XP).
  • Education Level :

  • Bachelor's Degree
  • Experience Level :

  • Level 3 (five to eight years of experience)