Data Integration Systems Engineer

Freedom Technology Solutions Group•Annapolis Junction, MD

About The Position

DRAGONCONFETTI provides sustainment, modernization, transformation and decommissioning for enterprise business systems, services and software. DRAGONCONFETTI also provides business process automation for the Business Management & Acquisition organization through Python, Robotic Process Automation (RPA) and AI/ML. Freedom provides program management for 36 distinct Task Orders throughout execution of the program supporting approximately 200 FTEs with TS/SCI with Polygraph security clearances. Freedom’s responsibilities include full lifecycle support for more than 100 applications on multiple security fabrics utilizing FOSS, COTS and GOTS solutions that support tens of thousands of users across the globe. Our team provides expertise in program management, software engineering, DevSecOps, systems engineering, system administration, database engineering and COTS subject matter expertise for the enterprise. 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.

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

Nice To Haves

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

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

Benefits

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