Senior Data Integration Engineer — On-Site (TS/SCI)

CTC; Maryland; On-site; USD 160,000 - 180,000; Full time

Benefits offered by this job

401(k) matching

Dental Insurance

Health insurance

Life insurance

Paid time off

Professional development assistance

Profit Sharing Retirement Program

Vision insurance

Job summary

Computer Technologies Consultants, Inc. (CTC) is seeking a Senior Data Integration Engineer to support the Intelligence Community at the government site in Annapolis Junction, MD.

This role focuses on data modernization, ingestion, transformation and integration across enterprise systems, including Pega. Ideal candidates have a strong background in database engineering, ETL/JSON workflows, scripting (Python/PowerShell) and the ability to collaborate with engineers and stakeholders while

Qualifications

• Experience with relational databases and SQL-based technologies.
• Experience supporting data ingestion, transformation or ETL-style workflows.
• Experience with structured data formats including JSON, CSV and Excel.
• Experience writing scripts or automation utilities using Python, PowerShell or similar languages.
• Experience troubleshooting data validation and operational data quality issues.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Must be able to work during core hours M-F 10am-2pm.

Responsibilities

• Support ingestion of spreadsheet and structured data sources into enterprise databases and applications.
• Develop and maintain data transformation workflows including conversion of source data into JSON representations.
• Validate, troubleshoot and optimize data ingestion and synchronization processes.
• Support enterprise database operations and ensure integrity, availability and consistency of operational data; assist with integration of enterprise data into Pega workflows and applications.
• Collaborate with software engineers, systems engineers and stakeholders to define data mappings, validation rules and integration requirements.
• Support development and maintenance of reporting and downstream data consumption capabilities.
• Monitor database performance and assist with troubleshooting operational issues.
• Participate in automation and modernization initiatives across enterprise services.
• Document database structures, data flows, ingestion processes and operational procedures.

Skills

Relational DBs/SQL

ETL/Data Ingestion

JSON/CSV/Excel

Python/PowerShell scripting

Data quality troubleshooting

Stakeholder communication

Work hours availability

Education

Bachelor's degree required; 5+ years experience

Job description

Computer Technologies Consultants, Inc. (CTC) is seeking a Senior Data Integration Engineer to support the Intelligence Community at the government site in Annapolis Junction, MD.

This role focuses on data modernization, ingestion, transformation and integration across enterprise systems, including Pega. Ideal candidates have a strong background in database engineering, ETL/JSON workflows, scripting (Python/PowerShell) and the ability to collaborate with engineers and stakeholders while