Job ID: JOB_ID_8389
Job Summary:
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. The role involves reverse engineering legacy mainframe data structures and transforming them into modern SQL/MongoDB schemas. You will also leverage AI-driven tools to accelerate data modeling, documentation, and integration workflows while applying expert validation.
Key Responsibilities:
- Design and maintain technology-agnostic Logical Data Models (LDMs) (entities, relationships, cardinality, PK/FK).
- Transform LDMs into modern physical schemas using DDD and aggregate-oriented design patterns.
- Reverse engineer IMS hierarchical data and DB2 tables to extract business entities.
- Interpret COBOL copybooks and map legacy data structures to modern formats.
- Define embedding vs. referencing strategies, versioning, and collection boundaries.
- Design integration architectures including: REST APIs, Event streaming (Kafka, MQ), Change Data Capture (CDC).
- Lead and validate AI-driven pipelines for: Reverse engineering, ERD generation, Data dictionary creation, Schema artifact generation.
- Develop data artifacts such as ERDs, data dictionaries, ETL mappings, and integration contracts.
- Collaborate with SMEs to validate models against undocumented business logic.
Required Qualifications:
- 8+ years of experience in Data Architecture & System Integration (OLTP environments).
- Strong experience with: IBM IMS, DB2 for z/OS, COBOL copybooks.
- 5+ years designing modern physical data models (Relational/NoSQL).
- Expertise in logical data modeling (ERD, cardinality, key design).
- Hands-on experience in: REST APIs, Event streaming (Kafka, MQ), CDC pipelines.
- Experience with ELT workflows, data transformation, and validation.
- Experience in real-time data processing & event-driven architectures.
- Familiarity with AI-assisted development workflows (LLMs, AI agents).
- Scripting knowledge (Python or equivalent).
- Ability to translate legacy data structures into business-oriented domain models.
Preferred Qualifications:
- Insurance domain expertise (policy lifecycle, coverages, rating).
- Strong knowledge of Domain-Driven Design (DDD).
- Experience integrating heterogeneous data sources (IMS + DB2 + application logic).
- Experience with AI coding assistants (e.g., GitHub Copilot, Claude).
Skills:
- Data Architecture & Modeling
- Data Integration & ETL/ELT
- Event-Driven Architecture
- Legacy Modernization (Mainframe to Modern Systems)
- AI-Augmented Data Engineering
Special Requirements
Work Mode: Hybrid (34 days/week in office)
Compensation & Location
Salary: $120,000 – $180,000 per year (Estimated)
Location: White House Station, NJ
Recruiter / Company – Contact Information
Email: oj.b@siriinfoinc.com
Recruiter Notice:
To remove this job posting, please send an email from
oj.b@siriinfoinc.com with the subject:
DELETE_JOB_ID_8389