Systems Engineer (TS/SCI Clearance with Full Scope Polygraph Required)

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

Benefits offered by this job

Comprehensive Health, Dental, and Vis​

Basic Life and Disability Insurance

Paid Time Off (PTO) and Paid Holidays

401(k) Retirement Plan with Company =

Tuition Reimbursement for ongoing教育

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 data migration for analytic tool prototyping, development, and production.

The role requires an active TS/SCI with Polygraph clearance and involves reverse engineering approximately 40 legacy databases into a unified data model, enabling efficient analysis, discovery, and search capabilities during migration to a modernized platform.

Qualifications

• Active TS/SCI with Polygraph clearance.
• Bachelor’s degree in Computer Science, Systems Engineering, or related field plus at least 20 years of relevant professional experience, OR 25 years of relevant professional systems engineering/data architecture experience without a degree.
• Proven expertise in database design, data modeling, and schema normalization.
• Extensive hands-on experience with SQL across relational database systems (Oracle, PostgreSQL).
• Demonstrated experience reverse engineering complex software systems across front-end and back-end.
• Proven track record in data analysis, data 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 in Oracle and PostgreSQL.
• Perform data analysis, normalization, cleansing, and validation for migration.
• Implement robust data security practices across modeling, extraction, and migration phases.
• Support data visualization, prototyping for downstream analytic tools.

Skills

SQL

Data modeling

Database design

System engineering

Reverse engineering

Data analysis

Security governance

Education

Bachelor’s degree in Computer Science or Systems Engineering

25 years experience without degree

Tools

Oracle

PostgreSQL

Job description

Systems Engineer (TS/SCI Clearance with Full Scope Polygraph Required)

Columbia, United States

Clearance Requirement: Active TS/SCI with Polygraph

Salary Range: $175,000 – $210,000 / year (dependent on experience, education, and skill set)

About the Role

Seeking a senior Systems Engineer 3 to support a mission-critical initiative delivering advanced visualization and presentation services for analytic tool prototyping, development, and production in Columbia, MD.

In this role, you will collaborate within a small, high-impact team dedicated to reverse engineering approximately 40 legacy databases into a unified, universal data model. You will play a central role in enabling efficient data analysis, discovery, and search capabilities, driving the end-to-end migration of legacy business data to a modernized platform.

Key Responsibilities

• Reverse engineer legacy systems across both front-end and back-end architectures to map existing data structures and workflows.
• Design, architect, and develop unified database models to consolidate ~40 disparate databases into a single universal system.
• Author and optimize complex SQL queries within relational database environments (e.g., Oracle, PostgreSQL).
• Perform comprehensive data analysis, normalization, cleansing, and validation to ensure data integrity during migration.
• Implement robust data security best practices throughout system modeling, extraction, and migration phases.
• Support data visualization, presentation services, and prototyping for downstream analytic tools.

Required Qualifications & Experience

• Security Clearance: Active TS/SCI with Polygraph.
• Experience & Education: Bachelor’s degree in Computer Science, Systems Engineering, or a 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.
• Database & Modeling: Proven expertise in database design, data modeling, and schema normalization.
• SQL & RDBMS: Extensive hands-on experience utilizing SQL across relational database management systems (e.g., Oracle, PostgreSQL).
• Reverse Engineering: Demonstrated experience reverse engineering complex software systems across both front-end interfaces and back-end data layers.
• Data Processing: Proven track record in data analysis, data cleansing, normalization, and data security governance.

Desired Qualifications

• Advanced experience with Oracle database architectures.
• Prior working knowledge of BM&A systems.

Benefits & Compensation

• Comprehensive Health, Dental, and Vision Insurance
• Basic Life and Disability Insurance
• Paid Time Off (PTO) and Paid Holidays
• 401(k) Retirement Plan with Company Match
• Tuition Reimbursement for ongoing education and professional development

An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected under federal, state, or local law.