Data Engineer - Montreal, QC - Fulltime Opportunity

Description du poste

Role: Data Engineer

Location: Montreal, QC (Hybrid 4 days)

Duration: Fulltime Opportunity

Experience: 4+ years

Responsabilités clés

• Design and build scalable ETL pipelines to ingest, transform and load large volumes of OTC derivatives data for downstream reporting and analytics.
• Develop and optimize database objects, stored procedures and batch processes that support ETL workflows, report generation and data delivery.
• Design data models, schemas, SQL views and stored procedures to support efficient ETL processing and regulatory, operational and business reporting.
• Build and maintain real-time and batch ETL pipelines for trade and confirmation data ingestion, transformation, reconciliation and report-ready data provisioning.
• Support data migration and onboarding activities by building validation routines, reconciliation checks and ETL cutover processes to ensure reporting continuity.
• Develop, automate and support regulatory and business reports using Python, SQL stored procedures and enterprise reporting platforms such as Business Objects and Tableau.
• Write complex SQL queries, stored procedures and reusable reporting logic to generate accurate, timely outputs for business users and regulatory consumers.
• Ensure strong data controls, access governance and quality checks across ETL pipelines, reporting datasets and database environments.
• Participate in Agile delivery and contribute to automation, scheduling and CI/CD practices for ETL jobs, reporting workflows and production deployments.
• Provide production support for ETL and reporting processes, including job monitoring, issue triage, data reconciliation and root cause analysis.

Compétences requises

• 3-5 years of experience in ETL and reporting development
• 3-5 years of experience with SQL and writing stored procedures
• 3-5 years of experience building ETL pipelines
• 3-5 years of experience in Snowflake and DB2 databases.
• Strong knowledge of SQL for reporting and data analysis
• Have Worked in Agile, DevOps and Git
• 3-5 years of experience with Python for ETL and report generation
• Perform of data validation and reconciliation.
• Knowledge of reporting tools such as Business Objects or Tableau is good to have.
• Experience in cloud platforms (Azure/GCP/AWS) good to have

Compétences personnelles

• Good data Analytical skill
• Integrity, ownership and strong team player.
• Works well under time and resource constraints.
• Finds simple and effective solutions.
• Self-motivated to grow technically and in domain knowledge.
• Clear communicator across globally distributed teams.