View All Jobs
Data Modeler
Pune
About Us
We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.
Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.
Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.
At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity
How We Work?
Define, Design and Deliver (D3) is our in-house delivery philosophy. It’s culled from agile and rapid methodologies and focused on ‘just enough design’. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.
We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.
Job Description
We are looking for an experienced Data Modeler responsible for designing scalable, governed, and high-performance data models for enterprise data platforms. The role will work closely with Data Architects, Data Engineers, BI developers, business stakeholders, and application teams to translate business requirements into logical and physical data models.
The candidate should have strong experience in enterprise data modeling, dimensional modeling, data warehousing, cloud data platforms, and modern Lakehouse architectures.
Key Responsibilities
- Design Conceptual, Logical and Physical Data Models for enterprise data platforms.
- Develop dimensional models using Star and Snowflake schemas.
- Design fact and dimension tables, including conformed dimensions.
- Define grain, keys, relationships, cardinality and referential integrity.
- Design SCD Type 1, Type 2 and other historical tracking approaches.
- Work with Data Architects to define enterprise data architecture and modeling standards.
- Create models for Data Warehouse, Data Lake and Lakehouse environments.
- Develop data models for Bronze, Silver and Gold layers in a Lakehouse architecture.
- Optimize models for analytical workloads and BI reporting.
- Work closely with Power BI/Tableau teams to create models suitable for semantic-layer consumption.
- Analyze source systems and map source attributes to target data models.
- Perform source-to-target mapping and define transformation rules.
- Identify data quality, duplication, normalization and data integrity issues.
- Define metadata, business definitions and data lineage.
- Support Data Governance, Master Data Management and reference-data modeling.
- Collaborate with Data Engineers during implementation and validate the implemented model.
- Review SQL queries and database structures for performance and scalability.
Job Requirement
Core Data Modeling
- Conceptual, Logical & Physical Data Modeling
- ER Modeling
- Relational Data Modeling
- Dimensional Modeling
- Star/Snowflake Schema
- Fact & Dimension Design
- SCD Type 1 / Type 2
- Normalization / Denormalization
- Data Vault — good to have
- Enterprise Data Modeling
- Canonical Data Models
- Master & Reference Data Modeling
Data Warehousing
- Enterprise Data Warehouse
- Data Marts
- ETL/ELT architecture
- Source-to-Target Mapping
- Data Integration
- Data Quality
- Data Lineage
Cloud / Modern Data Platforms
- Databricks / Delta Lake
- Unity Catalog
- Lakehouse Architecture
- Azure Data Lake Storage
- Azure Synapse
- AWS Redshift
- Snowflake — good to have
- Microsoft Fabric — good to have
Modeling Tools
Experience with one or more:
- ER/Studio
- Erwin Data Modeler
- Sparx Enterprise Architect
- SAP PowerDesigner
- SQL Developer Data Modeler
- dbt
- Databricks data-modeling capabilities
Join Talent Pool
Join our talent pool by simply submitting your resume. We’ll inform you about the new jobs matching your profile and update you if you are the best fit for one of our open positions.