About this role

Role: Data Modeler / Data Modeling Lead
Location: 100% Remote

Role Overview

Looking for a Senior Data Modeler / Data Modeling Lead who can lead enterprise data modeling and also provide technical leadership across data engineering, Snowflake, dbt, and data warehouse architecture.

The person should be strong in data modeling, dimensional modeling, Data Vault 2.0, Snowflake, SQL, dbt, and ETL/ELT architecture.

Key Responsibilities

1. Data Modeling

Lead data modeling across Bronze, Silver, and Gold layers.
Create Conceptual, Logical, and Physical Data Models.
Design Dimensional Models / Kimball models.
Build and maintain Data Vault 2.0 models.
Define common/conformed dimensions and business entities used across different teams.
Establish data modeling standards, naming conventions, and best practices.
Review Source-to-Target Mapping (STTM) documents.
Ensure proper data lineage from source systems to target tables.
Standardize and harmonize data across different business domains.

2. Data Engineering & Architecture

Lead the design of scalable data ingestion and transformation frameworks.
Design ELT pipelines using Snowflake and dbt.
Design integration patterns for:
- Batch processing
- CDC (Change Data Capture)
- Near real-time data
Ensure data pipelines are scalable, reliable, and optimized for performance.
Establish frameworks for:
- Data quality
- Data reconciliation
- Data auditing
- Data monitoring
Guide CI/CD implementation for data and analytics workloads.
Work with engineering teams to ensure best practices are followed.

Data Modeler / Data Modeling Lead, 100% Remote

Key skills

About this role