Data Architect

Artech LLC

Jersey City, NJ

Apply

JOB DETAILS

SALARY

$51–$56 Per Hour

SKILLS

Apache Kafka, Application Programming Interface (API), Architectural Design, Artificial Intelligence (AI), Artificial Intelligence (AI) Agents, Banking Services, Billing, Centers for Disease Control and Prevention (CDC), Cobol Programming Language, Contract Requirements, Data Collection, Data Management, Data Modeling, Data Processing, Data Structures, DataArchitect Data Modeling Tool, Database Extract Transform and Load (ETL), Documentation Models, Entity Relationship Diagram (ERD), Field Mapping, GitHub, IBM DB2, IBM IMS Database, IBM z-OS Operating System, Insurance, Large-Scale Systems, Mainframe Computer, Messaging Middleware, Model Validation, MongoDB, Policy Development, Python Programming/Scripting Language, REST (Representational State Transfer), Reverse Engineering, SQL (Structured Query Language), Scripting (Scripting Languages), Software Engineering, System Integration (SI), Transaction Processing/Management

LOCATION

Jersey City, NJ

POSTED

30+ days ago

Request ID: 68774-1
Title: Data Architect
Locations: Jersey City NJ
Duration: 6 Months
Pay Range: $51 - $56/Hour on W2 (All inclusive) - Applicants must be willing to work on W2

Job Description:
We are seeking a Senior Data & Integration Architect to lead data model design and downstream integration strategy for a large-scale policy administration system modernization. You will reverse engineer legacy mainframe data structures, forward engineer them into modern SQL/MongoDB document schemas, and define how data flows to downstream consumers. You will leverage purpose-built AI agents to accelerate reverse engineering, model generation, and documentation — bringing human judgment to validate and refine AI-produced outputs.

Key Responsibilities
- Design and maintain technology-agnostic Logical Data Models (entities, relationships, cardinality, PK/FK)
- Transform LDMs into modern physical schemas applying aggregate-oriented and DDD patterns
- Reverse engineer IMS hierarchical segments and DB2 tables — extract business entities from physical storage structures without original design documentation
- Interpret COBOL copybooks as data structure definitions and map legacy field types to modern equivalents
- Define embedding vs. referencing strategies, versioning patterns, and collection boundaries for target database platforms
- Design downstream integration patterns — REST APIs, event streaming (Kafka/MQ), Change Data Capture (CDC), and data distribution to consuming systems
- Direct and validate AI agent pipelines for automated reverse engineering, ERD generation, data dictionary synthesis, and schema artifact production
- Produce data dictionaries, ERD diagrams, ETL field mapping specifications, and integration contracts
- Collaborate with SMEs to validate models and integration flows against undocumented business logic

Required Qualifications
- 8+ years experience in data architecture and system integration within OLTP / transactional domains (insurance, banking, billing, or similar)
- Hands-on experience with IBM IMS, DB2 for z/OS, and COBOL copybooks — able to read a segment hierarchy or copybook independently
- 5+ years designing physical data models for modern relational or document-oriented databases
- Strong grasp of logical modeling: ERD notation, composition vs. reference, cardinality, key design
- Proven experience designing integration architectures: REST APIs, event streaming (Kafka, MQ), CDC pipelines, and message-based data distribution
- Experience with ELT processing, including designing and implementing ELT workflows, data transformation, data cleansing, and data validation
- Experience with real-time data processing, including designing and implementing real-time data processing pipeline with event-driven architectures
- Comfort working in an AI-augmented workflow — directing LLM-based agents, reviewing AI-generated artifacts, and applying domain expertise to close gaps AI cannot resolve
- Scripting proficiency (Python or equivalent) for schema validation and artifact generation
- Ability to abstract legacy physical data structures into business-oriented target models — separating IMS/DB2 storage implementation details from true business keys and domain entities
Preferred
- Insurance domain knowledge (policy lifecycle, coverages, LOBs, premium rating)
- Domain-Driven Design (DDD) - aggregates, bounded contexts, event-driven design
- Experience synthesizing a unified model from multiple heterogeneous sources (IMS + DB2 + application logic)
- Prior experience working with AI coding assistants (Claude, GitHub Copilot, or similar) in a software engineering or data architecture context

Skills: Data Architecture and Modeling
Experience Required: 10 & Above

Company Benefits & Culture

Inclusive and diverse work environment
Opportunities for professional growth and development
Comprehensive health and wellness benefits

Appreciate your quick response and please feel free to reach me out for any query you may have.

Thanks

About the Company

Artech LLC

Resume Resources

Free Resume Templates Free Resume Builder

Data Architect

Artech LLC

Jersey City, NJ

About the Company

Artech LLC

Resume Resources

Similar Job Searches