Application Data Architect

Data Architecture & Design

· Translate business requirements into scalable database designs

Design and enhance databases for:

· Online transactional systems

· Master Data Management (MDM) solutions

· Perform logical and physical data modeling using modern tools

Technology & Data Solutions

Define and guide data persistence using:

· AWS cloud databases (relational & NoSQL)

· 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:

· Data quality

· Security

· 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

· 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)

· 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:

· PostgreSQL / MySQL

· 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

NICE TO HAVE

· Familiarity with:

· Object-Relational Mapping (ORM)

· Java and/or Go

· Cloud experience (AWS preferred)

· Experience with data catalog tools (Alation, Collibra)

· Background in Insurtech or Fintech