3-4 rounds of interview, technical and behavior
Key Responsibilities
Data Architecture & Design
· Translate business requirements into scalable database designs
· Design and enhance databases for:
o Online transactional systems
o Master Data Management (MDM) solutions
· Perform logical and physical data modeling using modern tools
Technology & Data Solutions
· Define and guide data persistence using:
o AWS cloud databases (relational & NoSQL)
o Caching solutions
· Ensure proper database/domain alignment for new data use cases
Collaboration & Governance
· Partner with Product Managers, Architects, and Engineering teams
· Work with Data Management and InfoSec to ensure:
o Data quality
o Security
o Integrity
· Promote data literacy through data catalog tools
Best Practices & Strategy
· Establish and improve data architecture best practices
· Drive knowledge capture and documentation across the organization
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