SAS ETL Developer (Arlington, VA)

Job Description: Position: Sr. ETL Developer, Credit Risk Analysis The ETL Developer will be a member of the Credit Risk Analysis group for E*Trade Bank, which has $30+ billion in managed consumer loans across credit cards, auto loans, and mortgage products. This person will be a key player on a fast-paced dynamic team with high visibility across departments and to senior management. The Risk Analysis group is comprised of three teams, ETL, ODS, and Analysis & Forecasting. This person will be on the ETL team and be responsible for creating/modifying SAS v9 programs to load newly acquired loans and loan updates into the SAS data warehouse. The Bank’s business intelligence reporting hinges on the loading of timely and accurate data across multiple platforms. The candidate should have experience with data warehousing schema design, data mapping from source file to target files, normalizing both continuous and categorical data, and handling slowly changing dimensions. The candidate must be familiar with ETL concepts and operations, Meta data requirements, DB2, MS Access, and Oracle database structures and extraction tools (e.g. SQL). The candidate must have advanced SAS Macro and debugging skills, equivalent to the SAS Advanced Programmer Certification credential. In addition, the candidate should have experience either working with consumer lending data or a strong understanding of consumer lending products. The person will manage a mission critical, time-sensitive process to extract, transform and load, with automated SAS code, several source systems and rapidly integrate new source systems into the process flow by working closely with the source system operators, developing consistent data definitions and a production data map. This person will also write production SAS code to load new data sources and handle variable exceptions and transforms. Required Skills: Minimum Experience: • Bachelor degree in related area (Sciences, Statistics, or Computer Science). • SAS Advanced Programming Certification or equivalent competency • 2 years experience with SAS Enterprise Guide. • Consumer Lending industry experience. • Strong time management skills in a mission critical load environment. • Strong understanding of meta-data preparation and processing. • Moderate UNIX skills including basic shell scripting in K-shell. • Strong Data Mapping experience/ experience with SCD’s. • Data warehousing/ Data mart best practices. • Strong analytical, problem solving and quantitative skills. • Excellent communication and interpersonal skills. • Ability to establish and maintain effective working relationships across business units. • Ability to maintain own work flow and meet deadlines. • Ability to analyze a situation, identify critical path and remediate the problem. • 5-10 + years of relevant work experience. • High energy self-starter with good communication skills. Duration: 12+ Months Location: Arlington VA Rate: $65-$80hr Company Name: Focus Technology Contact Person: Wayne Mercer Contact E-Mail Address: wmercer@focustech.com Company Web Site: focustech.com