Overview

We are seeking an experienced Data Modeler to lead logical and physical data modeling efforts across Raw, Conformed, and CDM layers within a medallion architecture. The ideal candidate will design dimensional (star/snowflake) and 3NF schemas where appropriate, implement and enforce modeling standards (naming conventions, data types, SCD strategies), and maintain thorough documentation using SqlDBM or equivalent tools.

This position requires a minimum of four hours of overlapping working time with the New York time zone to ensure effective collaboration and team meetings.
Client:
Our client revolutionizes the retail direct store delivery model by addressing key challenges like communication gaps, out-of-stocks, invoicing errors, and price inconsistencies to boost sales, profits, and customer loyalty with innovative technology and partnerships.
Project Overview:

Responsibilities:
  • Lead logical and physical data modeling across Raw, Conformed, and CDM layers following medallion architecture
  • Design dimensional (star/snowflake) and 3NF schemas where appropriate
  • Implement and enforce modeling standards, including naming conventions, data types, and SCD strategies
  • Document models and processes using SqlDBM or equivalent tools
  • Translate business requirements into canonical data models and source-to-target mappings
  • Collaborate closely with engineers and analysts to ensure alignment and accuracy
  • Design and optimize Snowflake schemas focusing on DDL, micro-partitions, clustering, RBAC, and cost-efficient patterns
  • Manage Postgres schema design, perform tuning, and optimize queries
  • Review and refactor PL/pgSQL code (bonus)
  • Maintain strong data governance practices including version control, peer reviews, and data lineage tracking
Required Qualifications:
  • Proven expertise in data modeling across multiple layers of medallion architecture
  • Strong understanding of data modeling concepts (OLTP, Star Schema, Medallion architecture)
  • Strong experience with dimensional modeling (star/snowflake) and 3NF design
  • Skilled in Snowflake schema design, performance tuning, and security best practices
  • Experience with Postgres schema design and query optimization
  • Familiarity with data governance standards and tools
  • Proficiency with SqlDBM/ERwin or equivalent modeling/documentation platforms
Note:

Our intelligent job search engine discovered this job and republished it for your convenience.
Please be aware that the job information may be incorrect or incomplete. The job announcement remains the property of its original publisher. To view the original job and its full details, please visit the job's URL on the owner’s page.

Please clearly mention that you have heard of this job opportunity on https://ijob.am.