Senior Data Integration Engineer

Optimus Technology, Inc.; Maryland; On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health benefits

Dental & vision coverage

401k company contributions

Life insurance

Job summary

Optimus Technology, Inc., a SDVO small business founded in 2010, seeks an experienced data engineer to support enterprise data modernization and integration across acquisition, finance, HR, logistics, training, security and program management systems.

The role requires hands-on experience with data ingestion workflows, JSON transformations and Pega-based integrations, with a proactive engineer who can operate with minimal direction and collaborate across technical teams.

Qualifications

• Experience with data ingestion workflows and structured data sources
• Ability to define data mappings and validation rules across systems
• Experience supporting JSON-based transformations and enterprise integrations
• Knowledge of Pega workflows as systems of record
• Strong problem solving and collaboration across technical teams

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 ingestion

JSON transformations

ETL

Pega integrations

SQL

Data quality

Automation

Cloud experience

Tools

Enterprise databases

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

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

Optimus Technology is a SDVO (Service-Disabled Veteran-Owned) small business founded in 2010. We are known for our exceptionally talented group of Engineers and Technical experts with superior knowledge and experience in Cyber Technologies and the latest technology trends. Our dedication in pairing the right Optimus Technologist with the right customer solution is at the core of our Partnership commitment and critical to the performance and satisfaction of our employees, the pinnacle of the Optimus culture.

Why us?

We strive to provide the best well-rounded benefits package available.

• Premium health, dental, and vision package
• Company funded HRA
• 401k company contributions
• Employer paid group term life insurance policy
• Tuition assistance and career development
• Short-term and long-term disability
• Paid time off
• Company outings, giveaways & more

Optimus practices a policy of non-discrimination and is fully committed to the principles of equality in employment and opportunity for all employees. Employment decisions are made without regard to age, gender, race, religion, marital status, national origin, sexual orientation, or any other non-merit based factor.