Application Data Architect (ONLY W2)

Required Qualifications
•                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
•                Strong cross-functional collaborator with product + engineering
•                Familiarity with:
o        Object-Relational Mapping (ORM)
o        Java and/or Go
•                Cloud experience (AWS preferred)
•                Experience with data catalog tools (Alation, Collibra)
•                Background in Insurtech or Fintech