Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government''s most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. 

*This is an exempt position. Salary commensurate with experience*

Job Title: AWS Data Engineer
Location: Schenectady, NY (Hybrid)
Duration: 12 Months (with potential for extension)
Start Date: estimated - September 1, 2026
Hourly Rate: W2 $50-$70/hour

Overview:

We are seeking an AWS Data Engineer who will support our NYS client. This role will design, develop, and maintain scalable AWS-based data pipelines and an interim lakehouse supporting enterprise analytics, reporting, and operational data needs. The consultant will focus on CDC and streaming ingestion, ETL/ELT, source-to-target mapping, data quality, governance, and secure analytic data access for Data SMEs and technical stakeholders.

Duties:

Design and implement scalable data ingestion frameworks for batch, near real-time, and streaming data sources.
Develop Change Data Capture (CDC) solutions for incremental data movement and synchronization across enterprise systems.
Build and maintain streaming data pipelines supporting operational reporting and event-driven processing.
Integrate data from internal applications, AWS services, external vendors, and third-party platforms.
Design, build, and support an interim AWS lakehouse with raw, curated, and business-ready data layers.
Implement data partitioning, optimization, and lifecycle management strategies to improve performance and cost efficiency.
Design, develop, maintain, and optimize reusable ETL and ELT pipelines using cloud-native technologies.
Implement orchestration and scheduling for automated data processing workflows.
Develop and maintain source-to-target mappings, transformation logic, business rules, and data definitions.
Support logical and physical data modeling for analytics, reporting, and operational use cases.
Document data lineage, metadata, mappings, and transformation processes to support governance and traceability.
Enable secure and efficient access to curated data assets for Data SMEs, analysts, reporting teams, and business users.
Implement data validation, monitoring, quality controls, and troubleshooting across ingestion and transformation pipelines.
Collaborate with data architects, application teams, analytics teams, and business stakeholders to deliver trusted data products.

Mandatory Qualifications:

7+ years of experience in data engineering, data integration, or data warehouse development.
3+ years of hands-on experience developing cloud-native data solutions on AWS.
Strong experience designing and implementing ETL and ELT pipelines.
Experience developing Change Data Capture (CDC) and streaming data solutions.
Experience designing scalable batch, near real-time, and streaming data ingestion frameworks.
Experience developing source-to-target mappings and data transformation logic.
Strong understanding of data warehousing, lakehouse architecture, and analytical data models.
Experience with SQL, data transformation, workflow orchestration, and automated scheduling.
Experience implementing data validation, monitoring, data quality, metadata, and lineage controls.
Experience supporting analytics, reporting, business intelligence, and secure access to curated data assets.
Ability to collaborate effectively with data architects, Data SMEs, analytics teams, application teams, and other stakeholders.

Desirable Qualifications:

Experience with modern data lake and lakehouse technologies.
Experience with AWS-native orchestration and workflow automation tools.
Familiarity with metadata management, data cataloging, and data governance solutions.
Experience working in large, complex enterprise environments with multiple stakeholders and source systems.
Experience optimizing analytical datasets and access patterns for business intelligence, dashboarding, and advanced analytics.

Educational & Certification Requirements:

Bachelor''s degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related field.
AWS Certified Data Engineer or AWS Certified Solutions Architect certification is preferred.

What We Offer:

Opportunities to lead impactful transformations in the public sector infrastructure.
Engagement with high-profile government initiatives, supporting meaningful change.
A collaborative environment that values ownership, initiative, and continuous learning.

Ready to make a difference?

We’re eager to connect with qualified candidates committed to delivering results and fostering excellence within client projects.

Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.

AI-Assisted Resume Evaluation Notice
Cloud and Things – Talent Management

Notice to Candidates
Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.

How AI Is Used
Our AI tools assist by:

Analyzing resumes against job requirements
Supporting our recruiters in candidate data evaluation
Ensuring consistent review standards across all applications
Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.

Your Data and Privacy

Cloud and Things Data Handling:

Your information is processed securely and used exclusively for recruitment purposes
Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities
You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com
All personal information is handled confidentially in accordance with our privacy policy

AI Tool Data Processing:

AI processing data is retained for a maximum of 90 days, after which it is deleted
All data sent to AI tools is encrypted in transit and at rest
AI tools comply with applicable privacy laws including GDPR and CCPA
Personal data is anonymized or minimized wherever possible during AI processing

Your Participation
By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.

AWS Data Engineer

Quick Overview

Job Description

Skills

Similar jobs

Graph Data Engineer / SPARQL Developer

Senior Data Engineer/Architect

Sr. Python Developer with Strong AWS Athena - Data Engineer

Data Engineer

Senior Azure Data Engineer/Azure Synapse Data Engineer/Azure Analytics Engineer

Principal, Data Engineer with Security Clearance