Data Engineer

Sleep Country Canada; Toronto; On-site; CAD 85,000 - 110,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Employee discount

Growth opportunities

Job summary

Silk & Snow is seeking a versatile Data Engineer to bridge raw data and actionable insights. You will design dimensional models, implement robust ETL/ELT processes, and develop Power BI dashboards to monitor KPIs.

Ideal candidates have 2–4 years in data engineering, strong SQL and Python, and hands-on dbt experience. Hybrid work and competitive benefits are offered to support growth and work‑life balance.

Qualifications

• Bachelor’s degree in a quantitative field (CS/Math/Stats).
• 2–4 years in data engineering or analytics with strong SQL and Python.
• Experience designing dimensional models and data transformation pipelines.
• Hands-on with dbt, Power BI, and cloud data platforms (BigQuery/Azure).
• Proficient in data quality, documentation, and stakeholder collaboration.

Responsibilities

• Design and maintain dimensional models (star/snowflake) for scalable analytics.
• Develop ETL/ELT pipelines using SQL and Python with robust documentation.
• Build, optimize, and publish Power BI dashboards to visualize KPIs.
• Collaborate with stakeholders to translate business needs into data models.
• Ensure data quality and consistency across the pipeline from source to reporting.

Skills

SQL

Power BI

Python

dbt

Data modeling

ETL/ELT

Airflow

BigQuery / Synapse

Pandas / SQLAlchemy

Education

Bachelor's degree in CS / Math / Stats

Tools

Power BI

dbt

Python

SQL

Tableau / Looker

Airflow

Google BigQuery

Azure Synapse

Job description

We are seeking a versatile and highly motivated Data Engineer to join our data analytics and reporting team. This role is critical in bridging the gap between raw data and actionable business insights, while also contributing to the robustness and efficiency of our data infrastructure. The ideal candidate will possess strong SQL skills for ad‑hoc analysis and reporting, proficiency in Power BI for dashboard development, and hands‑on experience with Python for data extraction and loading processes within our data warehouse environment. The core focus of this role is designing and maintaining well‑structured data models and robust transformation logic that serve as the foundation for reliable, scalable analytics.

In this role you will:

Data Modelling and Transformation

• Design and implement dimensional and relational data models (star/snowflake schemas) that support scalable, performant analytics across business domains.
• Develop, document, and maintain transformation logic that converts raw source data into clean, conformed, and business‑ready datasets.
• Write and optimize complex SQL queries and dbt models for data manipulation, aggregation, and layered transformation within the data warehouse.
• Define and enforce data standards, naming conventions, and modeling best practices to ensure consistency across the warehouse.
• Collaborate with stakeholders to translate business logic into well‑structured data models that are intuitive and reusable.
• Evaluate and refine existing models over time as business needs evolve, ensuring models remain accurate, efficient, and well‑documented.

Data Engineering and Warehouse Development

• Design, develop, and maintain Python scripts for extracting and loading data from various source systems into our data warehouse.
• Ensure data quality, accuracy, and consistency throughout the pipeline, from ingestion through to reporting‑ready layers.
• Identify and resolve data pipeline issues, ensuring timely and reliable data availability.
• Contribute to the documentation of ETL processes, pipeline architecture, and data definitions.

Data Analytics and Reporting

• Develop, maintain, and optimize interactive dashboards and reports using Power BI to visualize KPIs and business trends, built on top of well‑modeled data layers.
• Perform ad‑hoc data analysis using SQL and collaborate with stakeholders across Marketing, Sales, Product, and Operations to translate business questions into clear, actionable insights.

The Qualifications and Experience we like to see:

• Bachelor's degree in Computer Science, Mathematics, Statistics, or a related quantitative field.
• 2–4 years of experience in a data‑focused role, with a strong emphasis on data engineering and/or analytics.
• Demonstrated experience designing dimensional models (star/snowflake schemas) and translating business requirements into logical and physical data models.
• Advanced SQL proficiency within a modeling and transformation context (e.g., layered CTEs, reusable views, incremental logic).
• Hands‑on experience building pipelines that clean, standardize, and reshape raw data into analytics‑ready datasets using SQL and/or Python.
• Practical experience with dbt for modular, tested, and version‑controlled transformation logic.
• Experience developing and publishing interactive dashboards in Power BI or comparable tools such as Tableau or Looker.
• Familiarity with workflow orchestration tools such as Apache Airflow.
• Experience with cloud‑based data platforms, particularly Google BigQuery or Azure Synapse Analytics.
• Proficiency with Power BI report development and DAX formula creation.
• Industry experience in e‑Commerce, particularly with Shopify.
• Solid experience with Python for data manipulation, scripting, and building ETL/ELT processes (e.g., Pandas, SQLAlchemy).
• Strong analytical, problem‑solving, and critical thinking abilities with keen attention to detail.
• Excellent verbal and written communication skills, with the ability to explain complex data concepts to non‑technical stakeholders.

Why our team members enjoy working at Silk & Snow:

• We prioritize diversity and inclusivity in our company culture
• Growth opportunities with an emphasis on hiring from within
• You will be exposed to a streamlined training process and receive guidance and support that will set you up for success during and after training
• You can access our learning platform with lots of free courses taught by experts to support your personal and professional development
• We offer a competitive benefits package, which includes but is not limited to medical, dental, and vision.
• Employee discount on all products and a free mattress and bedding set offered upon completion of the probationary period
• Make a meaningful impact on our customers' sleep habits, contributing to their overall well‑being
• We foster a healthy work‑life balance with our company's supportive environment
• This is not just a job but a CAREER with potential opportunities for growth and advancement

Additional Information:

This is a current open position. The salary range for this position is $85,000.00 - $110,000.00 annually. Actual salary for the role may vary depending on work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market.

Our recruitment process incorporates various screening technologies, which may include AI, to screen for employability or suitability. Human recruiters review all applications.

Inclusion and Belonging:

We are committed to building a company culture of inclusion and diversity where differences are embraced and valued, this allows us to better understand and meet the needs of our customers and the communities we serve. We want to ensure every job applicant is treated fairly and with respect regarding race, national or ethnic origin, religion, age, gender, sexual orientation, or disability. Upon request, accommodations are available during all stages of the recruitment process.

At Silk & Snow, we create products that turn your house into a home. We help bring affordable luxury to our customers every day by providing them with meticulously crafted and manufactured sleep products that elevate your personal sanctuaries and give you the rest you deserve. We make every decision by following three principles. We always use better materials, ensure that every product is thoughtfully manufactured, and above all, ensure transparency in everything we do. We’re proud of our products, and we want to give our customers the confidence to know that they are purchasing better products for their family, their home and the planet.