Onsite Federal Data Integration Engineer — ETL & APIs

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

Job summary

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 role focuses on connecting financial applications and ensuring accurate, secure data movement across systems.

The ideal candidate has 5+ years in data engineering and systems integration, experience with ETL, APIs, SQL, and enterprise reporting, and the ability to translate business

Qualifications

• Bachelor's degree in CS/IS/Engineering/Data Analytics or related field.
• Minimum 5 years of experience supporting data engineering, systems integration, or enterprise app development.
• Experience designing, developing, and maintaining data integrations or interfaces.
• Experience with SQL development, data extraction and transformation, data validation, and system interfaces.
• Experience supporting enterprise financial, business, or operational systems.
• Experience gathering technical requirements and translating business needs into technical solutions.

Responsibilities

• Support 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 activities.
• Develop and maintain APIs, data interfaces, and system connections.
• Collaborate with financial analysts and stakeholders on reporting requirements.
• Ensure solutions align with cybersecurity, data governance, and compliance requirements.

Skills

Data engineering

Systems integration

Enterprise app development

SQL development

ETL processes

Data extraction

Data transformation

Data validation

System interfaces

Database concepts

Technical documentation

Requirements gathering

Troubleshooting

Education

Bachelor's degree

Tools

Delphi

PRISM

Oracle EPM

Oracle IMPACT

ServiceNow

Power BI

Power Automate

APIs

ETL tools

Data warehouses

Cloud-based data environments

Job description

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 role focuses on connecting financial applications and ensuring accurate, secure data movement across systems.

The ideal candidate has 5+ years in data engineering and systems integration, experience with ETL, APIs, SQL, and enterprise reporting, and the ability to translate business