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
- 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.
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.
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Senior