Senior Data Architect: Dimensional Modeling & DW Platform

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

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.