Overview
On Site
Accepts corp to corp applications
Contract - Contract
Skills
python
ETL
spark
Snowflake
Databricks
Job Details
Job Title: Data Engineer
Location: Montreal, QC
Primary Responsibilities:
- Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
- Design and build scalable and performant databases.
- Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
- Build efficient automation scripts (using Python etc.).
- The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, kafka, and messaging so this is an excellent opportunity to play a key role in the growing team.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.