Data Modeler (Erwin, ER Studios)

Overview

Responsibilities

• Key Responsibilities

  • Design

    conceptual, logical, and physical data models

    for platforms such as

    Snowflake, Azure Synapse, SQL Data Warehouse, EMR, Spark, Databricks

    .
  • Govern data design and modeling, including

    metadata documentation

    and database object construction.
  • Collaborate with

    Data Governance, Data Engineering, and Data Architects

    to ensure compliance with standards.
  • Prepare

    Source-to-Target mappings

    and define

    data transformation rules

    for ETL and BI developers.
  • Support

    data lineage, profiling, and metadata management

    for enterprise data models.
  • Develop

    reusable data models

    with an extensible philosophy to minimize future rework.
  • Partner with IT and business teams to incorporate

    security, regulatory compliance, and privacy-by-design principles

    .
  • Drive collaborative reviews of design, code, and data security features.
  • Assist with

    data planning, sourcing, collection, profiling, and transformation

    .
  • Advocate

    data design patterns

    for scalable and efficient models.

Qualifications

• Must-Have Qualifications

  • 5+ years

    overall technology experience, including

    2+ years in data modeling and systems architecture

    .

  • 2+ years

    experience developing

    Enterprise Data Models

    .
  • Expertise in

    data modeling tools

    : ER/Studio, Erwin, IDM/ARDM.
  • Experience with

    Snowflake

    and at least one

    MPP database technology

    (Synapse, Teradata, Redshift).

  • 2+ years

    experience with

    Data Lake Infrastructure, Data Warehousing, and Data Analytics tools

    .
  • Strong knowledge of

    Source-to-Target mapping

    and

    canonical model design

    .
  • Experience with

    multi-cloud integration (Azure)

    and on-premises technologies.
  • Basic

    SQL and/or Python

    skills.
  • Excellent verbal and written communication skills.