Senior Developer, Data Engineering 6 Months Contract

Description

ROLE: Senior Developer, Data Engineering – 6 Months Contract

REPORTS TO: Manager, Digital Analytics

LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario

SALARY: $60/h - $80/h

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 data modelling, and ensuring data quality. You will work closely with analysts, other stakeholders, and be expected to start making meaningful contributions very quickly.

Venterra is currently pursuing a data stack modernization effort to migrate from traditional ETL tools including Informatica and SSIS with SQL Server to a cloud-native ELT stack built on AWS, Python, Airflow, DBT, and Snowflake.

KEY JOB RESPONSIBILITIES

• Migrate data models from SQL Server to Snowflake with little oversight.
• 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.
• Design, develop, and maintain scalable data pipelines and ETL processes to support data integration and analytics.
• Stay up to date with the latest industry trends and technologies in data engineering and recommend improvements to existing systems.

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, Snowflake and Microsoft SQL Server with an emphasis on analytical and ETL use cases.
• Strong programming skills in Python.
• Experience with Apache Airflow and being able to design, develop, and maintain scalable data transformation workflows using data build tool (DBT).
• Knowledge of dimensional modelling techniques and data warehouse schema design.
• Strong experience building cloud-native solutions using AWS Lambda, ECS and EMR and deploying these services using infrastructure as code via Terraform.
• 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 .

Canada Awards:

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.