Senior Data Designer

DataArt; Georgia; Hybrid; USD 120,000 - 180,000; Full time

Job summary

DataArt is seeking a Senior Data Designer to bridge business stakeholders and engineering. You will design enterprise data warehouse objects, onboarding data sources, and ensure governance, quality, and documentation.

You will shape requirements, profile source data, and collaborate with platform teams to build scalable ingestion, transformation, and data harmonization for data-driven decisions across complex domains.

Qualifications

• Strong practical foundations of dimensional modeling and ability to design warehouse models from raw source data
• Hands-on experience producing source-to-target mapping documentation
• Understanding of data platform layering and data load approaches
• Confident SQL for data profiling and validation
• Strong written and spoken English; gathering requirements and managing stakeholder expectations
• Attention to detail in governed environments with reviews and data privacy/PII handling

Responsibilities

• Design and document Enterprise Data Warehouse objects: data models, mappings, diagrams, and design docs for engineers
• Onboard new data sources with stakeholders and adapt designs to source capabilities
• Clarify requirements to understand stakeholder intent and existing coverage
• Profile and analyze source data to validate design assumptions
• Define data quality rules for downstream teams
• Investigate data issues, identify root causes, and propose design fixes
• Lead peer and design reviews and communicate issues early to stakeholders

Skills

Dimensional modeling

Source-to-target mappings

SQL for data profiling

Data quality rules

Requirements gathering

Stakeholder management

Tools

SQL

Job description

We are looking for a Senior Data Designer who can operate as the bridge between business stakeholders and engineering — someone equally comfortable running a requirements workshop and designing a Kimball-style dimensional model. This is not a pure modelling role: you'll investigate source systems, challenge and shape business requirements before any design work starts, and turn that understanding into governed, well-documented data platform designs that engineering teams can implement. You will contribute to data ingestion design, transformation logic, and data harmonization while working closely with stakeholders and platform teams.

This project focuses on building and enhancing an enterprise data warehouse platform that supports data driven decision making across complex business domains. The work involves designing scalable data models, ingestion pipelines, and transformation logic to ensure high quality and consistent data.

• Design and document Enterprise Data Warehouse objects: data models, source-to-target mappings, model diagrams, and supporting design documentation that engineers deliver from
• Work with stakeholders and source-system SMEs to onboard new data sources and adapt designs to what each source provides
• Clarify the intent behind requirements before designing: why the stakeholder needs it and whether existing structures already cover it
• Profile and analyze source data to validate design assumptions
• Define data quality rules as part of designs for downstream teams to implement
• Investigate reported data issues, identify root causes, and propose design-level fixes
• Take designs through peer and design review; give and take constructive challenge
• Keep stakeholders informed: raise issues early, ask instead of assuming, follow up until unblocked

• Strong practical foundations of dimensional modeling — able to design warehouse models from raw source data and explain the reasoning behind design choices
• Hands-on experience producing source-to-target mapping documentation
• Working understanding of data platform layering and data load approaches
• Confident SQL for data profiling and validation
• Strong written and spoken English; comfortable gathering requirements and managing stakeholder expectations
• Attention to detail; comfortable working in a governed environment with reviews and design standards, and data privacy/PII classification requirements

• SAP as a source system
• Retail domain experience
• Agile delivery experience