Data Integration Systems Engineer

Responsibilities

• Support ingestion of spreadsheet-based datasets into enterprise databases and applications
• Develop and maintain data transformation workflows that normalize and convert structured data into formats required for system integration and data exchange.
• Validate and troubleshoot data ingestion pipelines to ensure data integrity and operational accuracy
• Support integration of enterprise data into Pega workflows and applications serving as systems of record
• Collaborate with development and architecture teams to improve automation, scalability and maintainability of ingestion workflows
• Aid in development of reporting and downstream data consumption strategies
• Support troubleshooting, analysis and resolution of data-related operational issues
• Work with stakeholders to understand data requirements, mappings and validation criteria
• Participate in modernization and automation initiatives across enterprise services
• Document data flows, interfaces, transformation logic and operational procedures

Requirements

• TS/SCI with Polygraph
• Bachelor’s degree in a technical discipline and fourteen (14) years of related experience as a Systems Engineer, Software Engineer, Data Engineer or equivalent technical role. Nineteen (19) years of experience may be substituted in lieu of a degree
• Experience working with structured data formats including JSON, CSV and Excel-based datasets
• Experience supporting data ingestion, transformation or ETL-style workflows
• Experience writing automation scripts or utilities using Python or similar scripting languages
• Experience troubleshooting data quality and validation issues
• Familiarity with relational databases and SQL
• Ability to work across technical teams and 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

Qualifications

• Experience supporting Pega applications or enterprise workflow platforms
• Experience building or supporting ETL/data ingestion pipelines
• Experience with API integrations and data exchange services
• Experience with data validation frameworks or schema validation
• Familiarity with enterprise reporting ecosystems and downstream analytics integrations
• Experience with automation technologies including RPA or scripting frameworks
• Understanding of enterprise data governance and system-of-record concepts
• Ability to clearly communicate ambiguous or highly complex concepts to all audiences
• Ability to understand the big picture and align day-to-day technical activities to enterprise mission outcomes

Pay

The estimated salary range for this position is between $200,000-$240,000 (annualized USD). This range reflects the typical pay for the role and is one part of the company's comprehensive compensation package. Actual salaries are influenced by several factors, such as location, the individual’s education, skills, experience, and competencies, as well as contract affordability and organizational needs.