Senior Data Integration Engineer

Reflexive Concepts; Maryland; On-site; USD 120,000 - 180,000; Full time

Job summary

Reflexive Concepts is seeking a skilled Senior Data Integration Engineer to join our team. The role supports enterprise data modernization and ingestion, transformation, validation and management of operational data across acquisition, finance, HR, logistics and program management systems, including Pega-based workflows.

The ideal candidate combines database engineering, data integration and automation expertise, capable of shaping JSON-based transformations and enterprise data movements within

Qualifications

• Bachelor's degree in a technical discipline with 5+ years in DB/data integration.
• Experience with relational databases and SQL-based technologies.
• Experience with data ingestion, transformation or ETL workflows.
• Experience with JSON, CSV, and Excel data formats.
• Proficient scripting in Python or PowerShell.
• Strong communication with technical and non-technical stakeholders.
• Availability to work 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

Data integration

ETL workflows

JSON data formats

SQL databases

Python

PowerShell

Data validation

Communication

Stakeholder coordination

Independent work

Education

Bachelor's degree in a technical discipline

Ten years of experience substitute

Tools

SQL

Python

PowerShell

ETL tooling

Job description

Reflexive Concepts is seeking a skilled Senior Data Integration Engineer to join our team! 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.

Qualifications

• 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

Job 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

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