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.
Responsibilities
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
Qualifications
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 https://bit.ly/35C7diT .
The Squires Group, Inc. is an Equal Opportunity/Affirmative Action Employer.