Datawarehouse Developer Job at Amtec Enterprise - 1, Falls Church, VA

dmZBdGxVaG5vTi9GVS9xS3dFV3NYOHRWZmc9PQ==
  • Amtec Enterprise - 1
  • Falls Church, VA

Job Description

Job Description

Job Description

Job Title: Datawarehouse Developer/Engineer
Location: Falls Church, VA 22042
Duration: 6 Months
Work Schedule: 9/80
Pay: $74.54/hr

US Citizenship or Green Card required

About the Role

We’re seeking an experienced Data Warehouse Developer/Engineer to design, develop, and optimize large-scale data systems. In this role, you’ll focus on migrating data from a legacy system to Amazon Redshift  cloud-based data warehouse. You'll also build robust ETL pipelines, develop data models, and ensure data quality across multiple cloud and on-prem environments. You’ll collaborate closely with cross-functional teams, data scientists, analysts, and business stakeholders to deliver high-impact data solutions.

Responsibilities

  • Design and implement data pipelines to ingest, extract, transform, load (ETL) data and store large datasets from various sources 
  • Build and maintain data warehouses, including data modeling, data governance, and data quality o Ensure data quality, integrity, and security by implementing data validation, data cleansing, and data governance policies 
  • Optimize data systems for performance, scalability, and reliability 
  • Collaborate with customers to understand their technical requirements and provide guidance on best practices for using Amazon Redshift 
  • Work with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver data solutions 
  • Provide technical support for Amazon Redshift, including troubleshooting, performance optimization, and data modeling 
  • Identify and resolve data-related issues, including data pipeline failures, data quality issues, and performance bottlenecks 
  • Develop technical documentation and knowledge base articles to help customers and AWS engineers troubleshoot common issues

Required Qualifications

  • Bachelor's or Master's degree in Computer Science or a related field, with at least 6 years of experience in Information Technology
  • Proficiency in one or more programming languages (e.g., Python, Java, Scala)
  • 8+ years of experience in data engineering, with a focus on designing and implementing large-scale data systems 
  • 5 + years of hands-on experience in writing complex, highly-optimized queries across large data sets using Oracle, SQL Server and Redshift.
  • 5 + years of hands-on experience using AWS Glue, python/pyspark to build ETL pipelines in a production setting, including writing test cases
  • Strong understanding of database design principles, data modeling, and data governance
  • Proficiency in SQL, including query optimization, indexing, and performance tuning
  • Experience with data warehousing concepts, including star and snowflake schemas
  • Strong analytical and problem-solving skills, with the ability to break down complex problems into manageable components o Experience with data storage solutions such as relational databases (Oracle, SQL Server), NoSQL databases, or cloud-based data warehouses (Redshift)
  • Experience with data processing frameworks such as Apache Kafka, Fivetran o Experience in building ETL pipelines using AWS Glue, Apache Airflow, and programming languages including Python and PySpark
  • Understanding of data quality and governance principles and best practices o Experience with agile development methodologies such as Scrum or Kanban

Preferred Skills

  • Experience with Dataiku 
  • Experience with building reports using PowerBI and Tableau 
  • Experience with Alteryx 
  • Relevant cloud certifications (e.g., AWS Certified Data Analytics - Specialty) 
  • Experience with AWS services and best practices

Education Preferred

  • Bachelor's or Master's degree in Computer Science or a related field, with at least 8 years of experience in Information Technology

Additional Information:

  • 100% Remote or Hybrid work arrangement, with occasional visits to the office 

Job Tags

Work at office, Remote work,

Similar Jobs

Alpha-e Barcode Solutions Pvt. Ltd.

Digital Marketing & Content Writer Job at Alpha-e Barcode Solutions Pvt. Ltd.

 ...Google Analytics, Google Ad words and other relevant sites to conduct performance reports regularly, Technical Content Writer # Researching and writing high-quality content like product descriptions, user manuals, website content etc. # Produce well-researched... 

Nationwide Mutual Insurance Company

Technology Innovation Consultant Job at Nationwide Mutual Insurance Company

 ...technical teams.Provide holistic technical guidance, ensuring optimal technology integration and alignment with department goals.Support...  ...and citizen-led development.**Job Description Summary** As a Consultant, you will be responsible for providing subject matter expertise... 

Piedmont

Non-Invasive Cardiology Job at Piedmont

Description: Are you interested in working at a nationally recognized Best Places to Work? Here at Piedmont Heart Institute, we are looking for a BC/BE Non-Invasive General Cardiologist for our Piedmont Eastside Hospital location. We are targeting a well-trained physician...

Wegmans Food Markets

Restaurant Dishwasher Job at Wegmans Food Markets

 ...Schedule: Part time Availability: Afternoon, Evening (Including Weekends). Age Requirement: Must be 18 years or older Location: Pittsford, NY Address: 3220 Monroe Ave Pay: $17 - $17.50 / hour Job Posting: 11/17/2025 Job Posting End: 12/17/2025... 

MDS Communications

Entry Level Fundraiser Job at MDS Communications

Job Description MDS Communications is looking to hire Call Center Representatives ! Are you seeking a job with real purpose -where your efforts help people in need and support causes you care deeply about? As a Communication Specialist at MDS Communications, you...