Data Architect

• 5+ years of software architecture/design experience
• 10+ years of relational database design & normalization experience

o 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 OR 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

Ideal Candidate Profile (Quick Snapshot)

• Strong data modeling + database design expert
• Comfortable across relational + NoSQL + cloud environments
• Experience working in distributed, microservices-based systems