Previous Job
Advanced SAS Programmer / SAS Data Integration Developer
Ref No.: 18-01446
Location: Ellensburg, Washington
Position Type:Contract
Experience Level: 7 Years
Start Date / End Date: 03/05/2018 to 07/31/2018
Must have Data Modeling and Data Warehousing

Client Location Ellensburg, WA  Working Location Onsite Citizenship Requirements  US Citizen, Green Card, Canadian TN, H1B's 
DESCRIPTION and RESPONSIBILITIES SAS is seeking a full-time SAS Advanced Programmer / Data Integration developer to work with our client, an Education client in Ellensburg, WA.  
This is a Senior SAS Advanced developer opportunity responsible for ETL development of SAS processes/code from different sources of data (PeopleSoft) to a MS-SQL Server data warehouse. Consultant must be an expert SAS developer (with ETL and Data Warehousing experience) optimizing SAS Code.  
Consultant must have strong Data Warehousing and Data Modeling experience along with Advanced SAS programming experience.  Data Warehousing skills include: dimensional data modeling, applying business rules, do data mappings from source to target.  ETL processes will be developed to extract data from PeopleSoft, SAS ETL processes to apply the business rules and data mappings to load the standardized data into MS-SQL Server, possibly creating tables in MS-SQL Server as well).   
QUALIFICATIONS – ESSENTIAL • Bachelor of Science in computer science or related field • PeopleSoft Student Information System (SIS) experience is preferred (Extracting data from PeopleSoft)  • MS-SQL Server experience is a must  • Must have robust Data Warehousing experience and SAS ETL experience  • Must have strong Data Modeling experience (Dimensional Data Modeling experience)