Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 19 days ago

Senior Data Modeler - 6 Month Contract

venterra40 open roles

Pay
$60 an hour
Where
Richmond Hill, Ontario, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior Data Modeler - 6 Month Contractventerra · Richmond Hill, Ontario, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on venterra's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.7%1 day
  2. 3.5%3 days
  3. 7.8%7 days
  4. 14.6%14 days
  5. 34.1%30 days
This job: posted 19 days ago

The posting

ROLE: 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.

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:

  • 2025 Best Workplaces™ for Professional 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™ for Young 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.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against venterra's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on venterra's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    venterra's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.