SR Data Engineer

RPM Freight Systems; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

An innovative firm is seeking a Sr Data Engineer to join their dynamic team in Toronto. In this role, you will design and develop scalable data pipelines while collaborating with various stakeholders to enhance data quality and accessibility. Your expertise in SQL and Python, along with experience in analytics data warehouses, will be crucial as you implement solutions that drive analytical insights across the organization. This is an exciting opportunity to work in a high-growth environment where your contributions will significantly impact the company's data infrastructure and future growth.

Benefits

Competitive compensation package

Comprehensive health benefits

15 days of vacation + Paid wellness days

Ongoing learning and development opportunities

Team events and a collaborative tight-knit team

Qualifications

• 3+ years of experience as an Analytics Engineer or Data Engineer.
• Ability to learn new technologies and strong problem-solving skills.
• Proficient in SQL and Python.

Responsibilities

• Create and maintain scalable and reliable data pipelines.
• Develop and manage ETL processes using dbt.
• Collaborate with stakeholders to design reporting solutions.

Skills

SQL

Python

Data Quality Checks

Problem-Solving Skills

Communication Skills

Education

Bachelor's degree in Mathematics

Bachelor's degree in Statistics

Bachelor's degree in Computer Science

Bachelor's degree in Engineering

Tools

dbt

AWS Glue

Fivetran

Segment

Redshift

Snowflake

BigQuery

Sigma

Heap

Job description

About Us:

We exist to modernize the way that vendors and property managers work together. We do this by building a complete vendor lifecycle management solution, specific to the world of commercial real estate. Today, over 10,000 buildings & 65,000 vendors rely on VendorPM for their credentialing, tendering and contract management. We improve efficiency & reduce costs for property managers while driving new business to vendors across the continent.

We’re one of the fastest-growing Toronto startups, a certified “great place to work,” and in 2023 and 2024 and recognized as one of the Best Workplaces in Canada. VendorPM is backed by world-leading SaaS & PropTech funds, including; Bessemer Venture Partners, the former CEO of Twitter, Real Estate leaders, Prudence VC & Navitas Capital.

Our team is scrappy, resourceful, and laser-focused on making a big impact. If you’re the kind of person who thrives on finding creative ways to get things done and loves turning ideas into action, we want you on our team!

The Role

As a Sr Data Engineer, you will be an integral part of our data team, contributing to the design and development of scalable data pipelines and managing our business intelligence tools. Your role will involve collaborating with various stakeholders to understand requirements, implementing solutions to improve data quality and accessibility, and driving analytical insights to support decision-making across the organization. You'll have the opportunity to work on a variety of projects, from optimizing pipelines to enhancing data security, and play a key role in preparing our data infrastructure for future growth.

As a Member Of Our Team You Will

• Create and maintain scalable and reliable data pipelines to process structured and unstructured data from internal and third-party systems.
• Develop and manage ETL processes using dbt, ensuring data is clean, organized, and optimized
• Develop accurate, well-documented, and flexible data models to serve as a single source of truth for the organization.
• Collaborate with internal stakeholders to design and develop internal and external reporting solutions to solve business problems and provide valuable insights primarily with Sigma
• Implement and monitor data quality checks to ensure the accuracy, completeness, and consistency of data across all pipelines
• Champion data privacy, quality, and security within the organization.

You’re the Missing Piece of the Puzzle

• 3+ years of experience as an Analytics Engineer or Data Engineer.
• Bachelor's degree with a major in Mathematics, Statistics, Computer Science, Engineering, or equivalent.
• Proficient in SQL and Python.
• Experience with analytics data warehouses such as Redshift, Snowflake, or BigQuery.
• Proficiency in data pipeline and workflow management tools such as dbt, AWS Glue, Fivetran and Segment.
• Experience with business intelligence tools and familiarity with Sigma and Heap is a plus.
• Ability to learn new technologies and strong problem-solving skills.
• Excellent communication skills, both verbal and written.

What’s In It For You

• Opportunity to work in a high-growth, dynamic environment.
• Competitive compensation package.
• Comprehensive health benefits.
• Hybrid with weekly team collaboration days in office.
• 15 days of vacation + Paid wellness days.
• Team events and a collaborative tight-knit team.
• Ongoing learning and development opportunities.
• Meet Your Fellow Problem-Solvers

We believe in collaborative problem-solving. Meet some of your fellow problem-solvers:

Dylan Sher, VP of Operations

Interview Process

We want to ensure transparency and clarity throughout the interview process. The process will consist of:

1. Google Meets call with SR Data Engineer
2. Technical Assignment/Code Round
3. Interview with Team Leads