← All Skills
SkillTechnical

Data Modelling

The ability to design logical representations of business data — defining entities, relationships, grain, and hierarchies — that accurately represent revenue processes and support reliable analytics.

Day-to-day use

Designing the grain and schema for an ARR movements table, mapping Salesforce opportunity stages to booking events, structuring a subscription event log for MRR calculation, and documenting entity-relationship diagrams for new data domains.

Typical tasks

  • ·Building a subscription events model that tracks ARR movements (new
  • ·expansion
  • ·contraction
  • ·churn)
  • ·designing a lead funnel model with consistent stage definitions
  • ·creating a bookings model that reconciles CRM and billing data

Business outcome

Well-designed data models ensure metrics are calculated consistently, data is non-duplicated, and analytical queries run accurately — giving every team a shared, trustworthy view of revenue.