Application Data Architect (3NF)
Posted Today by Zettalogix INC
Negotiable
Undetermined
Remote
Remote
Summary: The Application Data Architect (3NF) role is a remote position focused on designing and architecting relational databases with a strong emphasis on normalization, particularly in 3NF. The candidate will collaborate across teams in Agile/Scrum environments and must possess extensive experience in software architecture and relational database design. The role requires hands-on experience with data modeling tools and a solid understanding of SQL and data governance. Familiarity with NoSQL databases and microservices architecture is also beneficial.
Key Responsibilities:
- Design and architect relational databases with a focus on 3NF normalization.
- Collaborate with multiple teams in Agile/Scrum environments.
- Utilize data modeling tools for application-focused data modeling.
- Work with conceptual, logical, and physical data models.
- Review and write SQL, validating generated SQL for issues.
- Understand data governance principles including privacy and security.
- Support systems built around APIs and services.
Key Skills:
- 5+ years of software architecture/design experience.
- 10+ years of relational database design & normalization experience.
- Strong collaboration and communication skills.
- Hands-on experience with data modeling tools (e.g., DbSchema, Vertabelo, ERBuilder).
- Experience with relational databases such as PostgreSQL, MySQL, Oracle, and SQL Server.
- Understanding of data governance (privacy, security, retention).
- Experience with NoSQL databases (e.g., Cassandra, MongoDB).
- Experience with microservices architecture.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job: Application Data Architect (3NF)
LOCATION Remote
DURATION 6 months contract-to-hire
REQUIRED SKILLS 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)
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 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
Nice to Have:
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