About Texplorers Inc :

Texplorers Inc is a fast-growing technology consulting firm specializing in cloud data engineering, advanced analytics, and AI-driven solutions. We partner with Fortune 500 and high-growth enterprises to architect, build, and scale modern data platforms. Our culture emphasizes innovation, ownership, and continuous learning.

Role Overview :

We are looking for an experienced Data Modeler to support the design and delivery of enterprise data models across business domains such as Finance, Sales, Retail, Supply Chain, Product, Customer, and Digital Commerce. The role will focus on translating business requirements into high-quality conceptual, logical, physical, and semantic data models.

Key Responsibilities :

Data Modeling :

- Create and maintain conceptual, logical, and physical data models.

- Design entities, attributes, relationships, hierarchies, keys, and cardinalities.

- Develop dimensional models, including facts, dimensions, bridge tables, slowly changing dimensions, and aggregation structures.

- Define and document business entities such as Customer, Product, Store, Order, Transaction, Supplier, Account, and similar core business concepts.

Semantic and Analytical Modeling :

- Design models optimized for analytics, reporting, and BI consumption.

- Define business metrics, measures, dimensions, hierarchies, and calculation logic.

- Support semantic layer design for tools such as Power BI, Databricks SQL, Databricks Metric Views, or similar platforms.

Source-to-Target Mapping :

- Analyze source system structures and map them to target data models.

- Create and maintain source-to-target mappings, including transformation logic and business rules.

- Identify gaps, inconsistencies, duplicate structures, and data quality issues in source systems.

Technical Skills :

- Strong knowledge of data modeling methodologies : Conceptual, logical, physical, dimensional.

- Strong SQL skills.

- Understanding of database and lakehouse concepts : tables, views, keys, constraints, partitioning, clustering, delta tables, schema evolution.

- Experience with cloud data platforms, ideally Databricks.