Senior Data Integration Engineer for Enterprise ETL & JSON

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. 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