Senior Systems Engineer: Data & Legacy Migration (TS/SCI)

J&T Business Consulting; Columbia (MD); 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) Retirement Plan with Company 
匹

Tuition Reimbursement

Job summary

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

The role requires an active TS/SCI with polygraph and involves reverse engineering approximately 40 legacy databases into a universal data model, designing unified database schemas, and migrating data to a modernized platform.

Qualifications

• Active TS/SCI with Polygraph clearance.
• Bachelor’s degree in Computer Science, Systems Engineering, or related field plus 20+ years of relevant experience, OR 25 years of relevant experience without a degree.
• Proven expertise in database design, data modeling, and schema normalization.
• Extensive hands-on SQL experience across Oracle and PostgreSQL.
• Experience reverse engineering complex software systems across front-end and back-end data layers.
• Proven track record in data analysis, data cleansing, normalization, and data security governance.

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 disparate databases.
• Write and optimize complex SQL queries in Oracle and PostgreSQL.
• Perform data analysis, normalization, cleansing, and validation to ensure data integrity during migration.
• Apply data security best practices throughout modeling, extraction, and migration phases.
• Support data visualization, presentation services, and prototyping for analytic tools.

Skills

Database design

Data modeling

Reverse engineering

SQL & RDBMS

Data processing

Education

Bachelor’s degree in Computer Science or Systems Engineering

25 years of relevant experience without a degree

Tools

Oracle

PostgreSQL

Job description

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

The role requires an active TS/SCI with polygraph and involves reverse engineering approximately 40 legacy databases into a universal data model, designing unified database schemas, and migrating data to a modernized platform.