Data Engineer

commonsku

commonsku leads the promotional products industry by providing a comprehensive platform for distributors. The company prioritizes community, creativity, and innovation, offering services that elevate businesses. Operating remotely with a headquarters in Toronto, commonsku fosters a collaborative and supportive culture.

In this role you can expect to have the responsibilities:

• Develop and automate ETL pipelines for data extraction and integration into a centralized warehouse.
• Design scalable data warehouse architecture to accommodate growing data needs.
• Create and maintain centralized datamarts with optimal performance.
• Integrate data sources for seamless analysis and reporting.
• Use dbt for data modeling and testing to ensure data integrity.
• Work with cross-functional teams to meet their data requirements.
• Implement data governance practices for security and compliance.
• Document processes and architectural decisions for transparency.

This role comes with the following benefits:

• Benefits coverage for employees.
• Group RRSP plan with employer contributions.
• Annual office closure for winter holidays.
• Parental leave top-up.
• Flexible work environment.
• Exciting company merchandise.

This role requires you to have:

• 5+ years of data engineering experience in startups.
• Proficiency in ETL processes and data integration.
• Experience with dbt or similar tools for data modeling.
• Expertise in SQL and Python.
• Familiarity with cloud-based data platforms.
• Experience integrating data from platforms like Stripe and HubSpot.
• SaaS or high-volume transactional data environment experience.

You would benefit from having:

• Knowledge of cloud infrastructure and orchestration tools like Airflow.
• Experience in data testing and version control.
• Strong problem-solving and communication abilities.
• Capability to work independently and manage priorities in a fast-paced setting.

commonsku is an equal opportunity employer committed to fostering diversity and inclusion in the workplace.