Description

Design and maintain conceptual, logical, and physical data models for relational, dimensional, and NoSQL stores to support enterprise data standards and reporting pipelines.

This role is hybrid.

Responsibilities

• Build and maintain entity-relationship diagrams (ERDs), data dictionaries, and lineage documentation aligned with enterprise standards.
• Translate business requirements into optimized database schemas for data warehouses and marts, ensuring scalability and performance.
• Partner with data platform engineers and architects to support efficient ingestion, transformation, and reporting pipelines.
• Conduct data model reviews, enforce modeling best practices, and provide technical guidance to junior team members.
• Identify and resolve data quality, redundancy, and integrity issues through sound modeling practices.

Required Skills

• 7+ years of experience in data modeling, data architecture, or a closely related discipline.
• Expert proficiency in data modeling tools such as Erwin, ER/Studio, or dbt.
• Deep experience with relational databases including SQL Server, Oracle, and PostgreSQL.
• Experience with cloud data platforms such as Databricks, Snowflake, BigQuery, Redshift, or Azure Synapse.
• Strong command of dimensional modeling techniques including Kimball, Inmon, or Data Vault 2.0.
• Proficiency in SQL for schema design, query optimization, and data validation.
• Bachelor's degree in Computer Science, Engineering, or a related field.
• Ability to work independently in a contractor/consulting capacity within an Agile delivery model.

Preferred Skills

• Experience with NoSQL data stores (MongoDB, Cassandra, DynamoDB) and data Lakehouse architectures (Delta Lake, Apache Iceberg, Apache Hudi).
• Familiarity with data governance platforms such as Collibra, Alation, or Atlan.

Key Skills

Education

Bachelor's degree