Position: Data Modeller
Experience: 8–10 Years
Location: Bangalore / Pune / Mumbai / Hyderabad / Noida
Type: Hybrid / Remote
Client- Avi Software
Working Model:
● Hybrid work model with 2–3 days per week from the office or Remote based on project requirements.
● Shift Timing: 2:00 PM – 10:00 PM IST with 4 hours overlap with the UK Shift.
● Contract position for 5–6 Months (C2C).
Key Responsibilities:
● Design and develop enterprise-scale dimensional data models using Star Schema
and Snowflake Schema methodologies.
● Build logical and physical data models to support business intelligence, analytics, and reporting requirements.
● Create and maintain source-to-target mappings, data lineage, and transformation documentation.
● Design hierarchies, dimensions, fact tables, and metadata structures to enable scalable analytics.
● Convert NetSuite business data into a robust and reliable analytics layer.
● Develop draft data models during the initial project phases to minimize production validation efforts.
● Collaborate with Data Architects, Data Engineers, Business Analysts, and stakeholders to understand business requirements and translate them into effective data models.
● Validate data models against production datasets and ensure data consistency, integrity, and quality.
● Support data migration, integration, and analytics initiatives by defining scalable modeling standards.
● Prepare technical documentation and ensure adherence to enterprise data governance and best practices.
Required Skills
● 8–10 years of experience in Data Modeling and Data Warehousing.
● Strong expertise in Dimensional Data Modeling, including Star Schema and
Snowflake Schema design.
● Experience creating Source-to-Target Mapping (STTM) documents and maintaining
Data Lineage.
● Strong understanding of data warehousing concepts, dimensional modeling techniques, and analytics architectures.
● Experience working with NetSuite data or similar ERP systems.
● Knowledge of data integration, transformation, and migration methodologies.
● Strong SQL skills and understanding of relational databases.
Pay: Up to ₹80,000.00 per month
Work Location: Hybrid remote in Hyderabad, Telangana (Hyderabad District)
