Senior Systems Engineer: Data Modernization for Analytics TS/SCI

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 and disability insurance

PTO and holidays

401(k) with company match

Tuition reimbursement

Job summary

J&T Business Consulting in Columbia, MD seeks a senior Systems Engineer (TS/SCI with Full Scope Polygraph) to drive a high-impact data migration and visualization effort. You will reverse engineer legacy data, design a universal data model, and lead SQL work across Oracle and PostgreSQL.

Role focuses on data analytics, security governance, and migration of ~40 databases to a modern platform, partnering with a small, skilled team.

Qualifications

• Active TS/SCI clearance with Polygraph.
• Bachelor’s degree in CS or Systems Engineering with 20+ years of experience, OR 25 years of relevant experience without a degree.
• Proven expertise in database design, data modeling, and schema normalization.
• Extensive SQL experience across Oracle and PostgreSQL.

Responsibilities

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

Skills

Data modeling

SQL & RDBMS

Reverse engineering

Data analysis

Data security

Database design

Education

Bachelor’s degree in CS/SE

25 years experience without degree

Tools

Oracle

PostgreSQL

Job description

J&T Business Consulting in Columbia, MD seeks a senior Systems Engineer (TS/SCI with Full Scope Polygraph) to drive a high-impact data migration and visualization effort. You will reverse engineer legacy data, design a universal data model, and lead SQL work across Oracle and PostgreSQL.

Role focuses on data analytics, security governance, and migration of ~40 databases to a modern platform, partnering with a small, skilled team.