Application Data Architect
Role details
Job location
Tech stack
Requirements
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)