Data Integration Engineer (Federal Agency - Contingent Upon Award)

Job Description

Job Description

Aalis Management Consulting is an 8(a) certified Service-Disabled Veteran-Owned Small Business (SDVOSB) and Economically Disadvantaged Woman-Owned Small Business (EDWOSB) driven by the same principles that guide our armed forces. Founded by a US Army veteran, we take pride in our core values: excellence in reputation, commitment, candor, teamwork, and dependability. Our team delivers stakeholder-focused support in the areas of Acquisition & Procurement Support, (IT) Financial Management, Program Management, and Logistics & Supply Chain Support. Visit us at  Proposal: (Contingent Upon Award)Title: Data Integration Engineer Client: Federal AgencyLocation: Washington, D.C. - OnsiteClearance: Public TrustSecurity Clearance Statement: This position requires a government security clearance; the applicant must be a U.S. Citizen for consideration.Number of Position(s): 1Work Schedule: 8 am – 5 pmWork Day: Monday – Friday Aalis Management Consulting is seeking a Data Integration Engineer to support a federal agency's IT Financial Management modernization, financial systems integration, data architecture, and reporting initiatives.The Data & Systems Integration Engineer will support the design, development, integration, and optimization of enterprise financial systems and data environments. This role will focus on connecting financial applications, improving data workflows, developing integration solutions, and ensuring accurate, reliable, and secure movement of financial information across systems.The ideal candidate will have experience supporting federal financial systems integration, data engineering, ETL processes, APIs, SQL development, workflow automation, and enterprise reporting solutions. The candidate should have experience working with financial management systems and translating business requirements into technical solutions.This position requires a hands-on technical professional who can work collaboratively with financial analysts, program managers, system owners, and government stakeholders to implement practical solutions that improve financial visibility, reporting accuracy, and operational efficiency.Key ResponsibilitiesSupport financial systems integration efforts for federal IT Financial Management and Working Capital Fund initiatives.Design, develop, test, and maintain data integration solutions supporting financial management operations.Develop and manage data pipelines, interfaces, and workflows connecting enterprise systems.Analyze system requirements and translate business needs into technical solutions.Support integration between financial, operational, and reporting platforms.Develop ETL processes to extract, transform, and load financial data from multiple sources.Perform data mapping, validation, cleansing, and reconciliation activities.Develop and maintain APIs, data interfaces, and system connections.Support integration with federal financial and business systems, including:DelphiPRISMOracle EPMOracle IMPACTServiceNowCollaborate with financial analysts and business stakeholders to understand reporting and analytics requirements.Develop technical documentation including:System design documentsInterface specificationsData dictionariesProcess documentationUser guidesSupport troubleshooting, root cause analysis, and resolution of data and integration issues.Implement data quality controls, validation processes, and audit trails.Support automation of manual financial processes through technology solutions.Assist with dashboard development and reporting integrations using Power BI and other analytics platforms.Participate in Agile development activities, including sprint planning, testing, demonstrations, and documentation.Ensure solutions align with federal cybersecurity, data governance, and compliance requirements.Required QualificationsBachelor 's degree in Computer Science, Information Systems, Engineering, Data Analytics, Information Technology, or related field.Minimum of 5 years of experience supporting data engineering, systems integration, or enterprise application development.Experience designing, developing, and maintaining data integrations or interfaces.Experience with:SQL developmentData extraction and transformationData validationSystem interfacesDatabase conceptsExperience supporting enterprise financial, business, or operational systems.Experience gathering technical requirements and translating business needs into technical solutions.Experience in troubleshooting system integration issues and coordinating technical resolutions.Experience creating technical documentation and supporting system implementation activities.Preferred QualificationsFederal government or federal contractor experience.Experience supporting federal financial management systems.Experience integrating financial systems with reporting and analytics platforms.Experience supporting Working Capital Fund or IT Financial Management environments.Experience with:DelphiPRISMOracle EPMOracle IMPACTServiceNowExperience with:APIsREST servicesETL toolsData warehousesCloud-based data environmentsExperience developing financial reporting solutions using:Power BISQLPower AutomateExperience supporting audit-ready systems with data lineage, controls, and documentation.Experience with Agile development methodologies. Aalis Management Consulting is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.