Application Data Architect

5+ years of software architecture/design experience

10+ years of relational database design & normalization experience

Relational database design + normalization

Strong emphasis on 3NF (normalized schemas)

Design tables, relationships, keys, constraints

Strong collaboration and communication skills

Experience working in Agile/Scrum environments across multiple teams

Hands-on experience with data modeling tools (e.g., DbSchema, Vertabelo, ERBuilder)

o Application-focused data modeling (NOT analytics)

Both roles design databases for live applications / OLTP systems

Not data warehouse, BI, or dashboards or reporting-focused, not Analytics or AI modeling

Work with conceptual logical physical models

Use tools like DbSchema, ERwin, ER Studio

Experience with relational databases:

o PostgreSQL / MySQL

o Oracle / SQL Server

Must understand, review, and sometimes write SQL

Validate generated SQL and catch issues

Understanding of data governance (privacy, security, retention)

Experience with NoSQL databases (e.g., Cassandra, MongoDB)

Experience with microservices architecture

Understand how applications interact with databases

Support systems built around APIs and services

Nice to Have:

Familiarity with:

o Object-Relational Mapping (ORM)

o Java and/or Go

Cloud experience (AWS preferred)

Experience with data catalog tools (Alation, Collibra)