Data Integration Engineer

Castello Systems, Inc.; Corridor North (MD); On-site; USD 90,000 - 140,000; Full time

Job summary

Castello Systems, Inc. is seeking a data engineer to support enterprise data modernization and integration across critical workflows.

The role focuses on ingesting, transforming, validating and managing operational data spanning acquisition, finance, HR, logistics, training, security and program management systems. The ideal candidate will combine database engineering, data integration and automation experience, with the ability to implement structured ingestion workflows, JSON-based

Qualifications

• Experience with data ingestion workflows and JSON representations.
• Ability to validate, troubleshoot and optimize data ingestion processes.
• Experience collaborating with engineers and stakeholders on data mappings and integration requirements.

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 into Pega workflows.
• 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

Database engineering

Data integration

Automation

JSON transformations

Pega systems

Tools

Pega

Job description

This role will support enterprise data modernization and integration efforts focused on ingesting, transforming, validating and managing operational data supporting critical business and mission workflows across acquisition, finance, HR, logistics, training, security and program management systems. The ideal candidate will possess a blend of database engineering, data integration and automation experience with the ability to support structured data ingestion workflows, JSON-based transformations, validation processes and enterprise application integrations including Pega-based systems serving as systems of record. This role requires a proactive and technically confident engineer who is comfortable operating in fast-paced and occasionally ambiguous environments. Successful candidates demonstrate strong ownership, initiative and sound technical judgment while working within established architectural, security and operational frameworks. The ideal candidate is capable of independently driving tasks forward, identifying gaps or risks, proposing solutions and collaborating across technical teams without requiring continuous direction or oversight.

Responsibilities Include:

• 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