Data Architect: Design Scalable Data Models & Architecture

Peregrine Advisors; Washington; On-site; USD 120,000 - 180,000; Full time

Job summary

OPEN Data Jobs is seeking a Data Architect to shape how an organization represents, connects, governs, and uses data across systems. The role translates business processes and constraints into conceptual, logical, and physical models that teams can implement and evolve.

You will collaborate with data engineers, security teams, and business stakeholders to balance information needs with scale, cost, and migration risk while maintaining data quality and traceability.

Qualifications

• Experience with data modeling, schema design, normalization, dimensional modeling, and model evolution.
• Judgment across relational, analytical, document, graph, key-value, and vector-capable data stores.
• Understanding of integration patterns, data contracts, metadata, lineage, data quality, and governed access.
• Ability to evaluate architecture choices against security, resilience, performance, scalability, cost, and migration risk.
• Clear visual, written, and verbal communication across engineering, security, product, and business teams.

Responsibilities

• Create conceptual, logical, and physical data models for operational and analytical systems.
• Define target-state architectures for warehouses, lakes, lakehouses, relational databases, and specialized stores.
• Develop governance-aware designs for metadata, lineage, access, retention, quality, and lifecycle management.

Skills

Data modeling

Schema design

Normalization

Dimensional modeling

Model evolution

SQL

Tools

SQL

Job description

OPEN Data Jobs is seeking a Data Architect to shape how an organization represents, connects, governs, and uses data across systems. The role translates business processes and constraints into conceptual, logical, and physical models that teams can implement and evolve.

You will collaborate with data engineers, security teams, and business stakeholders to balance information needs with scale, cost, and migration risk while maintaining data quality and traceability.