Job Title : Data Modeller

Location : Remote

Experience : 6+ years

Mode : 6 month contract + ext.

Key Responsibilities :

- Design and maintain Conceptual, Logical, and Physical Data Models aligned with business requirements and technical specifications.

- Build efficient Star and Snowflake schemas for analytical and reporting use cases.

- Apply Normalization and Denormalization techniques to optimize data structures for various workloads.

Design and manage Snowflake schemas and objects, including :

- Secure and Materialized Views

- Streams and Tasks

- Time Travel and Cloning

- Performance tuning strategies

- Write and optimize complex SQL queries using Window Functions, Common Table Expressions (CTEs), and other advanced features.

- Automate and optimize data transformation pipelines and data model deployments using scripting or

orchestration tools.

- Collaborate with data engineers, BI developers, and business stakeholders to understand data needs and translate them into scalable models.

Required Skills and Qualifications :

- 6+ years of experience in data modeling across large data environments.

- Proven expertise in conceptual, logical, and physical modeling techniques.

- Strong knowledge of Snowflake architecture and features.

- Deep understanding of SQL and query performance optimization.

- Experience with automation and scripting for data workflows.

- Strong analytical and communication skills.

- Familiarity with data governance, security, and compliance best practices is a plus.

Preferred Qualifications :

- Experience with data modeling tools (e.g., ER/Studio, Erwin, dbt, SQL DBM).

- Exposure to cloud data platforms like AWS, Azure, or GCP.

- Knowledge of CI/CD for data pipeline deployments.