Senior Data Modeler
Senior Data Modeler
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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.
Required Experience:
Senior IC
Employment Type
Unclear
