Senior Systems Engineer — TS/SCI with Poly, Data Migration & Visualization

J&T Business Consulting; New York (NY); On-site; USD 175,000 - 210,000; Full time

Benefits offered by this job

Health, Dental, Vision Insurance

Life Insurance

Paid Time Off

401(k) Retirement Plan

Tuition Reimbursement

Job summary

J&T Business Consulting in Columbia, MD is seeking a senior Systems Engineer 3 to support a mission-critical initiative delivering advanced visualization and analytics tools for prototyping, development, and production.

This role requires an active TS/SCI with Polygraph clearance and entails reverse engineering ~40 legacy databases into a single universal data model, plus designing schemas, optimizing SQL (Oracle/PostgreSQL), and ensuring data security during migration.

Qualifications

• Active TS/SCI with Polygraph clearance
• Bachelor’s degree in Computer Science, Systems Engineering, or related discipline plus at least 20 years of relevant professional experience, OR 25 years of relevant professional systems engineering/data architecture experience without a degree
• Proof of database design, data modeling, and schema normalization
• Extensive SQL experience across Oracle and PostgreSQL
• Experience reverse engineering complex software systems across front-end and back-end layers
• Experience in data analysis, cleansing, normalization, and data security governance

Responsibilities

• Reverse engineer legacy systems to map data structures and workflows
• Design, architect, and develop unified database models to consolidate ~40 databases
• Author and optimize complex SQL queries within Oracle and PostgreSQL
• Perform data analysis, normalization, cleansing, and validation during migration
• Implement robust data security practices throughout modeling, extraction, and migration
• Support data visualization, presentation services, and prototyping for analytic tools

Skills

Database design

Data modeling

SQL

Reverse engineering

Data analysis

Data cleansing

Data security governance

Security clearance

Education

Bachelor’s degree in Computer Science or related field

25 years of experience without a degree

Tools

Oracle

PostgreSQL

Job description

J&T Business Consulting in Columbia, MD is seeking a senior Systems Engineer 3 to support a mission-critical initiative delivering advanced visualization and analytics tools for prototyping, development, and production.

This role requires an active TS/SCI with Polygraph clearance and entails reverse engineering ~40 legacy databases into a single universal data model, plus designing schemas, optimizing SQL (Oracle/PostgreSQL), and ensuring data security during migration.