Data Engineer enhancing data analytics and reporting capabilities for Silk & Snow. Bridging raw data with actionable insights while contributing to data infrastructure efficiency.
Responsibilities
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.
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.
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.
Requirements
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.
Benefits
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
Senior Software Engineer on Data Platform developing and maintaining infrastructure for data ingestion and processing. Collaborating on projects that drive AI and analytics initiatives at Samsara.
Senior Data Engineer at Sumsub, developing scalable data integration solutions and maintaining data quality. Collaborating with teams to optimize data processes in a remote - first environment.
Operations Data Engineer at Dotmatics focused on managing cloud architecture and optimizing costs. Collaborating with engineering and leadership to enhance operational health effectively.
Associate Data Engineer joining Confluence to build data pipelines and collaborate in a modern data environment. Solve real data challenges and contribute to meaningful projects supporting business decisions.
Associate Data Engineer building reliable data pipelines and contributing to data solutions at Confluence. Collaborating closely with experienced engineers and analysts in a modern data environment.
Senior Data Engineer designing and delivering scalable data solutions at Confluence. Collaborating cross - functionally and mentoring engineers while managing key components of the data platform.
Senior Data Engineer at Confluence responsible for designing and delivering scalable data solutions. Collaborating with teams and mentoring engineers in modern data engineering practices.
Data Migration Engineer with Salesforce needed for hybrid contract in Mississauga, ON. Must have GCP Dataproc, Spark, Python, BigQuery, and Salesforce API experience.
Lead Data Engineer responsible for data architecture, driving data quality, and mentoring the engineering team. Join a high - growth crypto gaming platform with a focus on scalable data solutions.
Senior Data Engineer responsible for developing lakehouse architecture and robust data pipelines. Collaborating with teams to deliver business - ready data products on Microsoft Fabric.