Job Title: Senior Data Modeler
Mode: Full Time – Remote
Experience: 6+ Years
Job Summary
We are looking for an experienced Data Modeler with 6+ years of hands-on experience in designing, developing, and maintaining enterprise-level data models. The ideal candidate will work closely with business stakeholders, data engineers, architects, and analysts to translate business requirements into scalable and high-quality data models that support analytics, reporting, and operational systems.
Key Responsibilities
- Design and maintain conceptual, logical, and physical data models for enterprise data platforms
- Work with business and technical stakeholders to gather and refine data requirements
- Develop dimensional models (Snowflake) for data warehouses and data marts
- Ensure data models align with business rules, data governance, and compliance standards
- Optimize data models for performance, scalability, and data quality
- Collaborate with data engineering teams during ETL/ELT development and data integration
- Maintain data model documentation, data dictionaries, and metadata repositories
- Review and validate data models created by junior modelers
- Support impact analysis for data changes and new initiatives
Required Skills
- 6+ years of experience in data modeling and database design
- Strong expertise in relational databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.)
- Hands-on experience with dimensional modeling for analytics and BI
- Experience with data warehouse concepts and large-scale data environments
- Proficiency in SQL for data analysis and validation
- Experience with data modeling tools (ERwin, ER/Studio, PowerDesigner, Lucidchart, etc.)
- Knowledge of normalization and denormalization techniques
- Understanding of data governance, data quality, and master data management (MDM)
- Preferred / Good-to-Have
- Experience with cloud data platforms (AWS Redshift, Azure Synapse, Snowflake, BigQuery)
- Exposure to big data ecosystems (Hive, Spark, Databricks)
- Knowledge of NoSQL data modeling (MongoDB, Cassandra)
- Familiarity with Agile/Scrum methodologies
- Experience supporting BI tools (Power BI, Tableau, Looker)
Contact mail: bpandurangan@hexalytics.com