Founded in 1969, ICF is a global advisory and technology services company headquartered in Reston, Virginia. It delivers data-driven solutions across energy, en
Data Engineer
Location
District Of Columbia
Posted
6 days ago
Salary
$81.5K - $138.5K / year
Seniority
Senior
Job Description
Data Engineer
ICF
Title: Data Engineer (Clearance Required) Location: Reston VA United States Full-time Job Description: The Work: We are seeking a Data Engineer to support federal government programs by designing, building, and maintaining scalable, secure, and compliant data solutions. This role partners closely with data scientists, analysts, developers, and government stakeholders to enable data-driven decision-making across mission‑critical systems. Job Location: This is a fully remote role which may require occasional travel to the DC Metro area as needed for onsite client meetings. Preference to candidates located within the Washington, DC Metro area. If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses, and also prohibits personal VPN connections. What You Will Do: - Design, build, and maintain data pipelines and ETL/ELT processes supporting large-scale federal data systems - Develop and optimize cloud-based data architectures in AWS or Azure environments (e.g., S3, Redshift, RDS, Databricks, Synapse) - Integrate structured and unstructured data from multiple government and third‑party sources - Ensure data quality, integrity, availability, and performance across systems - Support ATO, RMF, and federal security requirements, including documentation and audit support - Collaborate with DevOps teams on CI/CD, infrastructure as code (IaC), and deployment automation - Translate business and mission requirements into scalable technical solutions - Produce and maintain technical documentation for data flows, pipelines, and architectures - Participate in Agile ceremonies and work closely with cross‑functional teams What You Will Bring With You: - Active Top Secret clearance, with SCI eligibility - 2+ years of experience designing and supporting enterprise data solutions in federal or regulated environments What We Would Like You To Bring With You: - Bachelor's Degree in related field - Prior experience supporting federal or DoD programs, preferably DCSA - Strong experience with relational databases (e.g., Oracle, PostgreSQL, SQL Server, Azure SQL, or similar) - Knowledge of data modeling techniques, ETL/ELT processes, and data integration patterns - Familiarity with cloud platforms (Azure, AWS, or GCP) and modern data services - Experience supporting security, governance, and compliance requirements - Experience with data warehousing, reporting, and analytics platforms - Familiarity with DevSecOps, CI/CD pipelines, and infrastructure‑as‑code Working at ICF ICF is a global advisory and technology services provider, but we're not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process. However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed. Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $81,499.00 - $138,549.00 Nationwide Remote Office (US99)
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Design & Build: Architect and maintain the company’s core data infrastructure, including pipelines, warehousing, ingestion, transformation, and orchestration systems. • Own the Data Platform: Take end-to-end responsibility for the scalability, reliability, and security of the data platform ensuring high-quality data is accessible across the organization. • Set the Standard: Establish and own data engineering best practices, including data modeling, pipeline design, and observability patterns that the broader team can build on. • Champion Data Quality: Drive data quality and observability initiatives across the platform, ensuring stakeholders can trust the data they rely on. • Collaborate Cross-Functionally: Partner closely with engineering, product, and analytics teams to understand data needs and translate them into concrete technical solutions. • Lead & Mentor: Mentor engineers on data engineering principles and patterns, and contribute actively to hiring and team development.
• Reporting to the Data Platform Lead, you will be a hands-on senior engineer responsible for building and maintaining ApprovalMax's enterprise data platform. • Own the design and delivery of production-grade data pipelines, drive engineering quality across the data stack, and act as a technical mentor for the broader analytics team. • Design, build, and maintain scalable ELT pipelines, ingestion processes, and transformation layers. • Write production-grade Python for orchestration, custom ingestion, and data transformation logic. • Investigate and resolve pipeline failures within agreed SLAs; lead root-cause analysis and implement durable fixes. • Implement and maintain data quality frameworks across the platform; ensure critical data assets have explicit quality contracts. • Partner with Product Engineering, RevOps, and Finance to define and maintain data contracts.
• Diseñar, desarrollar y mantener soluciones de integración y procesamiento de datos en el ecosistema Azure. • Asegurar la disponibilidad, calidad y trazabilidad de la información mediante la construcción y orquestación de pipelines de datos escalables. • Orquestar procesos de integración de datos desde múltiples fuentes, incluyendo bases de datos relacionales, sistemas on-premise, APIs y servicios cloud. • Configurar y administrar Linked Services, Integration Runtime y Self-hosted Integration Runtime. • Implementar procesos de transformación y preparación de datos mediante Mapping Data Flows. • Gestionar la carga y almacenamiento de datos en Azure Data Lake Storage Gen2, Azure Blob Storage, Azure SQL Database y Azure Synapse Analytics. • Desarrollar consultas y procesos de transformación utilizando SQL y Python. • Implementar mecanismos de control de versiones y despliegue continuo mediante Git y Azure DevOps. • Aplicar buenas prácticas de seguridad, gobernanza y acceso a datos utilizando Key Vault, Managed Identities y RBAC. • Monitorear y optimizar el rendimiento de los procesos de integración y carga de datos. • Documentar desarrollos, flujos de integración y procedimientos operativos asociados a las soluciones implementadas.
• Design, build, and maintain ELT/ETL pipelines that move data reliably from source systems into a cloud data warehouse environment. • Write clean, performant, and well-documented SQL to transform raw data into analyst-ready models and reporting layers. • Develop and maintain Power BI dashboards and reports that give business stakeholders clear, trusted views of company performance. • Apply best practices in data modeling within Power BI (star schemas, DAX measures, performance optimization). • Actively use AI tools (such as LLM assistants, copilots, and agentic workflows) to accelerate development and improve code quality. • Engage directly with business stakeholders to understand data needs in context.




