Demo
Salary Resume Critique Job Openings

AWS Data Migration Specialist

Top Prospect Group
Falls, VA Full Time
POSTED ON 12/19/2025
AVAILABLE BEFORE 1/19/2026

Job Details

Looking to make a real impact with your cloud data engineering skills? Join a cutting-edge project modernizing a massive 28TB data warehouse for a federal client remote flexibility included.

Contract

Hybrid or Remote-VA

$60-72/hr

Data engineering, AWS migrations, converting SQL queries to Redshift, data governance, data validation, ETL pipelines, data warehouse, Python/Pyspark

We are seeking an AWS Data Migration Specialist to support a major data migration and transformation initiative. The ideal candidate will have extensive experience in migrating on-premise SQL Server data warehouses to AWS Redshift and leading enterprise-scale ETL/data quality projects.

You will be working with a 28 TB data warehouse, helping modernize infrastructure, validate data integrity, and ensure high performance across cloud data systems.

Key Responsibilities:

  • Design, implement, and optimize ETL pipelines for large-scale data ingestion, transformation, and loading into AWS Redshift.

  • Migrate and convert complex SQL Server queries to Redshift-compatible SQL.

  • Perform data validation, cleansing, and reconciliation to ensure data quality and governance standards.

  • Collaborate with cross-functional teams to gather requirements and translate them into scalable data solutions.

  • Support performance tuning, troubleshooting, and optimization in Redshift and related AWS services.

  • Develop and maintain technical documentation for data processes, pipelines, and troubleshooting guides.

  • Enforce and enhance data governance practices across the environment.

Required Experience and Skills:

  • 7 years of experience in data engineering or a related role.

  • Proven experience with SQL Server to Redshift migration projects.

  • Hands-on expertise in AWS Redshift, SQL, ETL tools (e.g., AWS Glue, Apache Airflow), and Python/PySpark.

  • Deep understanding of data modeling, query optimization, and performance tuning in large datasets.

  • Strong knowledge of data warehousing concepts (e.g., star/snowflake schemas).

  • Experience with data quality, validation, and data governance frameworks.

  • Familiarity with data tools like Apache Kafka, Fivetran, or similar.

  • Ability to troubleshoot complex data issues and optimize large-scale pipelines.

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.

Salary : $60 - $72

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a AWS Data Migration Specialist?

Sign up to receive alerts about other jobs on the AWS Data Migration Specialist career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$91,609 - $116,575
Income Estimation: 
$115,838 - $142,817
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$168,522 - $211,152
Income Estimation: 
$189,259 - $248,928
Income Estimation: 
$71,122 - $96,652
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$143,391 - $179,890
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Top Prospect Group

Production Inspector
Apply
  • Top Prospect Group Manchester, NH
  • Job Title: Production Quality Inspector – Medical Device Manufacturing Location: Manchester, NH Hourly Rate: $24.00 – $25.00 (depending on experience) Type... more
  • 4 Days Ago
Paycom Implementation
Apply
  • Top Prospect Group Nashua, NH
  • Overview We are seeking a Paycom Implementation Specialist to lead and support end-to-end implementations of the Paycom HCM platform for new and existing c... more
  • 4 Days Ago
AVP Security Operations
Apply
  • Top Prospect Group New Haven, CT
  • Lead and shape the cybersecurity strategy for a regulated financial organization where your expertise directly protects critical systems, data, and members... more
  • 4 Days Ago
Toolmaker
Apply
  • Top Prospect Group Orange, CT
  • Job Title: CNC Toolmaker Location: Orange, CT Onsite Duration: Direct Hire Salary: $ hour DOE Plus OT and Bonus Eligible Plus Excellent Benefits Responsibi... more
  • 4 Days Ago
View More Jobs at Top Prospect Group

Not the job you're looking for? Here are some other AWS Data Migration Specialist jobs in the Falls, VA area that may be a better fit.

Data Migration Specialist
Apply
  • Capgemini Mc Lean, VA
  • Capgemini Government Solutions (CGS) is seeking a highly motivated Data Migration Specialist with strong work behaviors and extensive experience as a Data ... more
  • 10 Days Ago
Cloud Architect IV- AWS Migration Specialist
Apply
  • GAMA-1 Technologies Silver, MD
  • Supervisory responsibilitiesNone Essential functionsReasonable accommodations may be made to enable individuals with disabilities to perform these essentia... more
  • 19 Days Ago
View More Jobs

AI Assistant is available now!

Feel free to start your new journey!