Senior Developer, Data Engineering

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