Federal IT Data Integration Engineer

Aalis Management Consulting, LLC; Washington (District of Columbia); On-site; USD 110,000 - 140,000; Full time

Job summary

Aalis Management Consulting, LLC is seeking a Data Integration Engineer to support a federal agency's IT Financial Management modernization, data architecture, and reporting initiatives. This onsite Washington, DC role requires a Public Trust clearance and a hands-on, collaborative approach with financial analysts and stakeholders.

The ideal candidate will design, develop, and optimize data integrations, ETL pipelines, and APIs, ensuring accurate, secure movement of financial information across

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, Information Technology, or related field.
• Minimum 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 development, data extraction and transformation, data validation, system interfaces, and database concepts.
• Experience supporting enterprise financial, business, or operational systems.
• Experience gathering technical requirements and translating business needs into technical solutions.
• Experience troubleshooting system integration issues and coordinating technical resolutions.
• Experience creating technical documentation and supporting system implementation activities.

Responsibilities

• Support financial systems integration for federal IT Financial Management and Working Capital Fund initiatives.
• Design, develop, test, and maintain data integration solutions.
• 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.
• Develop and maintain APIs, data interfaces, and system connections.
• Support integration with federal financial and business systems, including: Delphi, PRISM, Oracle EPM, Oracle IMPACT, ServiceNow.
• Collaborate with financial analysts and business stakeholders to understand reporting and analytics requirements.
• Develop technical documentation including: system design documents, interface specifications, data dictionaries, process documentation, user guides.
• Support 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.

Skills

Collaboration

Analytical thinking

Technical communication

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, Information Technology, or related field

Tools

SQL development

ETL tools

APIs

Power BI

Power Automate

REST services

Data warehouses

Cloud-based data environments

Job description

Aalis Management Consulting, LLC is seeking a Data Integration Engineer to support a federal agency's IT Financial Management modernization, data architecture, and reporting initiatives. This onsite Washington, DC role requires a Public Trust clearance and a hands-on, collaborative approach with financial analysts and stakeholders.

The ideal candidate will design, develop, and optimize data integrations, ETL pipelines, and APIs, ensuring accurate, secure movement of financial information across