Vacancy expired!
Overview
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
- 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
- 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
Vacancy expired!