Data Modeler

Role: SQL + Data Modelling

Location: Gurugram

Work Mode: 5 Days from office.

Experience: 8-12 years

Functions:Consulting, Finance, Information Technology, Data Engineering & Analytics

Industries:Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, Business Travel Healthcare

Job Description

We are seeking talented and experienced Data Modelling to join our team. The ideal candidate will have a strong background in Data Warehousing. This role requires a problem-solver who can collaborate across teams to deliver insights that drive business decisions.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for the data warehouse.
• Build dimensional models (e.g., Star Schema / Snowflake Schema)
• Define data granularity, relationships, hierarchies, and business rules for accurate reporting.
• Work with business stakeholders, BI teams, and data engineers to understand reporting and analytical needs.
• Translate business requirements into data structures and facts/dimensions
• Identify and design fact tables, dimension tables, hierarchies, and measures.
• Ensure accurate representation of business metrics (KPIs) and aggregation rules
• Optimize designs for query performance (e.g., indexing strategies, partitioning concepts).
• Collaborate with ETL/ELT & data engineering teams on source-to-target mappings and transformations.
• Perform data analysis and profiling to validate data patterns, detect anomalies, and improve data quality

Qualifications:

• 5+ years of experience in Data Modelling.
• Strong command over SQL, including complex queries, joins, and stored procedures.
• In depth understanding of Data Warehousing and Data integration concepts
• Solid understanding of data modeling, ETL processes, and database design.
• Good Communication skills.
• Excellent problem-solving and analytical skills.
• Effective communication skills for collaborating with cross-functional teams and presenting data insights.

Good to Have :

• Knowledge of cloud-based data platforms (e.g., Azure, AWS, GCP).
• Familiarity with scripting languages (Python, R) for advanced analytics.
• Prior experience in Agile/Scrum methodologies.