Job Title: Data Engineer (Contract)
Location: Remote
Term: 3-Month Contract (High Chance of Renewal)
What is the Opportunity?
We are looking for an experienced Data Engineer to join a talented Data Infrastructure team on an initial 3-month contract with a strong likelihood of renewal. In this role, you will help design, build, and optimize data solutions that support key business stakeholders and critical workflows.
This position will play a key role in building a new Snowflake data mart and developing scalable data models and pipelines using dbt and SQL.
Main Duties & Responsibilities
- Design, build, and maintain scalable ETL pipelines.
- Develop high-quality data models and transformations using dbt.
- Write complex SQL for data modeling, optimization, and validation.
- Support the buildout of a new data mart within Snowflake, ensuring performance, reliability, and accuracy.
- Implement best practices in data architecture, including documentation, version control, and testing.
- Define data quality checks and validation processes to ensure consistency across data sources.
- Contribute to scalable, automated solutions that improve data reliability and reduce manual data preparation.
- Participate in requirement-gathering sessions, providing technical insights and proposing data-driven solutions.
- Support ongoing enhancements to data tooling, reporting structures, and infrastructure.
What We're Looking For
Must-Have Experience:
- Strong proficiency in SQL (there will be a SQL coding assessment).
- Hands-on experience building data transformations and pipelines in dbt.
- Deep experience with Snowflake, including schema design and performance optimization.
- Solid understanding of ETL processes, data modeling, and data pipeline best practices.
Nice to Have:
- Python for data pipeline automation, scripting, or tooling.