Data Modeling

Job Description:

• About the job
• Join a team where data is treated as a product and strong modeling is the foundation for trusted analytics and scalable platforms
• In this role you ll translate business needs into clear well structured data models that make reporting faster insights sharper and downstream systems easier to maintain
• You ll collaborate closely with business stakeholders data engineers and BI teams to design models that balance usability performance and governance
• If you enjoy bringing clarity to complex domains documenting decisions and building data structures that stand the test of time this is a great opportunity to grow your impact while working in a supportive collaborative environment

Key Responsibilities:

• Key Responsibilities
• Gather and analyze business requirements to design robust conceptual logical and physical data models
• Create and maintain dimensional models using Star Schema to support analytics and reporting use cases
• Develop and refine logical data models with clear entities relationships and business definitions
• Produce physical models aligned to target platforms considering performance storage and scalability needs
• Define keys constraints normalization denormalization strategies and data standards to ensure consistency and quality
• Partner with engineering and BI teams to validate models resolve data issues and support implementation handoffs
• Maintain documentation data dictionaries and model versioning to ensure traceability and reuse
• Participate in design reviews and contribute to best practices for enterprise data modeling and governance
• Minimum Qualifications
• Education BTECH MTECH MCA MSC or equivalent
• 3 5 years of experience in data modeling for analytics reporting or data platform initiatives
• Hands on expertise in Star Schema Logical Data Modeling and Physical Modeling
• Strong understanding of relational concepts entity relationship modeling and dimensional modeling principles
• Ability to translate business requirements into clear implementable data structures and documentation

Technical Requirements:

• Good to have skills
• SQL Data Warehousing ETL Concepts Data Governance Metadata Management

Additional Responsibilities:

• Preferred Qualifications
• Experience modeling for enterprise data warehouses lakes and supporting multiple downstream consumers BI analytics data science
• Proven ability to optimize models for performance and usability balancing normalization and denormalization trade offs
• Familiarity with data governance practices such as naming standards metadata management and stewardship collaboration
• Strong stakeholder communication skills including facilitating requirement workshops and presenting model designs
• Experience working in Agile delivery teams and contributing to iterative model evolution and change management

Preferred Skills: