Data Modeler_ Remote

Overview

Remote
Depends on Experience
Contract - W2

Skills

Redshift
data modeling
Erwin
Amazon Redshift
PostgreSQL
DynamoDB
AWS
Glue

Job Details

Key Responsibilities

  • Design conceptual, logical, and physical data models, with a strong emphasis on Amazon Redshift data warehouse architectures.

  • Create source-to-target mappings and optimized target-state models for Redshift.

  • Profile and analyze datasets in Redshift to assess data quality, lineage, and reuse potential.

  • Collaborate with business and technical stakeholders to define business rules, KPIs, and analytics requirements.

  • Develop and maintain data dictionaries, ER diagrams, and metadata documentation.

  • Define and implement data governance standards for certified and reusable data products.

Required Skills

  • Strong expertise in data modeling tools such as ER/Studio, Erwin, or similar.

  • Hands-on experience with Amazon Redshift (schema design, performance optimization, and analytics modeling).

  • Strong knowledge of relational and NoSQL databases, including:

    • Amazon Redshift

    • PostgreSQL

    • DynamoDB

  • Experience with data governance, data quality, lineage, and compliance frameworks.

  • Excellent analytical, documentation, and communication skills.

Qualifications

  • Bachelor s degree in Computer Science, Data Science, or a related field.

  • 5+ years of hands-on experience in data modeling and database design, including Amazon Redshift.

  • Experience with AWS data services such as Redshift, Glue, and S3 is a strong plus.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.