Data Analyst ETL & AWS
Overview
This role owns the design, build, and maintenance of ETL pipelines for a New York City based client, managing data flows across AWS and SSIS. You will work with a team of engineers to ensure data integrity and accuracy, with a focus on eliminating duplicate records. The position demands deep hands-on expertise in AWS Glue, Lambda, and Step Functions. You will be the go-to person for source-to-target mapping and business rule implementation, with opportunities to improve existing data pipelines.
What You'll Do7
- 1Build and maintain SSIS packages for ETL pipeline development, ensuring reliable data extraction, transformation, and loading.
- 2Design and implement data pipelines using AWS Glue, Lambda, and Step Functions to process data at scale.
- 3Map source-to-target data structures, applying business rules and validation logic to guarantee data integrity.
- 4Eliminate duplicate records and resolve data quality issues across multiple systems.
- 5Optimize existing ETL workflows to improve performance and reliability.
- 6Collaborate with data engineers and analysts to support data consumption needs.
- 7Document data flows and technical specifications for future maintenance.
Requirements6
- 15+ years of hands-on experience in SSIS package development and ETL pipeline design.
- 23+ years working with AWS services including Glue, Lambda, and Step Functions.
- 3Proficiency in Microsoft Visual Studio for development and debugging.
- 4Experience with Amazon DynamoDB for data storage and retrieval.
- 5Strong understanding of source-to-target mapping and data validation techniques.
- 6Ability to implement business rules and ensure data accuracy in complex datasets.
Salary Insight
$125 - $146k per year
Location
Required Skills
Similar open positions
Explore active roles that match your skills and interests.
Mindsource Inc
VerifiedAWS Data Engineer, ETL & Data Warehousing
A doer who builds and maintains cloud data platforms for enterprise analytics in AWS. Own the full data lifecycle: ingest, transform, and model for reporting and insights. Collaborate with analysts, scientists, and leadership. Python and SQL drive every pipeline. AWS services like S3, Glue, and Redshift form the backbone. In the first year, ship a real-time streaming solution with Kinesis and Lambda. This contract-to-hire role puts you in a data-driven culture where your work directly fuels operational decisions.
Valiant Tek Group, Inc
VerifiedAWS Data Engineer, Databricks & AWS Glue
You will design, build, and optimize enterprise-scale data platforms on AWS for a Santa Monica-based client. Your work directly impacts data pipelines that process petabytes of information across Databricks and AWS Glue. You will join a team of senior engineers and collaborate with data scientists and analysts. This contract role offers the chance to own high-visibility data initiatives from day one.
TechniPros, LLC
VerifiedData Engineer, ETL & Big Data
You will own end-to-end data pipeline development and modern data infrastructure across client sites in DC, MD, PA, DE, and VA. You will design and maintain scalable ETL processes using Python, SQL, and Spark to support analytics and machine learning. You will work on a cross-functional team of data engineers and analysts, delivering data solutions at enterprise scale. This contract role offers hands-on work with modern cloud platforms like AWS and containerization with Docker.
Innova Solutions, Inc
VerifiedSenior ETL Software Engineer, Data Integration
You will own data extraction, transformation, and loading workflows for a large-scale enterprise environment. In this contract role, you will analyze business requirements, perform technical analysis on new and existing systems, and lead the transition from legacy platforms. You will collaborate with cross-functional teams to ensure data integrity and performance, and you will drive the modernization of ETL pipelines using SQL, Python, and AWS. This role stands out for its focus on legacy system migration and the chance to mentor junior engineers.
Source Infotech
VerifiedSenior Data Engineer, Python & AWS ETL
You will own the design and delivery of ETL pipelines and analytics solutions at a Tri-State enterprise, processing data at scale. You will build data models, core architecture, and transformation systems using Python, AWS, and Spark. Joining a hybrid onsite team in Parsippany NJ, you will collaborate with data scientists and business analysts. This role stands out for its full-time stability and direct impact on business intelligence outcomes.
VBest Software Inc
VerifiedData Engineer VBest Software Inc
Own large scale data infrastructure scaling across cloud platforms. Lead development of ETL pipelines using Databricks and Snowflake. Drive performance improvements through advanced analytics and automation. Shape data strategy within a fast paced environment.