Aalis Management ConsultingVerified Source

Data Integration Engineer (Federal) - Washington DC

Onsite · Washington, District of Columbia
Posted August 12, 2026
payroll

Overview

Own the design, development, and optimization of enterprise financial data integration for a federal agency's IT Financial Management modernization. You will connect Delphi, PRISM, Oracle EPM, and IMPACT systems, build ETL pipelines, and ensure accurate, secure movement of financial information. Collaborate with financial analysts and government stakeholders to implement practical solutions that improve financial visibility and reporting accuracy. This role stands apart with its focus on audit-ready data lineage and compliance with federal cybersecurity standards.

What You'll Do10

  • 1Design, develop, and maintain data integration solutions for federal financial systems, including Delphi, PRISM, Oracle EPM, and Oracle IMPACT.
  • 2Build and manage ETL processes to extract, transform, and load financial data from multiple sources into enterprise data environments.
  • 3Develop and maintain APIs, data interfaces, and system connections to support real-time data flow between financial, operational, and reporting platforms.
  • 4Perform data mapping, validation, cleansing, and reconciliation to ensure data accuracy and integrity across systems.
  • 5Automate manual financial processes using Power Automate and other workflow tools to reduce operational overhead.
  • 6Develop interactive dashboards in Power BI to deliver actionable financial insights to stakeholders.
  • 7Implement data quality controls, validation processes, and audit trails to support federal compliance and audit-readiness.
  • 8Troubleshoot and resolve data and integration issues, performing root cause analysis and coordinating technical resolutions with system owners.
  • 9Document system designs, interface specifications, data dictionaries, and user guides to support implementation and maintenance.
  • 10Participate in Agile development activities, including sprint planning, testing, and demonstrations, to deliver iterative improvements.

Requirements10

  • 15+ years of experience in data engineering, systems integration, or enterprise application development.
  • 2Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or related field.
  • 3Proficiency in SQL development for data extraction, transformation, and validation.
  • 4Hands-on experience with ETL tools and data warehousing concepts.
  • 5Experience integrating enterprise financial or business systems, such as Delphi, PRISM, Oracle EPM, or IMPACT.
  • 6Strong skills in developing and consuming REST APIs and managing data interfaces.
  • 7Experience with cloud-based data environments, including AWS or Azure.
  • 8Proven ability to translate business requirements into technical solutions and document them clearly.
  • 9Familiarity with Power BI, Power Automate, and other analytics platforms for reporting integration.
  • 10Experience supporting audit-ready systems with data lineage, controls, and comprehensive documentation.

Salary Insight

Salary not disclosed in listing

Location

Typeonsite
LocationWashington, District of Columbia

Required Skills

SQLETLAPIsREST servicesPower BIPower AutomateAgile developmentOracle EPMOracle IMPACTDelphi PRISMServiceNow
Share:

Similar open positions

Explore active roles that match your skills and interests.

US Federal Solutions

17h agoRemotepayroll

Data Analyst, Federal Solutions & Power BI

Own data integration and analytics for federal projects, connecting disparate datasets across Palantir Foundry, Advana, and Power BI at scale. Collaborate with external database admins and internal teams to sync systems, build KPIs, and deliver dashboards that drive mission-critical decisions. This role blends hands-on data engineering with strategic analysis, offering direct impact on US Federal contracts. With 5+ years of experience, you will shape the data architecture and automate workflows, ensuring reliable insights for government stakeholders.

Competitive salary
Active Secret clearanceBachelor's degreePower BI+9 more

Makpar

5d agoWashington, District of Columbiapayroll

Data Engineer - Cloud Analytics Solutions

Makpar seeks a skilled Data Engineer to lead enterprise-scale analytics initiatives for federal clients. This role involves designing and optimizing cloud-based data pipelines to drive data-driven decision-making. The ideal candidate will collaborate with cross-functional teams to deliver secure and scalable data solutions.

Competitive salary
pythonsqldatabricks+2 more

Guidehouse Digital, LLC

13h agoHouston, Texaspayroll

Senior Data Engineer, ETL & Cloud Analytics

You will own the design, development, and optimization of scalable data pipelines and cloud-based analytics solutions for mission-critical projects. This role centers on Python, SQL, and Spark to build modern data ecosystems. You will join a multidisciplinary team of architects, analysts, and engineers, collaborating on cloud platforms like AWS and Azure. Your work will directly support analytics, reporting, and operational workloads. This position requires 3+ years of hands-on experience and offers the chance to lead technical efforts in a federal consulting environment.

80K–133K
PythonSQLSpark+5 more
Deloitte

Deloitte

13h agoWashington, District of Columbiapayroll

Power Platform Developer, Analytics & BI

You will own the development and enhancement of Power Platform and Power BI solutions for a federal client, serving thousands of enterprise users. You will build interactive dashboards, perform DAX and Power Query modeling, and integrate data sources to support key decisions. You will join Deloitte's AI & Engineering team, collaborating with analysts and engineers to modernize reporting across multiple platforms. This role stands out for its direct impact on national security missions and the opportunity to shape analytics for a major government program.

113K–188K
Microsoft Power AppsPower BIData Visualization+7 more

MRINetwork Jobs

17h agoNashville, Tennesseepayroll

Database Integration & BI Project Manager

You will design and own database integrations across our internal software ecosystem, ensuring secure, scalable data flow for a retail supplier serving commercial, industrial, and residential markets. Build Power BI solutions that drive reporting and analytics, while leading cross-functional projects from planning to deployment. Collaborate with software developers, IT, and business stakeholders to improve data architecture and deliver actionable insights. This role combines hands-on SQL development, ETL/ELT processes, and API integrations with project management, offering direct impact on operational efficiency and decision-making.

Competitive salary
Microsoft SQL ServerMySQLPostgreSQL+9 more
TechniPros, LLC

TechniPros, LLC

13h agoWashington, District of Columbiacontract

Data Engineer, ETL & Big Data

You will own end-to-end data pipeline development and modern data infrastructure across client sites in DC, MD, PA, DE, and VA. You will design and maintain scalable ETL processes using Python, SQL, and Spark to support analytics and machine learning. You will work on a cross-functional team of data engineers and analysts, delivering data solutions at enterprise scale. This contract role offers hands-on work with modern cloud platforms like AWS and containerization with Docker.

Competitive salary
pythonsqlspark+2 more