ETL Data Engineer
Tysons Corner, VA
Category: Data
Industry: Financial Services
Reference ID: JN -062026-107214
Date Posted: 06/02/2026
Shortcut: http://careers.eliassen.com/LhQIvc
Description:
Hybrid 3 days onsite / 2 days remote in Mclean, VA
Our client seeks an ETL Data Engineer to build and maintain large-scale data pipelines and to design agentic AI systems that support regulatory analytics. The role spans Spark-based ETL on AWS data lake platforms and development of LLM-powered agents with secure, auditable outputs. The engineer will collaborate across teams, uphold secure development practices, and contribute to CI/CD and infrastructure-as-code while monitoring data quality and production performance.
We can facilitate w2 and corp-to-corp consultants. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $70.00 to $88.00/hr. w2
Responsibilities:
- Build and maintain ETL/ELT pipelines using Apache Spark, Hive, and Trino across S3-based data lakes.
- Develop and optimize SQL for large-scale surveillance datasets using window functions, joins, and complex aggregations.
- Engineer big data systems on EMR-on-EC2 and EMR-on-EKS and deliver solutions on analytical platforms such as SageMaker, Domino, or Dataiku.
- Participate in data quality monitoring, anomaly detection, and production incident investigation.
- Develop AI agent systems using AWS Bedrock and agent frameworks such as Strands Agents SDK or LangChain/LangGraph.
- Design agent harnesses that combine LLM reasoning with deterministic execution including skill or RAG-based SQL generation and structured output validation.
- Implement agent memory, context management, and tool integration including MCP servers, API connectors, and data catalog lookups.
- Build evaluation frameworks for agent accuracy covering paraphrase robustness, routing precision, and structural consistency.
- Stay informed on advances in LLM frameworks and emerging AI capabilities.
- Write clean, well-tested code and contribute to CI/CD pipelines and infrastructure-as-code on AWS.
- Ensure secure handling of sensitive regulatory data with auditable execution traces.
- Adhere to secure development practices and technology policies.
- Partner across teams, communicate at the appropriate technical level, and maintain documentation on Confluence or Wiki.
- Learn from senior team members and contribute to process improvement.
Experience Requirements:
- Experience building data pipelines with Apache Spark (PySpark preferred) and SQL.
- Experience with SQL engines such as Hive or Trino and cloud data platforms including AWS S3, EMR, and Lambda.
- Understanding of data skew, large-volume processing, and troubleshooting job failures due to resources, data quality, and scalability.
- Hands-on debugging and mitigation experience.
- Practical experience building LLM-powered agent systems that use tools and produce structured outputs.
- Experience with agent frameworks such as LangChain, LangGraph, or AWS Strands.
- Knowledge of prompt engineering, RAG architectures, and context or memory management.
- Experience with foundation model APIs such as Anthropic Claude, Amazon Nova, or OpenAI.
- Understanding of agent memory tiers and strategies for persistence, pruning, and retrieval.
- Familiarity with harness patterns including deterministic guardrails, tool routing, and verification loops.
- Hands-on experience with AI development tools such as GitHub Copilot, Q Developer, ChatGPT, or Claude.
- Experience with spec-driven development for AI-assisted code generation and validation.
- Ability to leverage AI pair programming for suggestions, debugging, refactoring, and automated test generation.
- Experience with AWS services including S3, EMR, EMR on EKS, Lambda, Bedrock, and Step Functions.
- Hands-on experience using S3 with Spark and related file format or consistency considerations.
- Familiarity with AWS Bedrock guardrails, knowledge bases, and agent orchestration.
- Exposure to Google Cloud Vertex AI or equivalent managed AI platforms.
- Familiarity with AWS monitoring and logging tools such as CloudWatch and CloudTrail.
- Proficiency in Python with clean, modular, and performant code and understanding of functional concepts.
- Strong understanding of collections, concurrency, and memory management.
- Proficiency with SQL window functions, joins, aggregations, and complex query optimization including edge cases.
Education Requirements:
- Bachelor's degree in Computer Science, Data Science, Information Systems, or related discipline with at least two years of related experience, or equivalent training and work experience. Financial services experience preferred.
- Demonstrated expertise in object-oriented and database technologies resulting in enterprise-quality solutions.
- Knowledge of software engineering approaches including test automation, build automation, and configuration management.
- Strong written and verbal technical communication skills and effective cross-team collaboration.
- Ability to learn new skills rapidly and operate in a fast-paced environment.
Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.
W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.
If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:
· When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.
· Eliassen Group will never ask you for personal information (home address, bank account, or check routing number) until you have worked with someone clearly associated with Eliassen Group.
If you have any indication of fraudulent activity, please contact fraud@eliassen.com.
-
AI Software Engineer
Greenwood Village, CO
Description: Hybrid 4 onsite / 1 work from home in Greenwood Village, CO Our client seeks an AI-focused Software Engineer to design, build, and deploy practical AI-driven tools that improve data analyst, data engineering, and QA workflows. The role cen...
Date Posted: 05/19/2026 Recommended
-
Senior AI/ML Engineer
Anywhere
Description: Remote Our client seeks a Senior AI/ML Engineer to design and deliver cloud-native machine learning solutions on AWS. The role includes LLM orchestration, RAG pipelines, vector database integration, and multi-agent systems. The engineer wi...
Date Posted: 05/26/2026 Recommended
-
Senior AI Engineer
Charlotte, NC
Description: On-site 4/1 in Charlotte, NC Our client seeks a Senior AI Engineer to lead IVR and conversational AI initiatives for large-scale customer interactions in telecommunications and digital services. The role requires strong pre-LLM experience ...
Date Posted: 05/05/2026 Recommended
-
Lead AI Engineer
Rockville, MD
Description: Hybrid 3 days onsite / 2 days remote in Rockville, MD Our client seeks a Lead AI Engineer to design and deliver an AI-powered compliance screening platform for regulated communications across text and multimedia. The role will architect mu...
Date Posted: 05/10/2026 Recommended
-
Sr SQL AWS Eng
Rockville, MD
Description:Hybrid 3 days onsite / 2 days remote in Rockville, MD Our client seeks a senior engineer to deliver analytics, dashboards, and insights using enterprise data. The role emphasizes SQL and AWS services to enable reliable and scalable reportin...
Date Posted: 05/12/2026 Recommended
-
Software Engineer - Data/Opensearch
Charlotte, NC
Description: Hybrid in Charlotte, NC Our client seeks a senior software engineer to build and operate the software, data, and metadata foundations of a Data Marketplace platform. The role focuses on Python services, AWS infrastructure automation with T...
Date Posted: 06/02/2026 Recommended
-
Data Engineer
Durham, NC
Description: Hybrid Every other week onsite/5 days in Durham, NC Our client seeks a Data Engineer to build and scale data solutions on AWS with Snowflake. The role focuses on data analysis, data modeling, and ETL development using Python and SQL to sup...
Date Posted: 05/14/2026 Recommended
-
Senior/Lead AI Software Engineer
Farmington Hills, MI
Description: Farmington Hills, MI Our client seeks an AI Software Engineer III to lead design and delivery of guardrail components and cross-service enforcement for AI-driven systems. The role will architect backend services, APIs, and integrations, de...
Date Posted: 05/14/2026 Recommended
-
AI Consultant II
Charlotte, NC
Description: Hybrid 3 On in Charlotte, NC Our client seeks an AI Consultant to educate stakeholders, lead ideation, and translate business needs into scalable AI solutions. The role requires strong communication, design-thinking facilitation, and profi...
Date Posted: 05/10/2026 Recommended
-
Quant Developer
Jersey City, NJ
Description: On-site in Jersey City, NJ Our client seeks a senior software engineer to lead design and development of next-generation electronic trading systems and data infrastructure. The role requires hands-on leadership building scalable, resilient...
Date Posted: 05/25/2026 Recommended
-
Principal Systems Analyst
Anywhere
Description: Remote Our client seeks Principal Systems Analysts to drive analysis and documentation supporting the modernization of brokerage, trading, reporting, and data processing systems to AWS. The role requires enterprise systems analysis, strong...
Date Posted: 05/10/2026 Recommended
-
Data Engineer
Smithfield, RI
Description: Onsite in Smithfield, RI Our client seeks a Data Engineer to design, build, and support enterprise-scale data platforms and pipelines. The role focuses on ELT/ETL across Snowflake, Oracle, and PostgreSQL, with strong Python, SQL, and orche...
Date Posted: 05/12/2026 Recommended
-
System Administrator - Mid
Cambridge, MA
Description: Hybrid 2 days/ WK in Cambridge, MA Our client seeks a System Administrator - Mid to support a federal program in Cambridge, MA. The role will manage day-to-day administration of Windows-centric infrastructure across on-prem and cloud envir...
Date Posted: 05/19/2026 Recommended
-
Java Developer
Salt Lake City, UT
Description: Onsite in Salt Lake City, UT Our client seeks a software engineer to build and enhance customer-focused APIs that power digital experiences in financial planning, investing, and retirement. You will design, develop, and deploy reusable Jav...
Date Posted: 05/10/2026 Recommended
-
AWS Cloud Architect
Anywhere
Description: Remote Our client seeks a cloud architect to design, implement, and govern secure AWS environments across development, testing, and production. The role covers enterprise architecture, AI implementation support, infrastructure as code, Dev...
Date Posted: 05/31/2026 Recommended
-
Senior Platform / DevOps Engineering Consultant (Java / Kubernetes)
Westlake, TX
Description: 50% hybrid / on site in Westlake TX We are seeking a Senior Platform / DevOps Engineer to join a Platform Engineering team within a large financial services enterprise. This team builds and operates large-scale, cloud-native, event-driven ...
Date Posted: 05/06/2026 Recommended
-
AWS Solution Architect
Charlotte, NC
Description: Hybrid 3 on in Charlotte, NC Our client seeks a Solutions Architect to lead strategy and technical design for an AWS-based analytics ecosystem, guiding the migration of a large on-premises SQL Server data warehouse to cloud-native services...
Date Posted: 05/29/2026 Recommended
-
Lead Software Engineer v
Durham, NC
Description: On-site in Durham, NC Our client seeks a Lead Java Developer and Architect to design, architect, and deliver complex enterprise systems. The role requires deep hands-on engineering, leadership across distributed teams, and a focus on cloud...
Date Posted: 05/20/2026 Recommended
-
Oracle SQL/PLSQL - Exadata
Westlake, TX
Description: Hybrid every other week onsite/5 days in either Westlake, TX or Jersey City, NJ or Smithfield, RI Our client seeks a Principal Software Engineer / Full Stack Engineer with deep Oracle SQL/PLSQL expertise and hands-on Exadata engineering ex...
Date Posted: 05/21/2026 Recommended
-
Full Stack Engineer
Westlake, TX
Description: Onsite in Westlake, TX Our client seeks a Full Stack Engineer to design and develop scalable products and APIs that support digital client and advisor appointment experiences. You will contribute to a resilient content platform within the ...
Date Posted: 05/06/2026 Recommended
-
Full Stack Engineering Consultant
Westlake, TX
Description: Hybrid (50% on site) Our client seeks a Full Stack Engineer focused on backend services to build reusable APIs and web components that power customer experiences in financial planning, investing, and retirement. The role will design and de...
Date Posted: 05/26/2026 Recommended
-
Senior/Lead Generative AI Platform Engineer
Concord, CA
Description: Hybrid 3 days/week in Concord, CA Our client seeks a Senior/Lead Generative AI Platform Engineer to design, implement, and scale enterprise AI/ML platforms across hybrid cloud. The role will architect secure, cost-optimized, and high-perfo...
Date Posted: 05/30/2026 Recommended
-
Full Stack Engineer
Anywhere
Description: Remote Our client seeks a Full Stack Engineer to build and maintain modern websites and digital products. The role will contribute across the stack with TypeScript, React, Next.js, Node.js, and WordPress while emphasizing performance, reli...
Date Posted: 05/20/2026 Recommended
-
Senior Manager, Business Intelligence
Providence, RI
Description: Hybrid onsite in either Providence, RI Our client seeks a Senior Manager, Business Intelligence to lead the strategy and delivery of enterprise analytics using Snowflake, modern BI platforms, and AI-driven insights. The role manages a BI t...
Date Posted: 06/03/2026 Recommended
-
Principal AWS Cloud Developer
Westlake, TX
Description: Hybrid Every other week onsite/5 days in Westlake, TX Our client seeks a Principal Cloud Developer to build scalable backend services and modernize mainframe capabilities that support digital experiences in financial planning, investing, a...
Date Posted: 06/01/2026 Recommended
-
SW Engineer in Test
Merrimac, NH
Description: Onsite in Merrimac, NH or West Lake, TX Our client seeks a Software Engineer in Test to build and maintain automated testing and DevSecOps assets across Java and database stacks. The role will design, develop, test, and deploy automation f...
Date Posted: 05/07/2026 Recommended
-
Mainframe Engineer
Westlake, TX
Description: Onsite in Westlake, TX Our client seeks a Mainframe Engineer to develop and maintain high-volume, business-critical money movement platforms within brokerage record-keeping technology. You will collaborate with product, architecture, opera...
Date Posted: 05/11/2026 Recommended
-
Senior AWS Cloud Developer
Westlake, TX
Description: On-site in Westlake, TX Our client seeks a Senior AWS Cloud Developer to build scalable backend services for digital financial experiences. The team modernizes mainframe capabilities and delivers reusable Java applications that power custo...
Date Posted: 05/25/2026 Recommended
-
Senior DevSecOps / Application Security Engineer
Fenton Cary, NC
Description: Onsite in Fenton Cary, NC We are seeking a Senior DevSecOps / Application Security Engineer to join a modern Information Security organization supporting rapidly evolving development environments. This role sits at the intersection of appl...
Date Posted: 05/21/2026 Recommended
-
Infrastructure Engineer (Cloud / Cisco)
Washington, DC
Description: Washington, DC • Hybrid, 3 days onsite / 2 days remote Our client seeks a Senior Infrastructure Engineer to manage and optimize on-premises and cloud network environments. The role supports network hardware, monitoring tools, and core serv...
Date Posted: 05/20/2026 Recommended
Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. Eliassen Group’s Affirmative Action Plan (AAP) is available for inspection by any employee or applicant for employment upon request, during normal business hours of Monday through Friday, 8:30am to 5:30pm EST. Interested persons should contact Phaedra Wells at pwells@eliassen.com for assistance. It is unlawful in Massachusetts and Maryland to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Applicants with disabilities that believe they require an accommodation or assistance with a position, please email our HR team at hradmin@eliassen.com. This email inbox is designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Emails sent for other purposes will not receive a response.
Please be advised that a number of fraudulent job postings have been released under the Eliassen Group brand.
Unfortunately, fraudulent job postings can happen. If anyone reaches out to you about an open position connected with Eliassen Group, never provide personal or financial information to anyone who is not clearly associated with Eliassen Group
If anyone seemingly from Eliassen Group has ever requested this personal information in the past or does so in the future, please contact fraud@eliassen.com.
Please ensure that you are working directly with us by confirming the following:
- When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.
- Eliassen Group will never ask you for personal information (home address, bank account, or check routing number) until you have worked with someone clearly associated with Eliassen Group, as indicated above