6 years

0 Lacs

Posted:23 hours ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Contractual

Job Description

Job Title : Data Modeler

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

Pune, Maharashtra, India