ETL Developer

ETL Developer

• Location : Montreal (Please submit only local)
• In-Person Interview is mandatory for this role.

Role:

DB / ETL Candidate should have strong experience in Snowflake, ETL development, data modelling, and SQL. The ideal candidate will play a key role in designing, building, and optimizing scalable data pipelines and warehouses to support data analytics and business intelligence initiatives.

Required Skillset

• Strong hands-on experience with Snowflake, including schema design, performance tuning, and cost optimization.
• Proficiency in SQL and database development best practices.
• Experience with ETL / ELT tools (e.g., Informatica, Talend, dbt, Matillion, or custom Python / SQL pipelines).
• Solid understanding of data modelling concepts (star / snowflake schema, normalization / denormalization).
• Experience working with cloud platforms such as AWS, Azure, or GCP is a plus.
• Familiarity with version control (e.g., Git), CI / CD, and Agile development methodologies.

Responsibilities

• Design, implement, and optimize data pipelines using ETL / ELT tools and frameworks.
• Develop and maintain data models (conceptual, logical, and physical) to support scalable and performant data solutions.
• Build and maintain scalable data warehouses in Snowflake, ensuring efficient storage and fast query performance.
• Write complex and efficient SQL queries for data extraction, transformation, and reporting.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions.
• Monitor and troubleshoot data pipelines to ensure reliability, performance, and data quality.
• Implement data governance, security, and compliance best practices within the data environment.
• Automate data pipeline processes using scripting and orchestration tools (e.g., Airflow, dbt, etc.).