Data Modeler

Role Overview

We are looking for a seasoned Data Modeler to join our team. You will be responsible for the full lifecycle of data modeling—from initial business discovery to the implementation of physical designs. You must be equally comfortable whiteboarding concepts with business stakeholders and optimizing physical schemas for high-performance platforms like Netezza.

Core Responsibilities

• Stakeholder Engagement: Proactively engage with business partners to understand complex business logic and translate those requirements into accurate data models.
• Multi-Layer Modeling: Design and maintain Conceptual, Logical, and Physical models to ensure data integrity and scalability.
• Platform Design: Develop and refine designs specifically targeted for the Netezza platform, ensuring alignment with our resource model.
• Architecture Evolution: Support the integration of Lakehouse concepts into our existing Data Warehouse environment.
• Tooling & Standards: Use ErWin (or similar enterprise modeling tools) to document and manage the enterprise data model.

Requirements

Required Technical Skills

• Advanced Modeling: Extensive experience in Dimensional, 3NF, and Vault modeling across all three design layers (Conceptual/Logical/Physical).
• Platform Proficiency: Must be comfortable and willing to work with the Netezza platform.
• Data Environments: Strong foundation in Data Warehouse architecture and modern Lakehouse concepts.
• Software: Hands-on proficiency with ErWin or a comparable enterprise modeling suite.

Preferred Qualifications

• Direct experience with Databricks.
• Previous experience in the transportation or logistics sector.

Key Competencies

• Independence: A "consultant mindset" with the ability to navigate the business side of the organization without constant hand-holding.
• Precision: An eye for detail in translating business rules into technical constraints.
• Communication: Ability to bridge the gap between technical developers and non-technical business users.