Data Integration Systems Engineer

Freedom Technology Solutions Group

$100K — $130K *
Aerospace & Defense
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • TS/SCI with Polygraph clearance required
  • Bachelor's degree in technical discipline with 14 years related experience, or 19 years experience in lieu of degree
  • Experience with structured data formats such as JSON, CSV, and Excel
  • Skill in supporting data ingestion, transformation or ETL workflows
  • Proficiency in writing automation scripts with Python or similar languages
  • Knowledge of relational databases and familiarity with SQL
  • Ability to communicate effectively with technical and non-technical stakeholders

Responsibilities

  • Support ingestion of spreadsheet-based datasets into enterprise databases
  • Develop data transformation workflows for system integration and data exchange
  • Validate and troubleshoot data ingestion pipelines for integrity and accuracy
  • Integrate enterprise data into Pega workflows serving as systems of record
  • Collaborate with teams to enhance automation and scalability of workflows
  • Assist in developing reporting and data consumption strategies
  • Document data flows and operational procedures

Benefits

  • Flexible work environment
  • Team-oriented culture with friendly professionals
  • Work with innovative, cutting-edge technologies
  • Opportunities for career growth and advancement
  • Generous paid time off including site closure days
  • Fully paid medical insurance and matching 401k
  • Paid training and tuition reimbursement
  • Company-sponsored events and an annual logo wear allowance
Full Job Description
We are seeking a Data Integration Systems Engineer for one of our PRIME CONTRACTS supporting mission-critical enterprise applications and services across the Government Corporate Management Solutions (CMS) portfolio. Join a team that powers the business enterprise behind the mission. Freedom supports the sustainment, modernization, and transformation of more than 100 enterprise business systems that enable tens of thousands of government personnel, industry partners, and prospective employees worldwide. Our teams develop, modernize, secure, and operate the applications and services that support workforce management, training, financial operations, acquisitions, security processing, and executive decision-making across multiple secure environments.

As part of this program, you will work alongside experts in software engineering, cloud computing, DevSecOps, systems engineering, and enterprise platforms to modernize legacy systems, automate business processes, and deliver innovative solutions that improve efficiency, reduce costs, and enhance the user experience. The work you perform will help ensure the organization has the technology, information, and capabilities needed to support its workforce and accomplish its mission.

This role will support enterprise data modernization initiatives focused on ingesting, transforming, validating and integrating operational data into enterprise systems supporting critical national security applications and systems. The ideal candidate will help design and implement automated workflows for ingesting structured spreadsheet data into enterprise databases, converting source data into JSON representations, validating data integrity and supporting integration into Pega-based workflows and reporting ecosystems. This position requires a technically versatile engineer capable of working across data pipelines, enterprise systems, reporting integrations and automation workflows while collaborating closely with developers, architects, system administrators and mission stakeholders. 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-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
  • Assist with 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

Required Qualifications

  • 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

Technology Stack
  • Pega
  • Python
  • SQL Server
  • PostgreSQL
  • JSON
  • REST APIs
  • Atlassian Tool Suite
  • GitLab
  • Reporting and Analytics Platforms
  • Linux / Windows environments

Desired 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


What's in It for You?

Flexible work environment

A team mentality - work with friendly, like-minded professionals

Work with innovative, cutting edge technologies

Enjoy extremely competitive compensation and benefits

A work-life balance you can count on

Opportunities to grow and advance your career on our dime

The Benefits You Get with Freedom

Amazing benefits including matching 401k, fully paid medical, and more

Generous paid time off - including paid site closure days

Competitive salary offerings

Paid training and tuition reimbursement

Referral bonuses

Fully paid life and disability

Annual logo wear allowance

Company sponsored events (game nights, holiday party, summer party, happy hours)

Similar Jobs

More Jobs at Freedom Technology Solutions Group

More Aerospace & Defense Jobs

Find similar Data Integration Systems Engineer jobs: