Schedule a call →

<p>Interview fractional leaders this week for <strong>free</strong>!</p>

Residential Real Estate

Venterra Realty Logo

Founded in 2001, at Venterra, we develop, own, and manage approximately 90 apartment communities in across 24 major US cities that provide housing to over 50,000 people and 16,000 pets. We are committed to improving the lives of our residents by delivering an industry-leading customer experience. Learn more at Venterra.com! In 2025 alone, Great Place to Work’s annual employee survey led to various workplace recognitions including being named one of the 2025 FORTUNE© Best Workplaces in Texas, 2025 Best Workplaces in Real Estate list, 2025 Best Medium Workplaces and more. If you are motivated to work in a challenging environment, where your results will be recognized and rewarded, you should consider a career with Venterra. We are looking for the best in the industry, those who genuinely wish to excel in their career. Come join a team where you have unlimited growth potential and career advancement. We offer great compensation, an excellent benefits package, and training to reach your full potential!

Venterra Realty

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.

Venterra Realty is recognized for its award-winning company culture, having received multiple 2025 Best Workplaces™ awards in Canada, including recognition for Professional Development, Inclusion, Mental Wellness, overall Best Workplaces in Canada, Most Trusted Executive Team, Young Talent, and Real Estate & Property Development.

The company's value proposition is: "We care more about renter experiences, which drives superior results."

Senior Data Modeler – 6 Months Contract
---------------------------------------

**REPORTS TO:** Manager, Digital Analytics

**LOCATION:** Hybrid / Corporate Office in Richmond Hill, Ontario

**SALARY:** $60/h - $80/h

### About the Role

We are seeking a senior data modelling specialist to design and evolve the enterprise analytical data model that supports reporting, self-service analytics, planning, and data science. You will translate complex operational data into durable, business-centered structures that make measures, dimensions, and relationships clear and reusable across analytical use cases.

This role sits within Data Engineering and works closely with business stakeholders, analysts, BI developers, data engineers, and data governance partners. The primary focus is dimensional modelling and analytical data architecture, not pipeline orchestration or cloud infrastructure engineering.

### Key Responsibilities

*   Design conceptual, logical, and physical analytical data models across major business subject areas.
*   Define the grain of fact tables; design measures, dimensions, hierarchies, keys, and relationships; and select appropriate patterns for historical change.
*   Build conformed dimensions and reusable business entities that support consistent analysis across source systems and functional domains.
*   Abstract transactional and operational source structures into intuitive analytical models rather than reproducing source-system schemas.
*   Develop dimensional models using Kimball-style techniques, including star schemas, role-playing dimensions, bridge tables, factless fact tables, and slowly changing dimensions.
*   Partner with business stakeholders and analysts to understand analytical questions, reporting workflows, definitions, and required levels of detail.
*   Define business meaning, calculation intent, lineage, naming standards, and model documentation so that analytical assets are understandable and governed.
*   Implement models using DBT and validate that delivered structures preserve the intended grain and business logic.
*   Review existing warehouse structures, identify duplication or tightly coupled designs, and guide their evolution towards reusable and supportable analytical models.
*   Provide modelling leadership through design reviews, standards, mentoring, and constructive challenge.

### What Success Looks Like

*   Analysts can answer new questions by combining well-defined facts and conformed dimensions without repeatedly rebuilding business logic.
*   Different reports and subject areas use consistent definitions for shared business concepts.
*   Models are stable enough to absorb source-system change while remaining clear to analytical consumers.
*   Fact table grain, history, relationships, and calculation rules are explicit, tested, and documented.
*   Data engineering pipelines implement governed model designs instead of exposing operational structures directly to reporting tools.

### Qualifications

*   7+ years of experience in data warehousing, analytics engineering, business intelligence, data architecture, or a related discipline, with substantial hands-on responsibility for analytical data modelling.
*   Demonstrated experience designing dimensional data warehouses using Kimball methodologies.
*   Deep understanding of dimensional modelling concepts, including fact table grain, conformed dimensions, slowly changing dimensions, surrogate keys, hierarchies, additive and non-additive measures, and many-to-many relationships.
*   Experience creating conceptual, logical, and physical models that abstract data from multiple transactional source systems.
*   Strong SQL skills and the ability to profile source data, validate assumptions, and test whether a model represents business processes correctly.
*   Working knowledge of dbt or similar SQL-based transformation frameworks.
*   Experience modelling data for reporting, BI, semantic models, and self-service analytics.
*   Ability to facilitate requirements and model-design discussions with both business and technical participants.
*   Ability to explain modelling choices, trade-offs, and constraints clearly through diagrams, definitions, examples, and design documentation.
*   Experience reviewing implemented models for structural quality, usability, consistency, and alignment with modelling standards.
*   Experience modelling data across multiple enterprise applications or integrating similar business concepts from different source systems.
*   Familiarity with medallion-style data platform architecture and the role of curated, business-oriented models within that architecture.
*   Exposure to Git and automated deployment practices for database and transformation changes.

### Preferred Qualifications

*   Experience implementing analytical models in Snowflake or a comparable cloud data platform.
*   Experience supporting Power BI or another enterprise BI platform, including collaboration on semantic layer design.
*   Experience with data governance, metadata management, lineage, data quality rules, and business glossaries.

### Education

*   Bachelor's or master's degree in computer science, information systems, engineering, mathematics, business analytics, or a related field, or equivalent practical experience.

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

Head of Talent Acquisition

Kevin Smith

Senior Talent Acquisition Specialist | Sourcing Specialist | Multi Family Real Estate | Your Recruiting Guru | Always on the hunt for the best candidates | Unicorn Hunter | #ExerciseNut #CollegeFootballFanatic

Elizabeth Lopez

Senior Talent Acquisition Specialist

HR Executive | Interim Head of Total Rewards | HR Strategy • Compensation Design • Change Leadership • HR Tech Transformation

Natassa Zervopoulos

Senior Director Human Resources

Operations Maintenance Manager

Venterra Realty Careers - Senior Data Modeler - 6 Month Contract

Data Warehousing

Project Manager

dbt helps data teams work like software engineers—to ship trusted data, faster.

The role is a 6-month contract for a Senior Data Modeler at Venterra Realty, located in Richmond Hill, Ontario, Canada. It involves designing and evolving enterprise analytical data models to support reporting and analytics. The position is hybrid, offering $60-$80 per hour.

Venterra Realty

Jobs

Interim Senior Data Modeler

About this page