Job Title :: Data Engineer
Location :: Montreal (day 1 onboarding onsite / in-office presence required 3x/week)
Years of experience :: 5-10
Primary Responsibilities
1. Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
2. Design and build scalable and performant databases.
3. Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
4. Build efficient automation scripts (using Python etc.).
Technical Skills Requirement:
•
Strong relational database skills especially with DB2/Sybase/SQL Server or/and Postgres/Greenplum.
Kafka and MongoDB knowledge is a plus. However, willing to train.
Knowledge of Spark, Snowflake, and Databricks is desirable.
Create high quality and optimized stored procedures and queries.
Experience with Power Designer or some similar modeling tool.
•
Python and Unix / K-Shell.
• Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts.
Familiar with lifecycle of a trade and flows of data in an investment banking operation.
Experienced in Agile development process.
Effective communication skills.