Data Engineer (ETL Focused)

  • Reston, VA
  • Posted 2 days ago | Updated 7 hours ago

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 24 Month(s)

Skills

Ab Initio
Amazon Redshift
Amazon S3
Amazon Web Services
Analytical Skill
ApacheBench
Attention To Detail
Cloud Computing
Communication
Data Engineering
Data Flow
Data Modeling
Data Storage
Database
Electronic Health Record (EHR)
Extract
Transform
Load
FOCUS
Financial Services
Java
Management
Mortgage
Oracle
Orchestration
Python
Relational Databases
SAP BASIS
SQL
Scripting
Software Design
Storage
Systems Design

Job Details

Job Role: Data Engineer

Location: Reston, VA

Duration: 6+ Months

Job Description:

We are seeking a skilled and detail-oriented Data Engineer with strong expertise in ETL development and data pipeline orchestration. This role will focus on processing large volumes of data from diverse file-based sources, transforming them efficiently, and managing secure storage across cloud and traditional databases. The ideal candidate should bring a solid background in ETL tools, cloud services, and relational databases, along with a passion for delivering reliable, production-ready data systems.

Key Responsibilities:

  • Ingest, parse, and transform large-scale structured and semi-structured data from file-based sources
  • Build and maintain robust ETL pipelines, ensuring accurate and efficient data delivery to downstream systems
  • Design and implement data transformations using tools like Ab Initio (or similar) and SQL.
  • Work with cloud-based platforms and services including S3, Lambda, EMR, and Redshift.
  • Support data storage solutions using both cloud (Redshift) and traditional (Oracle) databases
  • Troubleshoot and resolve production data issues, including participation in on-call rotations when necessary
  • Collaborate with team leads and developers to align data flow processes with evolving business needs
  • Participate in solution design and whiteboarding sessions to address complex data engineering challenges

Required Qualifications:

  • 5 6 years of solid experience as a Data Engineer, with a strong focus on ETL development
  • Proven hands-on experience with ETL tools, preferably Ab Initio
  • Strong knowledge of SQL, data modeling, and data transformation techniques
  • Practical understanding of AWS services such as S3, Lambda, EMR, and Redshift
  • Experience with Oracle databases and handling large-scale datasets
  • Ability to work independently and take ownership of data pipeline design and maintenance
  • Strong analytical and troubleshooting skills
  • Excellent verbal communication and design articulation during technical discussions

Preferred Qualifications:

  • Experience or familiarity with scripting in Python or Java to support cloud integrations
  • Domain knowledge in financial services, especially in secondary mortgage markets
  • AWS Certifications or equivalent cloud/data engineering credentials are a strong plus
  • Ability to understand business domain logic and translate it into technical implementation.

EEO: MindLance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.