Data Architect
TALENTS, LLC
Kearny, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Remote
Kearny, United States of America
Tech stack
Third Normal Form
Artificial Intelligence
Azure
Databases
Data Architecture
Information Engineering
Data Vault Modeling
PostgreSQL
Metadata
Microsoft SQL Server
NoSQL
Lucidchart
Reverse Engineering
Enterprise Data Management
Large Language Models
Snowflake
Star Schema
Data Management
Physical Data Models
Redshift
Job description
- Define end-to-end enterprise data architecture strategy aligned with business goals
- Design conceptual, logical, and physical data models for analytics and reporting
- Build scalable Lakehouse architectures using Bronze, Silver, and Gold layers
- Establish governance standards for metadata, security, and master data management
- Enable AI-ready platforms supporting LLMs, Vector Databases, and RAG pipelines
- Collaborate with engineers, analysts, and business stakeholders on technical roadmaps
Requirements
- 8+ years in Data Architecture / Senior Data Engineering
- Strong data modeling experience: 3NF, Star Schema, Snowflake, Data Vault 2.0
- Expertise in reverse engineering legacy databases and modernization
- Hands-on with ER/Studio, Erwin, Lucidchart or similar tools
- Experience with Azure Fabric / Synapse, AWS Redshift / Glue, Snowflake
- Strong SQL knowledge (PostgreSQL, SQL Server) and NoSQL databases
- Exposure to Vector Databases such as Pinecone or Milvus
