Senior Data Designer

DataArt; United States; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Vacation days

Illness days

Health insurance

Multisport

Psychological support

English classes

Learning platforms

Flexible work

Skills mentoring

Public speaking opportunities

Paid bench time

Certification reimbursement

Job summary

DataArt is seeking a Senior Data Designer to bridge business and engineering, leading requirements workshops and turning insights into governed, well-documented data platform designs. You’ll shape ingestion design, transformations, and data harmonization while collaborating with stakeholders and platform teams.

You will contribute to source systems analysis, design reviews, and ensure designs meet data governance and privacy standards in an agile environment.

Qualifications

• Strong foundations in dimensional modeling and able to justify design choices.
• Hands-on experience producing source-to-target mapping documentation.
• Understanding of data platform layering and data load approaches.
• Proficient SQL for data profiling and validation.
• Strong written and spoken English; adept at gathering requirements from stakeholders.
• Attention to detail in governed environments with reviews and design standards, including data privacy/PII classification.

Responsibilities

• Design and document Enterprise Data Warehouse objects: data models, mappings, diagrams, and supporting design docs for engineers.
• Onboard new data sources by working with stakeholders and SMEs and adapt designs accordingly.
• Clarify requirements upfront: why needed and whether current structures suffice.
• Profile and analyze source data to validate design assumptions.
• Define data quality rules to guide downstream implementation.
• Investigate data issues, identify root causes, and propose design-level fixes.
• Lead peer and design reviews and communicate updates to stakeholders.

Skills

Dimensional modeling

Source-to-target mapping

Data platform layering

SQL for data profiling

Requirements gathering

Data privacy/PII classification

Tools

SAP

Retail domain

Agile delivery

Job description

Technology stack

Core: SQL, dimensional/Kimball data modelling, enterprise data warehouse tools, cloud data platforms

Additional technologies used within the project: Python, PySpark, data profiling tooling

Project overview

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.

Team

You will be part of a collaborative data team working alongside data designers, data engineers, and platform specialists. The team operates in an agile environment, shares knowledge actively, and follows established data design standards and review practices.

Position overview

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.

Responsibilities

• 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

Requirements

• 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

Nice to have

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

What We Offer

• Vacation days: Up to 26 business days per year.
• 10 illness/special days off per year (fully paid, no medical papers needed) for all contract types
• Health and life insurance (Luxmed)
• MyBenefit platform with Multisport option
• Internal psychological support service
• English language classes from the first working day
• Access to external learning platforms: O’Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal training
• Flexible workplace: work from the office, from home, or choose a hybrid option
• Tech Skills Mentoring Program
• Opportunities to develop as a public speaker, mentor, or technical interviewer
• Fully paid idle (bench) when not involved in a project
• Certification reimbursement (AWS, GCP, Microsoft, etc.)