Lead to Cash (L2C) Data Modeler

About the role

INSPYR Global Solutions is hiring a Data Modeler for a 6-month remote contract focused on Lead to Cash (L2C) data, supporting customer, subscription, billing and revenue reporting. The position is open to candidates who are citizens of the country of employment or authorized to work there.

Key responsibilities

• Design, develop and maintain data models in an enterprise cloud data warehouse covering customer, subscription, billing and revenue reporting.
• Build and optimize Bronze, Silver and Gold data models using medallion architecture to turn raw data into clean, standardized datasets.
• Integrate and model data from Salesforce CPQ, Salesforce Revenue Cloud and NetSuite SuiteBilling to create a unified view of customers and revenue.
• Develop customer master data models, including customer matching, deduplication, entity resolution and cross-system ID mapping.
• Build dimensional data models: fact and dimension tables, star schemas and slowly changing dimensions.
• Create reporting-ready models for SaaS metrics such as ARR, NRR, churn, subscriptions and customer counts.
• Develop automated data quality tests, validate accuracy and ensure consistency across sources.
• Work with Data Engineering, Finance, Sales and Revenue Operations teams to turn business requirements into scalable models.
• Maintain data dictionaries, data lineage and documentation of metrics and modeling standards.

Required profile

• 5+ years of hands-on experience in data modeling or data engineering, including 2+ years with cloud data warehouses or lakehouses.
• Strong production experience with Snowflake or Databricks.
• Ability to design and build production-ready data models independently while collaborating with technical and business stakeholders.

Required skills

• Expert SQL, including complex queries, transformations and performance optimization.
• Dimensional data modeling (star schemas, SCD, conformed dimensions).
• Medallion architecture (Bronze, Silver, Gold) and master data management, entity resolution and deduplication.
• Experience modeling SaaS subscription and recurring revenue data.
• Data transformation and orchestration tools such as dbt, Delta Live Tables or Airflow.
• Git-based version control and automated data quality testing.
• Nice to have: Salesforce CPQ, Revenue Cloud and NetSuite SuiteBilling, MuleSoft, Fivetran, Power BI or Tableau semantic layers, and Snowflake or Databricks certifications.

What we offer

• Flexible remote and hybrid work opportunities.
• Continuous learning and professional development programs.
• A culture that prioritizes employee wellbeing.