Senior Data Engineer

Résumé du poste

The Senior Data Engineer will design, build, and scale modern data platforms and pipelines to support business intelligence, analytics, and AI initiatives. They will collaborate with cross-functional teams to transform data into a strategic asset while ensuring high standards for data quality, governance, and security.

Détails du poste

Do you believe that a company’s success depends on its people? If so, PSI is the place for you! PSI is nothing without people who build, design, and support it. We’re looking for a Senior Data Engineer to join our scaling organization. What’s important to us: We are seeking to attract individuals who share and demonstrate our core values: Judgement, Curiosity, Agility, Results, Ownership, Teamwork. At Pacific Smoke International, our 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, we've made significant progress since our founding in 2013. However, we have much more to accomplish for our customers, and we're looking for a culturally aligned Senior Data Engineer to join in our Information Technology Services team at our Markham headquarters. Take part in joining an exciting career in a booming industry! Overview: We are looking for a highly motivated and experienced Senior Data Engineer to join our growing Data & Technology team. This role will be responsible for designing, building, and scaling modern data platforms and pipelines that support business intelligence, analytics, AI initiatives, and operational decision-making across the organization. The ideal candidate combines strong technical expertise with business acumen and enjoys solving complex data challenges in a fast-paced environment. You will work closely with cross-functional teams including IT, Sales, Operations, Supply Chain, Finance, and Leadership to transform data into a strategic asset for the business. Key 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 Qualifications and Skills: Must-have: * 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 Have: * 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 What you can expect from Pacific Smoke International: At our company, we strive to provide our team members with the best possible support. Here is an overview of the current benefits and perks we offer: * A total compensation package that includes group benefits program starting from day 1 of joining and year-end performance bonus. (Please noted that the base salary is an estimate and actual pay will vary depending on the experience, qualifications and professional certifications) * Opportunity to help shape the future of data and AI within a rapidly growing business * Work on high-impact projects that directly influence strategic decision-making * Three weeks of Vacation * Hybrid work * Awards for top performers and employee tenure * A unique opportunity to build, grow and leave your impact on the industry * To work with a group of people who are humble, supportive, and care about our customers * Product at distributor pricing to all employees * Company events * EAP (Employee Assistance Program) Program If you are a results-driven, self-motivated individual who thrives in a collaborative and fast-paced environment, we invite you to join our team at PSI. You will have the opportunity to make a meaningful difference in the lives of people nationwide while working in an inclusive and supportive environment. Thank you to all the applicants who have shown interest in this position. We appreciate the time and effort you have taken to apply. While we carefully review every application we receive, we regret to inform you that only the candidates who are being considered for further evaluation will be contacted. Pacific Smoke international is an equal opportunity employer and encourages all qualified candidates to apply. In accordance with the Accessibility for Ontarians with Disabilities Act (AODA), we are committed to providing accommodations for people with disabilities to support their participation in all aspects of the recruitment and selection process.

Ce que vous ferez

The Senior Data Engineer will design, build, and scale modern data platforms and pipelines to support business intelligence, analytics, and AI initiatives. They will collaborate with cross-functional teams to transform data into a strategic asset while ensuring high standards for data quality, governance, and security.

Exigences

Candidates must have at least 5 years of experience in data engineering with strong proficiency in SQL and Python. The role requires hands-on experience with cloud data platforms, data modeling, and modern engineering practices like CI/CD and infrastructure-as-code.

Avantages

• Group benefits program • Year-end performance bonus • Three weeks of vacation • Hybrid work • Awards for top performers • Employee tenure awards • Product at distributor pricing • Company events • Employee Assistance Program

Compétences indiquées

• SQL · Souhaitée
• CI/CD · Souhaitée
• Résolution de problèmes · Souhaitée
• Communication · Souhaitée
• Git · Souhaitée
• Python · Souhaitée

Autres compétences pertinentes

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• SQL
• Python
• Data engineering
• ETL/ELT pipelines
• Data warehousing
• BigQuery
• Azure Fabric
• Cloud platforms
• Data modeling
• API integration
• CI/CD
• Git
• Infrastructure-as-code
• Data governance
• Problem-solving
• Communication
• Influencing Skills
• Pipelines
• Strategic Decision Making
• Frontline Decision-Making Autonomy
• Influencing Without Authority
• Supply Chain
• Observability
• DataOps
• Workflow Management
• Curiosity
• Git (Version Control System)
• Infrastructure as Code (IaC)
• Self-Motivation
• Application Programming Interface (API)
• Artificial Intelligence
• Analytics
• Microsoft Azure
• Batch Processing
• Business Intelligence
• Google BigQuery
• Customer Relationship Management
• Business Acumen
• Business Workflow Analysis
• Textiles
• Software As A Service (SaaS)
• Cloud Infrastructure
• Information Technology
• Data Engineering
• Data Governance
• Extract Transform Load (ETL)
• Data Modeling
• Data Quality
• Data Warehousing
• Database Tuning

Domaines d’emploi

• Data & Analytics
• Technology
• Software
• Engineering
• Data Engineer
• Software Developers
• Database Administrators