Data Modeling

Indus Infotech; Telangana; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Indus Infotech is seeking a hands-on data modeling expert to design and implement scalable enterprise data models for reporting and analytics. The role emphasizes Star Schema and Snowflake Schema, Dimensional modeling, and strong Kimball methodology, with Microsoft Fabric and Azure Synapse as core platforms.

You will collaborate with data engineers and business stakeholders to translate requirements into scalable EDW solutions, establish standards, and contribute to governance and performance

Qualifications

• Data modeling for EDW and enterprise reporting.
• Hands-on with Star Schema, Snowflake schema, Kimball methods.
• Experience with Microsoft Fabric and Synapse.
• Strong SQL/TSQL and performance tuning.
• Knowledge of data governance and metadata management.

Responsibilities

• Design conceptual, logical, and physical data models.
• Develop enterprise-grade Fact and Dimension models for reporting.
• Build reusable semantic models for analytics.
• Collaborate with stakeholders to translate requirements into scalable EDW solutions.
• Support Fabric and Synapse-based enterprise data warehouse architecture.
• Establish data modeling standards, documentation, governance, and best practices.

Job description

• Data Modeling (Contract/FTE)
• Rel. Exp (Years): 8+ Years
• Location: Hyderabad is preferred
• Hi Team,

We are experiencing a high rejection ratio for this requirement and need your immediate support to close this position at the earliest.

Kindly share more relevant and high-quality profiles matching the below mandatory skills:

Mandatory Skills:

• Data Modelling (Primary)
• Microsoft Fabric Notebook
• Fabric Pipeline
• Lakehouse
• Warehouse
• OneLake Concepts

Please prioritize candidates with strong hands‑on experience in the above technologies and share only closely matching profiles.

Your prompt support is highly appreciated.

Any Project specific Prerequisite skills: Primary Skills: Data Modeling Star schema, snowflake schema, dimensional modeling, Kimball methodology, fact and dimension design, conformed dimensions, SCD patterns, bridge tables, snapshots, aggregates, normalization and denormalization.

Secondary Skills: Microsoft Data Platform Microsoft Fabric Lakehouse and Warehouse, Azure Synapse Analytics, SQL Server, Power BI semantic models, Direct Lake, SQL endpoints, and Delta Lake concepts.

Job Description W

We are specifically looking for a strong hands‑on resource with proven experience in Microsoft Fabric, Azure Synapse Analytics, Enterprise Data Warehousing, and Dimensional Data Modeling. The primary responsibility of this role will be to design and implement scalable Star Schema and Snowflake Schema based data models for our enterprise reporting, analytics, and semantic modeling requirements.

Key Skills Required:

• Strong experience in Enterprise Data Warehousing (EDW)
• Expert-level knowledge of Star Schema and Snowflake Schema design
• Microsoft Fabric (Lakehouse, Warehouse, Semantic Models)
• Azure Synapse Analytics
• Power BI Semantic Modeling
• Advanced SQL / T-SQL
• Fact & Dimension modeling
• Slowly Changing Dimensions (SCD Type 1 & Type 2)
• Data Governance and Metadata Management
• Performance optimization for large-scale analytical workloads

Primary Responsibilities:

• Design conceptual, logical, and physical data models.
• Develop enterprise-grade Fact and Dimension models following industry best practices.
• Build and maintain reusable semantic models for reporting and analytics.
• Collaborate with business stakeholders, data engineers, and reporting teams to translate business requirements into scalable EDW solutions.
• Support Fabric and Synapse-based enterprise data warehouse architecture and modernization initiatives.

Establish data modeling standards, documentation, governance, and best practices.