Top Benefits
About the role
**This position is onsite our North York location Monday to Friday - 8:00 AM - 5:00 PM**
Why you will love Upper Canada Forest Products:
We are North Americas premier distributor of globally sourced specialty forest products. That means our products are not only sustainably sourced, but we are building a workforce for the future.
We stand proudly for our people and support their success through career advancement and development. From Innovation, diversity, equity & inclusion, we also strive to do what’s best for our people, customers, and communities.
The impact you will have:
We are seeking a skilled and motivated Data Engineer with 2–3 years of experience to join our team. The ideal candidate will have hands-on expertise in Azure Data Services and Microsoft Fabric, and a strong foundation in building scalable data pipelines and solutions. You will play a key role in designing, developing, and maintaining data infrastructure that supports analytics, reporting, and business intelligence initiatives.
What you will do:
- Design, build, and maintain robust and scalable data pipelines using Fabric, Azure Data Factory, Synapse, and other Azure data tools.
- Develop and optimize data models and storage solutions using Azure Data Lake, Azure SQL DB, Azure Dedicated SQL Pool, and Microsoft Fabric.
- Collaborate with data analysts, and business stakeholders to understand data requirements and deliver high-quality solutions.
- Implement data governance, security, RLS, and compliance best practices across Azure environments.
- Monitor and troubleshoot data workflows, ensuring reliability and performance.
- Support ETL/ELT processes and contribute to the automation of data integration tasks.
- Document data architecture, workflows, and processes for internal knowledge sharing.
What you bring:
- 2–3 years of experience in data engineering or a related field.
- Proficiency with Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, and Azure Dedicated SQL Pool.
- Experience working with Microsoft Fabric for distributed data processing and orchestration.
- Strong SQL skills, including designing and optimizing stored procedures, functions, and views for data ingestion, performance and scalability.
- Experience using Python or Scala for advanced data manipulation and automation.
- Understanding of data warehousing concepts, data modeling, and ETL/ELT processes.
- Familiarity with CI/CD pipelines and version control (e.g., Azure DevOps, Microsoft Fabric Deployment Pipelines).
- Experience with Power BI or other data visualization tools.
- Experience with DAX and PowerQuery for data modeling, transformations, and creating optimized datasets for reporting in Power BI.
- Knowledge of the Lumber industry would be a great asset.
- Knowledge of Data Governance frameworks and tools (e.g., Microsoft Purview).
- Microsoft Azure Data Engineer Certification is an asset.
Why people love working here:
- Comprehensive benefits.
- Work life balance and no weekend work.
- We offer meaningful work and opportunities for career growth.
- Our team members have 1 paid volunteer day per year to give back to a cause of their choice.
- We offer an opportunity to build and grow a career in the wood distribution industry.
- The company provides uniforms and safety shoe allowance.
- Retirement Savings plan to help save for your future!
- Driver Referral Incentive Pay.
- Employee Recognition Program.
- Tuition assistance.
- And so much more!
About Upper Canada Forest Products
Upper Canada Forest Products is Canada's premier distributor of specialty wood products and decorative surfaces serving discerning customers in the architectural woodworking industry. We offer a comprehensive selection of hardwoods and softwoods, and a full line of panel products including MDF, particleboard, melamine, veneer and hardwood plywood.
We are proud to be one of Canada's Best Managed Companies, and owe that to our extraordinary people. We focus on unique supplier relationships and customer-focused technologies, and our state of the art warehouses provide an unparalleled level of service in the industry. Our people are committed to adding value to your business, Upper Canada Forest Products is "Delivering the Difference" to its customers and suppliers, every day.
Top Benefits
About the role
**This position is onsite our North York location Monday to Friday - 8:00 AM - 5:00 PM**
Why you will love Upper Canada Forest Products:
We are North Americas premier distributor of globally sourced specialty forest products. That means our products are not only sustainably sourced, but we are building a workforce for the future.
We stand proudly for our people and support their success through career advancement and development. From Innovation, diversity, equity & inclusion, we also strive to do what’s best for our people, customers, and communities.
The impact you will have:
We are seeking a skilled and motivated Data Engineer with 2–3 years of experience to join our team. The ideal candidate will have hands-on expertise in Azure Data Services and Microsoft Fabric, and a strong foundation in building scalable data pipelines and solutions. You will play a key role in designing, developing, and maintaining data infrastructure that supports analytics, reporting, and business intelligence initiatives.
What you will do:
- Design, build, and maintain robust and scalable data pipelines using Fabric, Azure Data Factory, Synapse, and other Azure data tools.
- Develop and optimize data models and storage solutions using Azure Data Lake, Azure SQL DB, Azure Dedicated SQL Pool, and Microsoft Fabric.
- Collaborate with data analysts, and business stakeholders to understand data requirements and deliver high-quality solutions.
- Implement data governance, security, RLS, and compliance best practices across Azure environments.
- Monitor and troubleshoot data workflows, ensuring reliability and performance.
- Support ETL/ELT processes and contribute to the automation of data integration tasks.
- Document data architecture, workflows, and processes for internal knowledge sharing.
What you bring:
- 2–3 years of experience in data engineering or a related field.
- Proficiency with Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, and Azure Dedicated SQL Pool.
- Experience working with Microsoft Fabric for distributed data processing and orchestration.
- Strong SQL skills, including designing and optimizing stored procedures, functions, and views for data ingestion, performance and scalability.
- Experience using Python or Scala for advanced data manipulation and automation.
- Understanding of data warehousing concepts, data modeling, and ETL/ELT processes.
- Familiarity with CI/CD pipelines and version control (e.g., Azure DevOps, Microsoft Fabric Deployment Pipelines).
- Experience with Power BI or other data visualization tools.
- Experience with DAX and PowerQuery for data modeling, transformations, and creating optimized datasets for reporting in Power BI.
- Knowledge of the Lumber industry would be a great asset.
- Knowledge of Data Governance frameworks and tools (e.g., Microsoft Purview).
- Microsoft Azure Data Engineer Certification is an asset.
Why people love working here:
- Comprehensive benefits.
- Work life balance and no weekend work.
- We offer meaningful work and opportunities for career growth.
- Our team members have 1 paid volunteer day per year to give back to a cause of their choice.
- We offer an opportunity to build and grow a career in the wood distribution industry.
- The company provides uniforms and safety shoe allowance.
- Retirement Savings plan to help save for your future!
- Driver Referral Incentive Pay.
- Employee Recognition Program.
- Tuition assistance.
- And so much more!
About Upper Canada Forest Products
Upper Canada Forest Products is Canada's premier distributor of specialty wood products and decorative surfaces serving discerning customers in the architectural woodworking industry. We offer a comprehensive selection of hardwoods and softwoods, and a full line of panel products including MDF, particleboard, melamine, veneer and hardwood plywood.
We are proud to be one of Canada's Best Managed Companies, and owe that to our extraordinary people. We focus on unique supplier relationships and customer-focused technologies, and our state of the art warehouses provide an unparalleled level of service in the industry. Our people are committed to adding value to your business, Upper Canada Forest Products is "Delivering the Difference" to its customers and suppliers, every day.