Manager Jobs in Aurora, ON

Description

ROLE: Manager, Data Modelling

REPORTS TO: Director, Data Engineering

LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario

SALARY: $135,000 - $150,000, up to 15% discretionary incentive target*

THE OPPORTUNITY

Venterra Realty is, at its heart, a technology and data-driven company. Our strategy is to centralize, automate and liberate. In today’s world, that means adopting AI to enable our corporate and on-site teams with agentic workflows, deep analytics and machine learning to support our most important decisions. Good data is the foundation of AI, so Venterra’s Data Engineering team is building a modern data stack with a Medallion architecture based on Snowflake, Airflow and AWS to power our Analytics and AI teams. We’re integrating our proprietary in-house applications with commercial enterprise applications and third-party data sources to give us an edge in the multi-family real estate business.

We are seeking a Manager, Data Modelling to lead the team responsible for transforming enterprise data into trusted, reusable, business-oriented Data Products. Reporting to the Director, Data Engineering, this player-coach role combines hands-on dimensional modelling with people leadership, technical governance, delivery oversight, and operational support. The Manager will guide analytical data models across the Snowflake-based Enterprise Data Warehouse, ensuring that data assets are accurate, understandable, performant, secure, and aligned with business objectives. The role collaborates closely with Data Engineering, Analytics, Data Science, Cyber Security, Software Development, System Owners, Data Stewards, and business stakeholders.

KEY JOB RESPONSIBILITIES

• Lead, mentor, and develop the Data Modelling team responsible for the Snowflake Silver and Gold layers, fostering quality, documentation, collaboration, and continuous improvement.
• Define and enforce analytical modelling standards, patterns, coding practices, and technical direction across the Enterprise Data Warehouse.
• Guide the design and review of conceptual, logical, and physical models, including conformed dimensions, reusable entities, enterprise metrics, and Kimball-style dimensional structures.
• Own the design, quality, documentation, lineage, performance, and operational support of Data Products and semantic assets.
• Establish data quality controls and partner with Cyber Security, Data Stewards, and System Owners on access controls, sensitivity classifications, masking, and governance requirements.
• Plan and coordinate modelling initiatives, sprint priorities, team capacity, dependencies, risks, testing, and support readiness.
• Partner with Data Consumers and business stakeholders to define requirements, maintain consistent terminology, communicate changes, and measure adoption and stakeholder satisfaction.

CANDIDATE PROFILE

• 8+ years of experience in data warehousing, analytics engineering, business intelligence, data architecture, or a related discipline, including 2+ years leading or mentoring technical teams.
• Deep expertise in dimensional modelling and Kimball-style design, including facts, dimensions, grain, hierarchies, slowly changing dimensions, and conformed structures.
• Hands-on experience with Snowflake, dbt, SQL, and enterprise-scale analytical data platforms.
• Demonstrated ability to balance people leadership, planning, hands-on delivery, technical quality, stakeholder management, and operational support in a player-coach role.
• Experience leveraging AI tools to accelerate software delivery and coaching up team members in the effective use of these tools
• Experience defining and enforcing technical standards, data quality practices, governance controls, and secure access patterns.
• Experience with semantic models, business glossaries, metric governance, metadata management, data lineage, and Power BI or a comparable reporting platform would be an assset.
• Experience with medallion architectures, analytical platform modernization, Snowflake AI capabilities, and team capability development would be an asset.

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 at .

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

Canada Awards:

Explore our communities at , and visit 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.

#LI-Hybrid