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.
