Data Architect Role

Open Data Watch, Inc.
Washington, DC, United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Business Analytics Applications Information Systems Databases Data Architecture Data Stores Relational Databases Dimensional Modeling Metadata SQL Databases Cloud Platform System Event Driven Architecture Data Lakes
+2 more
Data Management Physical Data Models

Job description

Data Architects shape how an organization represents, connects, governs, and uses data across systems. They translate business processes, information needs, and technical constraints into conceptual, logical, and physical models that teams can implement and evolve.

The work spans relational databases, analytical platforms, data lakes, warehouses, and other fit-for-purpose stores. You assess a fragmented current state, define a target architecture, establish integration and access patterns, and decide where standardization matters most. Good decisions account for data shape, access patterns, scale, consistency, security, resilience, cost, and the realities of migration.

This is a design and decision role. Data Architects work closely with data engineers, database developers, database administrators, security teams, software engineers, analysts, and business stakeholders. They make tradeoffs visible, preserve traceability from requirements to implementation, and help teams change an estate without losing integrity or control.

What you’ll build

  • Conceptual, logical, and physical data models for operational and analytical systems.
  • Target-state architectures for warehouses, lakes, lakehouses, relational databases, and specialized stores.
  • Canonical models, integration patterns, data contracts, naming standards, and schema conventions.
  • Architecture decision records, transition roadmaps, and current-state or future-state diagrams.
  • Governance-aware designs for metadata, lineage, access, retention, quality, and lifecycle management.

Who you are

You see both the whole information system and the details that make a model implementable. You can identify duplicated concepts, unclear ownership, brittle dependencies, and hidden assumptions, then turn them into decisions that teams can act on.

You are precise without becoming rigid. You listen for how people actually use data, explain tradeoffs to technical and nontechnical audiences, and know when a shared standard creates value and when a local design is the better choice., An opening may emphasize a particular cloud platform, modeling tool, industry data standard, master data discipline, event-driven architecture, or modernization program. Some roles may require hands-on SQL, infrastructure review, or experience guiding implementation across several delivery teams.

Requirements

  • 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.

Benefits & conditions

Compensation, benefits, work location, and employment terms are set for each specific opening and will be stated with that opening.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:47 min

Comparing Egeria to alternative open metadata solutions

Ferd Scheepers · World Congress 2022

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:24 min

The governance failures of centralized data lakes

Mario Meir-Huber · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · World Congress 2022

3:52 min

Navigating data warehouse performance for application developers

Adnan Rahic · JS Congress

Videos

See all

Related articles

See all