Senior Data Modeler

Job Title: Senior Data Modeler

Experience Required: 6+ Years

Location: Remote

Employment Type: Full-time / Contract (Remote)

Domain: Data Engineering / Analytics / Data Warehousing

---

Job Summary:

We are seeking an experienced and detail-oriented Data Modeler with a strong background in conceptual, logical, and physical data modeling. The ideal candidate will have in-depth knowledge of Snowflake architecture, data modeling best practices (Star/Snowflake schema), and advanced SQL scripting. You will be responsible for designing robust, scalable data models and working closely with data engineers, analysts, and business stakeholders.

---

Key Responsibilities:

1. Data Modeling:

Design Conceptual, Logical, and Physical Data Models.

Create and maintain Star and Snowflake Schemas for analytical reporting.

Perform Normalization and Denormalization based on performance and reporting requirements.

Work closely with business stakeholders to translate requirements into optimized data structures.

Maintain data model documentation and data dictionary.

2. Snowflake Expertise:

Design and implement Snowflake schemas with optimal partitioning and clustering strategies.

Perform performance tuning for complex queries and storage optimization.

Implement Time Travel, Streams, and Tasks for data recovery and pipeline automation.

Manage and secure data using Secure Views and Materialized Views.

Optimize usage of Virtual Warehouses and storage costs.

3. SQL & Scripting:

Write and maintain Advanced SQL queries including:

Common Table Expressions (CTEs)

Window Functions

Recursive queries

Build automation scripts for data loading, transformation, and validation.

Troubleshoot and optimize SQL queries for performance and accuracy.

Support data migration and integration projects.

---

Required Skills & Qualifications:

6+ years of experience in Data Modeling and Data Warehouse design.

Proven experience with Snowflake platform (min. 2 years).

Strong hands-on experience in Dimensional Modeling (Star/Snowflake schemas).

Expert in SQL and scripting for automation and performance optimization.

Familiarity with tools like Erwin, PowerDesigner, or similar data modeling tools.

Experience working in Agile/Scrum environments.

Strong analytical and problem-solving skills.

Excellent communication and stakeholder engagement skills.

---

Preferred Skills (Nice to Have):

Experience with ETL/ELT tools like dbt, Informatica, Talend, etc.

Exposure to Cloud Platforms like AWS, Azure, or GCP.

Familiarity with Data Governance and Data Quality frameworks.