Data Integration Engineer

LCAT: Data

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

,

Required Skills

TS/SCI with Polygraph

Bachelor’s degree in a technical discipline and five (5) years of experience as a Database Engineer or related technical role. Ten (10) years of experience may be substituted in lieu of a degree.

Experience working with relational databases and SQL-based technologies

Experience supporting data ingestion, transformation or ETL-style workflows Experience working with structured data formats including JSON, CSV and Excel-based datasets

Experience writing scripts or automation utilities using Python, PowerShell or similar scripting 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 of M-F 10am-2pm. Exceptions will be considered on a case by-case basis

,

Desired Skills

Demonstrated ability to operate independently and take ownership of technical deliverables and operational outcomes

Comfortable working in dynamic environments with evolving priorities, incomplete requirements and cross-team dependencies

Proven ability to identify technical gaps, propose solutions and proactively drive work forward with minimal oversight

Strong troubleshooting and analytical skills with the ability to navigate complex enterprise data environments

Ability to balance independent execution with appropriate stakeholder coordination and escalation

Strong organizational and communication skills with the ability to work effectively across engineering, operations and customer teams

,

About Castello Systems, Inc.

At Castello Systems, we are focused on delivering solutions. One way we do this is through the integration of COTS products into our customer's enterprise. We are successful because we are experts in the tools we integrate and are experts in the intricacies of our customer’s enterprise. Many of our peers fail because they are not able to bring these two components together. When Castello Systems is brought in, our folks have access to all the resources across the company and through our partnerships with COTS vendors. When you have one of us, you have all of us. Castello Systems prefers completion based contracts. This gives us the flexibility to bring to bear the right level of expertise and when needed to deliver. Castello Systems specialize in architecting, implementing, and executing Enterprise Management through the use of industry leading technologies such as OpenText Software, Splunk, and Elastic Stack.