Senior Data Engineer
About The Position
PSI is seeking a Senior Data Engineer to join its scaling organization. The company's mission is to help people quit smoking by providing safer alternatives to traditional cigarettes. As the leading distributor of electronic vaporizers and award-winning vaping products in Canada, PSI has made significant progress since its founding in 2013. This role is part of the Information Technology Services team at their Markham headquarters. The Senior Data Engineer will be responsible for designing, building, and scaling modern data platforms and pipelines to support business intelligence, analytics, AI initiatives, and operational decision-making. The ideal candidate will have strong technical expertise, business acumen, and enjoy solving complex data challenges in a fast-paced environment. This role involves collaboration with cross-functional teams including IT, Sales, Operations, Supply Chain, Finance, and Leadership to transform data into a strategic asset for the business.
Requirements
- 5+ years of experience in data engineering or related roles
- Strong proficiency in SQL and Python
- Experience building scalable data pipelines using modern orchestration tools (e.g., dbt)
- Hands-on experience with cloud data platforms such as BigQuery and Azure Fabric
- Experience with cloud platforms including Azure or GCP
- Strong understanding of data modeling, warehousing, and dimensional design
- Experience integrating APIs, streaming data, and third-party SaaS platforms
- Knowledge of CI/CD, Git, infrastructure-as-code, and modern engineering practices
- Strong analytical, problem-solving, and communication skills
- Ability to work independently and manage multiple priorities in a fast-paced environment
Nice To Haves
- Experience supporting AI/ML workloads and feature engineering pipelines
- Experience with Power BI, or modern BI platforms
- Knowledge of retail, distribution, supply chain, or consumer goods industries
- Familiarity with real-time analytics and event-driven architectures
- Experience with MDM, data governance, and data catalog solutions
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines and data workflows
- Build and optimize enterprise data warehouse and lakehouse architectures
- Integrate data from ERP, CRM, eCommerce, WMS, POS, and third-party systems
- Ensure high standards for data quality, governance, reliability, and security
- Develop real-time and batch processing pipelines for operational and analytical use cases
- Support business intelligence and analytics initiatives by enabling clean, trusted, and accessible datasets
- Collaborate with analysts, data scientists, and business stakeholders to understand data requirements
- Optimize database performance, query efficiency, and cloud infrastructure costs
- Implement monitoring, alerting, and observability for data platforms
- Drive best practices in data engineering, architecture, documentation, and DevOps/DataOps
- Mentor junior team members and contribute to the growth of the data engineering function
- Support AI and machine learning initiatives by building scalable data foundations
Benefits
- Group benefits program starting from day 1 of joining
- Year-end performance bonus
- Three weeks of Vacation
- Awards for top performers and employee tenure
- Product at distributor pricing to all employees
- Company events
- EAP (Employee Assistance Program) Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
