Overview
Data Modeler Jobs in Montreal, Quebec, Canada at KData AI
Title: Data Modeler
Company: KData AI
Location: Montreal, Quebec, Canada
Company Description
KData AI accelerates enterprise data and artificial intelligence initiatives by offering expert consulting services in Databricks, Snowflake, and Informatica. The company empowers organizations with specialized talent and innovative solutions to address complex data challenges. KData AI prides itself on enabling businesses to unlock value from their data for strategic decision-making and growth.
Job Title: Data Modeler
Location: Remote / Hybrid (Per Client's Guidelines)
Department: Data Architecture & Strategy
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.
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.
