AWS Data Engineer/Developer - REMOTE

AWS Data Engineer/Developer - REMOTE

08 Apr 2021
District of Columbia, Washington, 20001 Washington USA

AWS Data Engineer/Developer - REMOTE


We have an exciting opportunity with our prestigious client, an industry leading integrator who provides a wide range of services and solutions to the Federal Government. They have a long-term contract opening for an

AWS Data Engineer/Developer to work on a project that is developing enhancements to the products and infrastructure of a Federal Program aimed to help veterans obtain and retain home loans. In this role, you will work with a team to build a New Data Platform on AWS Redshift.

Bring your talent to this important Federal Agency serving over 15 million Americans. This position is located in

Washington, DC with an option to work remotely. Per our Federal Government Contract, candidates must be

U.S. Citizens and be able to pass the client's background check.


  • Implement transformation to clean the source data, including the use of ETL tooling, scripting, and data science techniques
  • Decompose data features into user stories
  • Design technical solution for features
  • Refine user stories into tasks
  • Provide research and analysis on data sources in support of data discovery and requirements elicitation
  • Monitor monthly data source replication and ETL jobs to ensure successful completion
  • Work with the System Team on any deployment or compilation issues encountered during automated deployments
  • Conduct periodic ETL data refreshes in Analytics preprod environment in support of QA and UAT
  • Provide UAT support, triage, troubleshooting, and explanations
  • Provide GitLab peer review and code merges
  • Manage code merges and deployments to preprod in support of QA activities


  • Bachelor's Degree
  • Expert level knowledge in building data warehouses
  • Deep experience resolving Data Quality issues
  • 3 years of experience with the following:
    • AWS and developing lambda functions to support data curation, notification & monitoring programs
    • Python
    • RedShift
  • 2+ years' experience in data modeling and database design, including both relational and data mart/data warehouse database design, breadth and depth in established and emerging data technologies
  • 2+ years expertise in the following sectors is required: housing and mortgage finance, Federal credit programs, and government benefit programs
  • 2+ years of ETL/Data Engineering experience
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
  • Experience with Database technology, including index strategies, performance tuning, and optimization and stored procedures
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • Strong analytic skills related to working with structured and unstructured datasets
  • A successful history of manipulating, processing, and extracting value from large, disconnected datasets
  • Strong project management and organizational skills
  • Per our Federal Government Contract, candidates must be

    U.S. Citizens and be able to pass the client's background check

Preferred Qualifications:

  • Mortgage analytics experience
  • Knowledge of both the LGY business (mortgage and loans), OIT operations, and understanding of system development life cycle preferred
  • Knowledge of Python, R, Open-Source tools
  • Experience with Sagemaker and Tensor Flow

4 Reasons to Join The Squires Group, Inc.:
1. Our Commitment to You - We offer competitive pay, multi-year projects, and a list of exciting clients.
2. Work-Life Balance - We work hard; we work smart and have quality time for family and "life."
3. Golden Rule - We treat our consultants the way we want to be treated: with integrity, professionalism, and trust.
4. We Care About You - We help you meet your career goals and continuously support your efforts in the field.

Check out our Referral Program!
The Squires Group will pay you up to $3000 for every qualified professional that you refer and we place. If you see a position posted by The Squires Group and know the perfect person for the job, please send us your referral. For more information, go to .

The Squires Group, Inc. is an Equal Opportunity/Affirmative Action Employer.



Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.