Our client, a leading financial services firm based in Montreal, is seeking a highly skilled ETL Consultant with 9+ years of experience in:

• Snowflake (data warehousing and performance tuning)
• ETL development (designing and maintaining robust data pipelines)
• Data modeling (dimensional and relational)
• Advanced SQL (query optimization and complex data transformations)

Required Skill set

• 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.).

Note: In-Person Interview is mandatory for this role.