Data Modeler​/Data Modeling Lead, Remote

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.