Data Engineer - Data Warehouse Architect

ICF • Reston, VA • 4h ago

Description

This position focuses on developing, implementing, and maintaining architecture solutions across a large enterprise data warehouse to support effective and efficient data management and enterprise-wide business intelligence analytics.

Responsibilities:

Implement and optimize data pipeline architectures for sourcing, ingestion, transformation, and extraction processes, ensuring data integrity and compliance with organizational standards.

Develop and maintain scalable database schemas, data models, and data warehouse structures; perform data mapping, schema evolution, and integration between source systems, staging areas, and data marts.

Automate data extraction workflows and create comprehensive technical documentation for ETL/ELT procedures; collaborate with cross-functional teams to translate business requirements into technical specifications.

Establish and enforce data governance standards, including data quality metrics, validation rules, and best practices for data warehouse design and architecture.

Develop, test, and deploy ETL/ELT scripts using SQL, Python, Spark, or other relevant languages; optimize code for performance and scalability.

Tune data warehouse systems for query performance and batch processing efficiency; apply indexing, partitioning, and caching strategies.

Perform advanced data analysis, validation, and profiling using SQL and scripting languages; develop data models, dashboards, and reports in collaboration with stakeholders.

Conduct testing and validation of ETL workflows to ensure data loads meet SLAs and quality standards; document testing protocols and remediation steps.

Troubleshoot production issues, perform root cause analysis, and implement corrective actions; validate data accuracy and consistency across systems.

Basic Qualifications:

Minimum of 3 years of experience in data analysis.

Additional Qualifications:

Strong analytical and problem-solving skills with attention to detail.

Proficiency in SQL and ability to develop complex queries (e.g., multi-join), tune performance, and troubleshoot.

Experience with Unix/Linux shell scripting for ETL automation.

Familiarity with database tools and platforms (e.g., Teradata, Oracle, Non-Relational).

Excellent verbal and written communication skills; ability to collaborate across all levels.

Ability to prioritize and multi-task in a fast-paced environment.

Knowledge of Java/J2EE, REST APIs, Web Services, and event-driven microservices.

Experience with Kafka streaming, schema registry, OAuth authentication.

Familiarity with Spring Framework, GCP services, Git, CI/CD pipelines, containerization, and data ingestion/data modeling.

Preferred Qualifications:

Experience with Databricks concepts and terminology (e.g., workspace, catalog).

Proficiency in Python and Spark.

Background in architecting real-time data ingestion solutions using microservices and Kafka.

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 (https://www.icf.com/legal/equal-employment-opportunity) 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? Candidateaccommodation@icf.com ?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?righ t s 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 at? candidateaccommodation@icf.com . 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:

$73,722.00 - $125,327.00

Nationwide Remote Office (US99)

ICF

Go to Apply

Share this job

Similar Jobs

Principal Software Engineer

Northrop Grumman • Chantilly, VA • 13min ago

IT & Engineering

RELOCATION ASSISTANCE: Relocation assistance may be available CLEARANCE TYPE: Secret TRAVEL: Yes, 10% of the Time Description At Northrop Grumman, our employees have incredible opportunities to work on revolutionary syst...

13min ago

Go to Apply

Junior Software Engineer

SAIC • Arlington, VA • 17min ago

IT & Engineering

Description SAIC is seeking a highly motivated and talented Junior Software Engineer to join our team in Arlington, Virginia. This role involves contributing to the design, development, and implementation of innovative s...

17min ago

Go to Apply

Software Engineer (Tactical Decision Aids - Production & Integration)

Leidos • Bethesda, MD • 18min ago

IT & Engineering

Description Leidos' High Fidelity Simulation Business Area designs and delivers cutting-edge system-of-systems solutions that power world-class simulation, training, and analysis products for the U.S. Navy . In this role...

18min ago

Go to Apply

Software Engineer (Tactical Decision Aids - Web Platform)

Leidos • Bethesda, MD • 18min ago

IT & Engineering

18min ago

Go to Apply

Software Engineering Intern - Hyper-RF Division

AeroVironment • Germantown, MD • 19min ago

IT & Engineering

Worker Type Fixed Term (Fixed Term) Job Description Summary At AV, we understand that a valuable internship should provide meaningful learning and real-world experience. Our Summer Internship Program offers students the...

19min ago

Go to Apply

Lead Software Engineer - Perl

UKG • Washington, DC • 23min ago

IT & Engineering

Why UKG: At UKG, the work you do matters. The code you ship, the decisions you make, and the care you show a customer all add up to real impact. Today, tens of millions of workers start and end their days with our workfo...

23min ago

Go to Apply

Data Center Design Engineer-Mechanical, Cooling System

Oracle • Washington, DC • 4h ago

IT & Engineering

Job Description Oracle's Data Center Engineering team is seeking an experienced Mechanical Engineer with background in designing mechanical systems for data centers. Qualifications Bachelor's degree in Mechanical Enginee...

4h ago

Go to Apply

Model Based Systems Engineer

Actalent • Reston, VA • 4h ago

IT & Engineering

Job Title: Model-Based Systems EngineerJob Description We are seeking a Model-Based Systems Engineer to join our team and support a cutting-edge defense initiative. This strategic program focuses on adapting and integrat...

4h ago

Go to Apply

Model Based Systems Engineer

Actalent • Reston, VA • 4h ago

IT & Engineering

Job Title: Model-Based Systems Engineer Job Description We are seeking 2 Model-Based Systems Engineers to join our team and support a cutting-edge defense initiative. This strategic program focuses on adapting and integr...

4h ago

Go to Apply

Data Scientist

CACI International • Bethesda, MD • 4h ago

IT & Engineering

Data Scientist Job Category: Science Time Type: Full time Minimum Clearance Required to Start: Secret Employee Type: Regular Percentage of Travel Required: Up to 10% Type of Travel: Continental US The Opportunity: CACI a...

4h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.