AWS Lakehouse Data Engineer
McLean, VA
Experience: 0
Category: Information Technology
Contractor Work Model: Remote
Brand: System One
Job ID: 381092
Date Posted: 09/29/2026
Shortcut: http://jobs.systemone.com/a7RLSS
Job Title: AWS Lakehouse Data Engineer
Work Model: Remote – offsite
Responsibilities
- Build and operate data pipelines (batch and streaming) from APIs, relational databases, file drops, event streams, and external partners.
- Design, implement, test, and optimize ETL/ELT pipelines using Python and PySpark to produce analytics-ready datasets for reporting, visualization, and machine learning.
- Implement incremental processing, change data capture (CDC), data contracts, schema validation, and reusable transformation frameworks.
- Improve pipeline reliability through automated testing, orchestration, monitoring, retries, and operational runbooks.
- Design and implement a Delta Lakehouse-style data platform on AWS using native services to provide Databricks-like capabilities for data engineering, analysis, and data visualization.
- Build and manage a scalable lakehouse on Amazon S3 using Apache Iceberg and open columnar formats such as Apache Parquet.
- Implement SQL-like table reliability features including ACID transactions, schema evolution, snapshot isolation, and time travel using Apache Iceberg.
- Enable fast, interactive queries of lakehouse data via AWS-native services like Amazon Athena, Amazon EMR, AWS Glue, and Amazon Redshift where appropriate.
- Optimize performance and cost through partitioning, file sizing, caching, lifecycle policies, and separating compute from storage.
- Establish standardized environments for development, testing, and production with consistent configuration and controlled promotion.
- Implement data governance, access control, lineage, and quality measures utilizing AWS-native services including AWS Lake Formation, AWS Glue Data Catalog, IAM, KMS.
- Create a metadata repository with cataloging, ownership, classification, tagging, and discoverability features.
- Enable end-to-end data lineage for audit and regulatory compliance.
- Apply policy-based access, least privilege, data classification, retention, encryption, and secure handling controls.
- Build data quality checks for freshness, completeness, validity, and anomaly detection, and publish SLA/SLO metrics.
- Automate AWS provisioning with Infrastructure as Code (IaC), develop CI/CD pipelines for data components, and ensure platform observability.
- Work collaboratively with cross-functional teams and maintain high-quality engineering documentation.
Requirements
- Bachelor's degree in Engineering, Information Technology, Computer Science, Data Engineering, or related field, or four (4) years of equivalent practical experience.
- Six (6) years of relevant experience.
- Hands-on experience building AWS-native data lake or lakehouse architectures on Amazon S3.
- Strong experience developing production ETL/ELT pipelines with Python and PySpark, including data modeling, transformation, and performance tuning.
- Hands-on experience with Apache Iceberg, including ACID transactions, schema evolution, time travel, and query optimization.
- Advanced SQL skills supporting analytical workloads, reporting, and data visualization.
- Proven experience with data governance, cataloging, lineage, and access control using AWS services.
- Knowledge of AWS security fundamentals: IAM, KMS, secrets management, network security, logging, SDLC.
- Proven experience with Infrastructure as Code (IaC) and operating data platforms across environments.
- Experience with CI/CD pipelines for data workflows with testing, deployment, environment promotion, and rollback.
- Troubleshooting distributed data workloads, performance optimization, and cost management skills.
- Excellent collaboration and communication skills to coordinate with cross-team stakeholders.
Would Be Nice to Have
- Experience with Databricks, Delta Lake, migrating workloads to AWS-native services, and Apache Iceberg.
- Familiarity with AWS Step Functions, MWAA, Kinesis, DMS, Lambda, MSK, or similar services.
- Experience with modern DevOps tools: Git, Terraform, CloudFormation, Jenkins, CodePipeline, GitHub Actions, Docker.
- Knowledge of BI and visualization tools like Amazon QuickSight, Tableau, Power BI.
- Familiarity with AI-assisted coding tools such as GitHub Copilot, ChatGPT, Cursor, or Kiro.
- Knowledge of graph modeling, ontology, taxonomy, entity resolution, and hybrid retrieval techniques.
System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#LI-KA1
#M1
Ref: #851-Rockville-S1
-
AWS Data Engineer
McLean, VA
Job Title: AWS Data Engineer Location: McLean, VA Type: Contract-to-Hire Compensation: $150,000.00 - $170,000.00 Work Model: Remote – offsite Security Clearance: US Citizen with the ability to obtain a public trust System One is looking for a strong AW...
Date Posted: 09/01/2026 Recommended
-
AI/ML Data Scientist
McLean, VA
Job Title: AI/ML Data Scientist Location: 100% REMOTE Clearance: Ability to obtain and maintain a Public Trust clearance. Type: Contract-to-hire Contact: Crystal.dinnocenti@systemone.com WHAT YOU WILL DO: Partner with stakeholders to define and deliver...
Date Posted: 09/28/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • Administer enterprise Source Code Management (SCM) rep...
Date Posted: 08/06/2026 Recommended
-
Data Architect- Wealth Management
Naperville, Illinois
Data Architect Location: Hybrid, Naperville, IL Duration: 6+ Months with Extention Job Summary Join a collaborative Data & Analytics team building a modern cloud-native data platform on AWS. This hands-on Data Architect role will define the data archit...
Date Posted: 07/16/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • ...
Date Posted: 08/06/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Data Analyst – Data Integration & Enablement
Salt Lake City, Utah
Job Title: Data Analyst – Data Integration & Enablement Location: Salt Lake City, UT Type: Permanent Full Time Compensation: 0 Work Model: Hybrid – onsite and remote Hours: 40.0 Security Clearance: None Overview Leave placeholder text here for recruite...
Date Posted: 09/25/2026 Recommended
-
Network Engineer
Salt Lake City, Utah
Job Title: Network Engineer Location: Salt Lake City UT Type: Contract to Hire Work Model: Onsite – onsite Hours: 40.0 Security Clearance: Not specified Responsibilities • Design, implement, and maintain scalable, secure, resilient, and highly availabl...
Date Posted: 08/26/2026 Recommended
-
Senior AWS Java/Python Developer with Microservices & API experience
Knoxville, Tennessee
Job Title: Senior AWS Java/Python Developer with Microservices & API experience Location: Knoxville, TN Type: Direct Hire Compensation: $98,000.00 Work Model: Onsite – onsite Hours: 40.0 Security Clearance: (not specified) Overview Leave placeholder te...
Date Posted: 09/09/2026 Recommended
-
Senior GenAI & Data Engineer
Reston, Virginia
Job Title: Senior GenAI & Data Engineer Location: Reston, Virginia Type: Direct Hire Work Model: Hybrid – onsite and remote Overview System One is seeking a Senior GenAI & Data Engineer to develop and integrate AI-enabled solutions within a large-scale...
Date Posted: 09/25/2026 Recommended
-
Senior GenAI & Data Engineer
Reston, Virginia
Job Title: Senior GenAI & Data Engineer Location: Reston, Virginia Type: Direct Hire Work Model: Hybrid – onsite and remote Overview System One is seeking a Senior GenAI & Data Engineer to develop and integrate AI-enabled solutions within a large-scale...
Date Posted: 09/19/2026 Recommended
-
Data Architect- Wealth Management
Naperville, Illinois
Job Title: Data Architect- Wealth Management Location: Naperville, IL Type: Direct Hire Compensation: Open Work Model: Onsite Hours: 40.0 Security Clearance: N/A Responsibilities Design and maintain the end to end data architecture for the Wealth Manag...
Date Posted: 07/15/2026 Recommended
-
AWS Cloud DBA
McLean, VA
Job Title: AWS Cloud DBA Location: McLean, VA Type: Long-term contract Work Model: Remote Hours: 40.0 Security Clearance: Ability to obtain a Federal Public Trust clearance Contact: Crystal.dinnocenti@systemone.com RESPONSIBILITIES Design, deploy, and ...
Date Posted: 09/11/2026 Recommended
-
Network Engineer
Salt Lake City, Utah
Job Title: Network Engineer Duration : Contract to Hire Location : Salt Lake City/Midvale, UT Work Mode : 5 Days Onsite Job Description Network Engineer – Enterprise Network Modernization Systemone is seeking an experienced Network Engineer to help des...
Date Posted: 09/28/2026 Recommended
-
R&D Technical Writer
Salt Lake City, UT
Job Title: R&D Technical Writer Location: Salt Lake City, UT Type: Contract Compensation: $40 - $44.97/hr Work Model: Onsite Responsibilities Assist in the development and review of labeling documentation, including drawings, change orders, and specifi...
Date Posted: 09/28/2026 Recommended
-
PL/SQL Developer
McLean, VA
Job Title: PL/SQL Developer Responsibilities • Support application development, database engineering, data integration, analytics enablement, and operational database activities for the GrantSolutions platform. • Design, develop, test, maintain, and op...
Date Posted: 08/25/2026 Recommended
-
Senior AWS IAM & Data Engineer
Lafayette, Louisiana
Senior AWS IAM & Data Engineer Job Type: Permanent Full-Time Hybrid Lafayette, LA | Knoxville, TN | Columbia, SC | Birmingham, AL Position Overview We are seeking a Senior AWS IAM & Data Engineer to support enterprise cloud identity services and AWS-ba...
Date Posted: 09/19/2026 Recommended
-
Mainframe Developer (COBOL, CICS, DB2)
Salt Lake City, UT
Mainframe Developer – COBOL, CICS, DB2 6 Months Contract-to-Hire Midvale, UT and Salt Lake City, Utah Position Overview Seeking an experienced Mainframe Developer to develop, maintain, enhance, and support mission-critical enterprise applications. The ...
Date Posted: 07/30/2026 Recommended
-
Software Developer
McLean, VA
Software Developer Practice: Software Development & Support / Digital Company: Guidehouse Location: Remote Security and Work Authorization Requirements • Must be able to obtain and maintain a Federal or Department of Defense Public Trust. • Candidates ...
Date Posted: 08/25/2026 Recommended
-
AWS AI/Data Engineer
Knoxville, Tennessee
Job Title: AWS AI/Data Engineer Location: Knoxville, Tennessee Type: Direct Hire Work Model: Hybrid – onsite and remote Overview System One is seeking an AWS AI/Data Engineer to support the development of AI-driven and analytical capabilities for enter...
Date Posted: 09/21/2026 Recommended
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Responsibilities Lead business analysis, strategic planning, and migration initiatives supporting the transition from legacy FX trading platforms, su...
Date Posted: 08/06/2026 Recommended
-
AWS Data Engineer
Knoxville , Tennessee
Job Title: AWS Data Engineer Location: Knoxville, TN, Columbia SC or Lafayette, LA or Birmingham, AL Type: Direct Hire Responsibilities • Support the development, enhancement, and maintenance of Enterprise Risk Analytics applications within a financial...
Date Posted: 09/23/2026 Recommended
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities Lead business analysis, strategic planning, and migration initiatives supporti...
Date Posted: 08/06/2026 Recommended
-
Senior AWS Data Engineer
Pittsburgh , Pennsylvania
Job Title: Senior AWS Data Engineer Location: Knoxville, TN, Columbia SC or Lafayette, LA or Birmingham, AL Description: Senior AWS Data Engineer to support the development, enhancement, and maintenance of enterprise risk analytics applications within ...
Date Posted: 08/28/2026 Recommended
-
Full Stack Developer
Pittsburgh , Pennsylvania
Job Title: Full Stack Developer Location: Dallas or Plano, Texas. No.Openings: 3 Description: Full Stack Developer Position Description We're growing rapidly and are looking for Full Stack Developers to join our Telecommunications Sector. We're a close...
Date Posted: 08/04/2026 Recommended
-
Senior Cloud Administrator (onsite)
Washington, DC
Senior Cloud Administrator Washington, DC – 100% Onsite Per Federal contract U.S. citizenship is required Must be able to obtain Public Trust clearance W2 or C2C Join our Cloud Architecture and Administration team at the forefront of secure, innovative...
Date Posted: 09/28/2026 Recommended
-
Field Designer
Rice Lake, Wisconsin
Job Title: Field Designer Location: Rice Lake, Wisconsin Type: 6 month Contract Compensation: $30.00 - $31.50 hourly Contractor Work Model: Hybrid Hours: Monday and Friday remote, Tues - Thurs office or on-site (30% field work) System One is currently ...
Date Posted: 08/28/2026 Recommended
-
Data & Systems Analyst
McLean, VA
Job Title: Data & Systems Analyst - Modernization Location: McLean, VA – can be Remote (EST) Type: Contract to Hire Clearance: Ability to obtain a Federal/DoD Public Trust. Active Public Trust preferred About the Role The Data Analyst will support the ...
Date Posted: 08/25/2026 Recommended
-
Senior AWS Site Reliability Engineer (SRE)
Birmingham , Alabama
Job Title: Senior AWS Site Reliability Engineer (SRE) Location: Birmingham, Alabama Type: Contract To Hire Work Model: Onsite – onsite Hours: 40.0 Security Clearance: Overview Responsibilities Implement and improve SRE practices across AWS hosted enter...
Date Posted: 09/14/2026 Recommended