Application Data Architect

Role: Application Data Architect

Duration: 12 Months+ Contract with extension/CTH

Location: 100% Remote

Job Description

Key Responsibilities

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

MUST HAVE

Required Qualifications

·        

·       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