Federal Data Integration Engineer – IT Financial Management

Aalis Management Consulting

Washington (District of Columbia)

On-site

USD 110,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Aalis Management Consulting is seeking a Data Integration Engineer to support a federal agency's IT Financial Management modernization, data architecture, and reporting initiatives. You will design, develop, and optimize enterprise financial data flows and integration points across multiple systems.

The ideal candidate will have 5+ years in data engineering and systems integration, with strong SQL, ETL, APIs, and dashboard experience.

Qualifications

Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, IT, 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 development, data extraction and transformation, data validation, system interfaces, and database concepts.
Experience supporting enterprise financial, business, or operational systems.

Responsibilities

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