Data Architect/Data Modeler

Job Title: Data Architect/Data Modeler

Location: NYC, NY

Duration: 12 Months + Extension

Bill Rate: $70/hr

Job Type: W2 Contract

Client: To Be Discussed Later

Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description:
The ideal candidate will reverse engineer, optimize, and modernize complex database environments. Responsibilities include analyzing undocumented database instances, inferring business logic from schema structures and production-representative data, reconstructing ER models, and redesigning architectures for maximum query efficiency, scalability, and maintainability. The candidate must also read and understand Java services that interact with and maintain the database schema, including ORM mappings and transactional behavior.
**Key Responsibilities**
Reverse engineer database schemas, including tables, indexes, constraints, views, stored procedures, functions, and triggers.
Analyze representative production data to identify entities, relationships, cardinality, workflows, and usage patterns.
Reconstruct logical and physical ER models and document current-state architectures.
Read and analyze Java application/services code to understand database access patterns, ORM mappings, transaction logic, and schema maintenance behavior.
Redesign schemas and data models for efficient joins, query optimization, scalability, data integrity, and maintainability.
Optimize SQL, execution plans, indexing, partitioning, and storage strategies.
Administer enterprise databases including backup/recovery, replication, HA/DR, security, monitoring, upgrades, and migrations.
Produce technical documentation, ERDs, migration plans, and architecture recommendations.
Collaborate with engineering and infrastructure teams on database and application performance improvements.
**Required Qualifications**
5+ years of experience in database administration, data architecture, or related roles.
Strong expertise in relational database design, SQL optimization, and performance tuning.
Proven experience reverse engineering undocumented databases and legacy systems.
Deep understanding of ER modeling, normalization, indexing, and join optimization.
Ability to infer business logic from schemas, data, and application behavior.
Read-level Java proficiency with the ability to understand Spring/Spring Boot, Hibernate/JPA, JDBC, and service-layer database interactions.
Experience with SQL Server, AWS RDS (Managed MS SQL Server), or similar DBMS platforms.
Familiarity with schema versioning, CI/CD, cloud database platforms, and monitoring tools preferred.
Strong analytical, investigative, and documentation skills.
**Desired Attributes**
Comfortable working independently with minimal documentation.
Detail-oriented with a focus on performance and scalability.
Effective communicator capable of translating technical findings into actionable architecture improvements.
Equal opportunity employer: We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.