Application Data Architect

Intellitask LLC
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote

Tech stack

Java
API
Agile Methodologies
Amazon Web Services (AWS)
Cloud Database
Databases
Data Architecture
Data Governance
Data Security
Data Structures
Data Systems
Data Warehousing
Relational Databases
Database Design
PostgreSQL
Meta-Data Management
Microsoft SQL Server
MongoDB
MySQL
NoSQL
Object-Relational Mapping
Oracle Applications
Software Architecture
Application Data
SQL Databases
Privacy Controls
Enterprise Software Applications
Caching
Collibra
Cassandra
Physical Data Models
Microservices

Job description

We are looking for an experienced Application Data Architect to lead the design and evolution of data structures that power enterprise applications. This position requires a strong background in database architecture, data modeling, and application-focused data design within modern distributed environments. The ideal candidate will be passionate about creating scalable, efficient, and well-governed data solutions that support business growth and technology modernization., * Design and maintain logical and physical database models that support high-volume transactional systems.

  • Create well-structured, normalized database schemas with a focus on scalability, performance, and maintainability.
  • Define data standards, entity relationships, constraints, and governance practices across application platforms.
  • Partner with engineering teams to ensure data models align with application functionality and business objectives.
  • Support cloud-based data initiatives utilizing both relational and NoSQL technologies.
  • Evaluate data access patterns and recommend appropriate persistence and caching strategies.
  • Collaborate with security and governance teams to ensure compliance with data protection and retention requirements.
  • Review database designs, SQL implementations, and architectural decisions to ensure consistency and quality.
  • Establish best practices for data architecture and contribute to long-term technology roadmaps.
  • Produce and maintain architecture documentation, standards, and modeling artifacts.

Requirements

  • 10+ years of experience designing and managing relational database solutions.
  • 5+ years in Data Architecture, Software Architecture, or related design-focused roles.
  • Deep understanding of database normalization, schema design, and transactional application data structures.
  • Strong hands-on experience creating conceptual, logical, and physical data models.
  • Experience with data modeling platforms such as ERwin, ER Studio, DbSchema, Vertabelo, or similar tools.
  • Expertise with PostgreSQL, MySQL, Oracle, SQL Server, or equivalent relational database platforms.
  • Ability to analyze, validate, and troubleshoot SQL queries.
  • Experience supporting application-centric environments rather than reporting or data warehouse platforms.
  • Knowledge of NoSQL technologies such as MongoDB, Cassandra, or similar databases.
  • Understanding of microservices, APIs, and distributed application architectures.
  • Familiarity with data governance, security controls, privacy standards, and lifecycle management.
  • Excellent communication skills with the ability to work across business and technical teams.
  • Experience working within Agile development environments., * Experience designing solutions within AWS cloud environments.
  • Knowledge of Object-Relational Mapping (ORM) concepts and frameworks.
  • Exposure to Java and/or Go-based application ecosystems.
  • Experience with metadata management or data catalog platforms such as Alation or Collibra.
  • Previous experience in Financial Services, Insurance, or other highly regulated industries.

Ideal Background

We are seeking someone who combines strong technical depth in database architecture with the ability to collaborate across product, engineering, and business teams. Candidates should be comfortable designing data solutions for modern applications, balancing scalability, performance, governance, and long-term maintainability.

Apply for this position