Data Engineer - Datamarts Analytics

Compunnel, Inc.; Montreal; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to enhance their Datamarts Analytics team. This role focuses on managing high-volume data environments and requires expertise in relational databases, particularly DB2 and Sybase. The ideal candidate will engage in database infrastructure engineering, application development, and performance tuning within an Agile/Scrum setup. Collaborating with global partners and IT stakeholders is essential to drive business success. If you are passionate about data and thrive in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 3-5 years of experience with relational databases, especially DB2 or Sybase.
• Strong scripting skills in Perl, Python, or Unix/Korn Shell.

Responsibilities

• Perform database infrastructure engineering for stability and scalability.
• Develop and optimize SQL queries and ETL workflows.

Skills

DB2

Sybase

SQL

Python

Perl

ETL

Performance Tuning

Education

Bachelor's in Computer Science

Master's in Computer Science

Tools

Tableau

QlikView

Business Objects

Hadoop

MongoDB

Greenplum

Job description

The Client department seeks a skilled Data Engineer to join the Datamarts Analytics team. The team manages and develops databases across multiple business divisions, including front office trading, reference, finance, and risk data. The role involves the development and maintenance of high-volume data environments utilizing technologies such as Sybase, DB2, Greenplum, Hadoop, MongoDB, and business intelligence platforms like Tableau, QlikView, and Business Objects.

This position involves a combination of database infrastructure engineering, application development, performance tuning, and ETL pipeline development within an Agile/Scrum environment. Strong collaboration and communication with global business partners and IT stakeholders is required.

Job Responsibilities

• Perform database infrastructure engineering for stability, scalability, and capacity planning.
• Execute application DBA tasks including schema changes, bottleneck analysis, performance optimization, maintenance, and recovery.
• Develop and optimize stored procedures, SQL queries, and ETL workflows.
• Enforce database security policies, standards, and guidelines.
• Support project life cycle activities such as design, testing, implementation, and release.
• Collaborate with IT partners and engineering teams to meet business requirements.
• Provide Level 3 support and participate in the team’s on-call rotation.

Required Skills

• 3–5 years of experience with relational databases – particularly DB2 Linux or Sybase.
• Scripting experience on Linux platforms using Perl, Python, or Unix/Korn Shell.
• Deep understanding of RDBMS performance tuning: indexing strategies, statistics, memory/configuration optimization, etc.
• Proficient in writing high-quality, efficient SQL queries and stored procedures.

Preferred Skills

• Experience with Greenplum, Hadoop, or MongoDB.
• Exposure to data lakes and large-scale data environments.
• Familiarity with CI/CD tools and Agile development practices.
• Background in finance or investment banking is a strong plus.
• Graduate degree in Computer Science, Information Systems, or related field.

Certifications

[Specify if any certifications are required or preferred, such as DB2/Sybase certification, AWS Big Data, etc.]

Education

Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related technical field.