Senior Developer, Data Engineering

Venterra; Richmond Hill; On-site; CAD 120,000 - 130,000; Full time

Job summary

Venterra is seeking a Senior Developer, Data Engineering in a hybrid role based at our Richmond Hill office. You will build and optimize scalable data pipelines, govern data storage, and ensure data quality for analytics across the organization.

The ideal candidate has 7+ years in data engineering, deep SQL experience (Snowflake/MS SQL Server), and strong Python skills. Cloud-native AWS/ETL tooling, Airflow, and Terraform experience are highly valued.

Qualifications

• 7+ years of experience in data engineering or related field.
• Strong SQL expertise with analytical/ETL use cases in Snowflake or SQL Server.
• Experience building cloud-native solutions on AWS and infrastructure as code.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes.
• Optimize data storage solutions for efficiency and security.
• Implement data quality checks and monitoring for data reliability.
• Collaborate with data scientists, analysts and stakeholders to meet data needs.
• Develop and maintain documentation for data systems and processes.
• Mentor data engineering, BI and data science teams and stay current with trends.

Skills

SQL

Python

Airflow

Snowflake

ETL

Data modeling

Education

Bachelor’s or Master’s in CS/Engineering

Tools

Terraform

AWS (Lambda, ECS, EMR)

Apache Airflow

DBT

Snowflake

Microsoft SQL Server

Job description

ROLE: Senior Developer, Data Engineering

REPORTS TO: Manager, Digital Analytics

LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario

SALARY: $120k-$130k, up to 10% discretionary incentive target*

THE OPPORTUNITY

We are seeking a highly skilled and experienced Senior Developer to join our Data Engineering team. The ideal candidate will have a strong background in data engineering, with a focus on building and maintaining scalable data pipelines, optimizing data storage, and ensuring data quality. You will work closely with data scientists, analysts, and other stakeholders to support data-driven decision-making across the organization.

Venterra is currently pursuing a data stack modernization effort to migrate our SQL Server reporting database to a cloud-native ELT stack built on AWS, Python, Airflow, DBT and Snowflake.

KEY JOB RESPONSIBILITIES

• Design, develop, and maintain scalable data pipelines and ETL processes to support data integration and analytics.
• Optimize and manage data storage solutions, ensuring data is stored efficiently and securely.
• Implement data quality checks and monitoring to ensure the accuracy and reliability of data.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions that meet their needs.
• Develop and maintain documentation for data engineering processes and systems.
• Stay up to date with the latest industry trends and technologies in data engineering and recommend improvements to existing systems.
• Mentor and provide guidance to members of the data engineering, business intelligence and data science teams

CANDIDATE PROFILE

• Bachelor’s or master’s degree in computer science, Engineering, a related field or equivalent experience
• 7+ years of experience in data engineering or a related field.
• Strong expertise in SQL and experience with relational databases, preferably Snowflake and/or Microsoft SQL Server with an emphasis on analytical and ETL use cases.
• Strong experience building cloud-native solutions using AWS Lambda, ECS and EMR and deploying these services using infrastructure as code tools. Preference given to candidates with experience with Terraform
• Strong programming skills in Python or another programming language commonly used in data engineering.
• Experience with data pipeline and workflow management tools, preferably Apache Airflow or other dependency graph-based orchestration tools
• Familiarity with cloud-based data storage and processing solutions, preferably AWS
• Knowledge of dimensional modelling techniques and data warehouse schema design
• Experience working with Git, CI/CD pipelines for database schema evolution and environment management
• Experience with big data technologies (e.g., Hadoop, Spark) is a plus.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Experience with data modeling and schema design.
• Knowledge of data governance and data security best practices.
• Experience with containerization and orchestration tools (e.g., Docker, Kubernetes).
• Familiarity with machine learning and data science concepts.

COMPANY OVERVIEW

Venterra Realty is a growing developer, owner, and operator of multifamily apartments with 90 mixed-use and multifamily communities across 22 major US cities. Over 50,000 people and more than 10,000 pets call Venterra "home"! The Venterra Team is focused on achieving excellence in serving its three major stakeholders: residents, employees, and investors. Venterra has enjoyed tremendous growth and financial success over its 24-year history. This success has been achieved through the exceptional commitment and dedication of Venterra's approximately 950 team members. Find out more about Venterra Realty and its award-winning company culture at Venterra.com.

We’re thrilled to be recognized as a leading workplace with numerous prestigious awards year after year!

Canada Awards:

• 2025 Best Workplaces forProfessional Development
• 2025 Best Workplaces for Inclusion
• 2025 Best Workplaces for Mental Wellness 2025
• 2025 Best Workplaces in Canada
• 2025 Best Workplaces with Most Trusted Executive Team
• 2025 Best Workplaces forYoung Talent
• 2025 Best Workplaces in Real Estate & Property Development 2025

Explore our communities at VenterraLiving.com, and visit Venterra.com to learn more about how we’re out-caring the competition by staying true to our value proposition: “We care more about renter experiences, which drives superior results.”

Venterra Realty is an equal opportunity employer. Accessibility accommodations are available on request for candidates taking part in all stages of the selection process. We are actively recruiting for an existing position; Artificial Intelligence (AI) is used during our recruitment process for this role.

* The base salary range is intended to reflect the role's base salary rate in locations throughout Canada. Salary ranges are determined through interviews and a review of education, experience, knowledge, skills, abilities of the applicant, equity with other team members, alignment with market data, and geographic location. The base salary range does not include any bonuses or benefits.

Work Authorization Requirement: Applicants must be legally authorized to work in Canada at the time of application and throughout employment. The company does not provide visa sponsorship for this role.