In short
Contract Data Engineer role in Montreal on a hybrid schedule (3 onsite days/week), building scalable dimensional data models and Matillion ETL/ELT pipelines in Snowflake. Day-to-day work involves advanced SQL transformations, AWS-based ingestion/processing (S3, SQS, SNS, Lambda), SAP data modeling, and Tableau/Power BI reporting support.
About the role
Snowflake and advanced SQL define this Data Engineer contract in Montreal, using a hybrid schedule of three onsite and two remote days weekly.
This enterprise-level Data Engineer assignment requires at least three years of professional Data Engineering, Business Intelligence, or Analytics Engineering experience. You will build scalable models and pipelines with Snowflake, Matillion, and AWS cloud services. The work also includes SAP data modeling, Tableau and Power BI reporting, and data integration support.
Responsabilités:
- Design dimensional star and snowflake data models
- Build, schedule, and optimize Matillion ETL and ELT pipelines
- Develop advanced SQL transformations in Snowflake
- Use AWS services for ingestion and processing workflows
- Validate data pipelines and reporting outputs
Exigences:
- Minimum three years of relevant professional experience
- Expert SQL querying and optimization capabilities
- Hands-on Snowflake data warehouse experience
- Practical Matillion pipeline development experience
- Experience with AWS storage, compute, SQS, SNS, and Lambda
Apply advanced SQL, Snowflake modeling, Matillion engineering, and AWS expertise to enterprise data solutions in Montreal.
Requirements
- Minimum three years of professional experience in Data Engineering, Business Intelligence, or Analytics Engineering
- Expert SQL querying and optimization capabilities
- Hands-on Snowflake data warehouse experience
- Practical Matillion pipeline development experience
- Experience with AWS storage, compute, SQS, SNS, and Lambda