Data Engineer
Apply NowCompany: Pacific Smoke International
Location: Markham, ON L3P 8P3
Description:
Data Engineer
At Pacific Smoke International
(Hybrid 3 days in office)
Do you believe that a company's success depends on its people? If so, PSI is the place for you! PSI is nothing without the people who build, design, and support it.
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 Data Engineer to join our dynamic team located in Markham.
What's important to us:
We are seeking to attract individuals who share and demonstrate our core values: Judgement, Curiosity, Agility, Results, Accountability, Teamwork.
We are seeking a talented and experienced Data Engineer to join our dynamic team. The Data Engineer will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data-driven decision-making and business intelligence initiatives. The ideal candidate will have a strong background in data engineering, ETL processes, and database management, with a passion for optimizing data workflows and ensuring data quality and integrity.
The Data Engineer will:
1. Data Pipeline Development:
Design, develop, and implement scalable data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.
Optimize data pipeline performance for efficiency, reliability, and scalability.
2. Data Modeling and Architecture:
Design and implement data models, schemas, and structures to support business intelligence and analytics requirements.
Develop and maintain data architecture solutions, including databases, data warehouses, and data lakes.
3. ETL Development:
Develop Extract, Transform, Load (ETL) processes to extract data from various sources, transform it into usable formats, and load it into data warehouses or BI platforms.
Implement data cleansing, validation, and enrichment techniques to ensure data quality and integrity.
4. Data Integration and Management:
Integrate data from disparate sources, including databases, APIs, flat files, and streaming data sources, into centralized data repositories.
Implement data integration techniques and tools to ensure data consistency, quality, and integrity.
5. Data Quality Assurance:
Implement data quality checks, validation rules, and error handling mechanisms to ensure data accuracy, completeness, and consistency.
Develop and maintain data quality metrics and KPIs to monitor and improve data quality over time.
6. Data Analysis, Report and Dashboard Development:
Design and develop interactive dashboards, reports, and visualizations that provide insights into key business metrics and KPIs.
Customize reports and dashboards to meet the needs of different user groups and stakeholders.
Analyze complex datasets to identify trends, patterns, and correlations that drive business decisions and strategies.
7. Performance Optimization:
Identify and resolve performance bottlenecks and optimization opportunities in data pipelines, databases, and query processing.
Optimize data storage, indexing, and partitioning strategies for improved query performance and resource utilization.
8. Collaboration and Stakeholder Engagement:
Collaborate with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data requirements and deliver data solutions.
Engage with stakeholders to understand their needs, provide technical guidance, and ensure alignment with business goals.
To be successful you need:
Bachelor's degree in Computer Science, Information Systems, or related fields.
5 years of experience in data engineering, ETL development, or database management.
Proficiency in programming and scripting languages such as Python, SQL. DAX
Hand-on Experience with data warehousing concepts and technologies (e.g., SQL Server, Google BigQuery, Microsoft Azure, Snowflake, Redshift).
Familiarity with ETL tools and frameworks.
Proficiency in BI platforms and technologies (e.g.. PowerBI service, Looker)
Strong understanding of data modelling, schema design, database optimization techniques, and technologies. (e.g., DBT)
Excellent analytical and problem-solving skills with a focus on data quality and integrity.
Ability to work independently and collaboratively in a fast-paced, agile environment.
Strong communication and interpersonal skills with the ability to interact effectively with diverse teams and stakeholders.
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:
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
At Pacific Smoke International
(Hybrid 3 days in office)
Do you believe that a company's success depends on its people? If so, PSI is the place for you! PSI is nothing without the people who build, design, and support it.
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 Data Engineer to join our dynamic team located in Markham.
What's important to us:
We are seeking to attract individuals who share and demonstrate our core values: Judgement, Curiosity, Agility, Results, Accountability, Teamwork.
We are seeking a talented and experienced Data Engineer to join our dynamic team. The Data Engineer will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data-driven decision-making and business intelligence initiatives. The ideal candidate will have a strong background in data engineering, ETL processes, and database management, with a passion for optimizing data workflows and ensuring data quality and integrity.
The Data Engineer will:
1. Data Pipeline Development:
Design, develop, and implement scalable data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.
Optimize data pipeline performance for efficiency, reliability, and scalability.
2. Data Modeling and Architecture:
Design and implement data models, schemas, and structures to support business intelligence and analytics requirements.
Develop and maintain data architecture solutions, including databases, data warehouses, and data lakes.
3. ETL Development:
Develop Extract, Transform, Load (ETL) processes to extract data from various sources, transform it into usable formats, and load it into data warehouses or BI platforms.
Implement data cleansing, validation, and enrichment techniques to ensure data quality and integrity.
4. Data Integration and Management:
Integrate data from disparate sources, including databases, APIs, flat files, and streaming data sources, into centralized data repositories.
Implement data integration techniques and tools to ensure data consistency, quality, and integrity.
5. Data Quality Assurance:
Implement data quality checks, validation rules, and error handling mechanisms to ensure data accuracy, completeness, and consistency.
Develop and maintain data quality metrics and KPIs to monitor and improve data quality over time.
6. Data Analysis, Report and Dashboard Development:
Design and develop interactive dashboards, reports, and visualizations that provide insights into key business metrics and KPIs.
Customize reports and dashboards to meet the needs of different user groups and stakeholders.
Analyze complex datasets to identify trends, patterns, and correlations that drive business decisions and strategies.
7. Performance Optimization:
Identify and resolve performance bottlenecks and optimization opportunities in data pipelines, databases, and query processing.
Optimize data storage, indexing, and partitioning strategies for improved query performance and resource utilization.
8. Collaboration and Stakeholder Engagement:
Collaborate with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data requirements and deliver data solutions.
Engage with stakeholders to understand their needs, provide technical guidance, and ensure alignment with business goals.
To be successful you need:
Bachelor's degree in Computer Science, Information Systems, or related fields.
5 years of experience in data engineering, ETL development, or database management.
Proficiency in programming and scripting languages such as Python, SQL. DAX
Hand-on Experience with data warehousing concepts and technologies (e.g., SQL Server, Google BigQuery, Microsoft Azure, Snowflake, Redshift).
Familiarity with ETL tools and frameworks.
Proficiency in BI platforms and technologies (e.g.. PowerBI service, Looker)
Strong understanding of data modelling, schema design, database optimization techniques, and technologies. (e.g., DBT)
Excellent analytical and problem-solving skills with a focus on data quality and integrity.
Ability to work independently and collaboratively in a fast-paced, agile environment.
Strong communication and interpersonal skills with the ability to interact effectively with diverse teams and stakeholders.
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
- Ongoing learning and development opportunities to help build the career you want and hit the goals you set, while ensuring you're reaching your fullest potential
- Tuition Reimbursement
- Three weeks of Vacation
- Awards for top performers and employee tenure
- A unique opportunity to build, grow and leave your impact on a US$25-billion 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