Key Responsibilities

Data Modeling

Data Modeling

Create and maintain conceptual, logical, and physical data models
Design entities, attributes, relationships, hierarchies, keys, and cardinalities.
Define and document business entities such as Customer, Product, Store, Order, Transaction, Supplier, Account, and similar core business concepts.
Support the design of reusable and conformed data models across domains and data products.

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.
Ensure consistent business definitions for KPIs and analytical measures.
Collaborate with BI teams to ensure models are usable, performant, and understandable for reporting consumers.

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.




Work with Data Engineers to translate mappings into implementation-ready pipeline logic.
Support validation of implemented data models against business and technical requirements.

Skills

Technical Skills:
Strong knowledge of data modeling methodologies: Conceptual, logical, physical, dimensional
Understanding of database and lakehouse concepts: tables, views, keys, constraints, partitioning, clustering, delta tables, schema evolution
Experience with cloud data platforms, ideally Databricks
Understanding of BI and semantic modeling concepts: Semantic layers, Metrics layers, DatabricksSQL, PowerBI

Soft Skills: Strong analytical thinking and attention to detail.

Ability to understand complex business processes and translate them into data structures.
Strong communication skills with both business and technical stakeholders.
Structured and documentation-oriented working style.
Ability to challenge unclear requirements and identify inconsistencies.
Collaborative mindset and willingness to work across teams.

Ability to work independently as an external consultant.

#J-18808-Ljbffr

📌 Sr Data Modeler (Buenos Aires)
🏢 Texplorers
📍 Buenos Aires