SAS Programmer

Description

REQUIRED 5+ years SAS reporting experience SQL (must be able to write queries from scratch) Healthcare exp (healthcare data, members or providers side, commercial ins or medicare/Medicaid claims data) ie BCBS/Aetna/United PLUS Other reporting tools
GreenPlum
Hadoop
Tableau
EXPERIENCE NEEDED Proficient in Developing SAS Programs , Macros Including Advanced SAS Programming techniques for Data Accessing, Data cleansing, Data management, and reporting.
Experienced in extracting the data from Oracle , SQL Server databases , Green Plum and from SPDS efficiently using SAS/Access
Experienced in debugging SAS code, compiling errors, review SAS code Experience in Creating Excel reports using SAS / ODS and Report automation processes
Experienced in SDLC methodologies
Production Jobs monitoring and handling the job failures to keep all the reporting processes up and running
Flexibility in resolving the Critical Report issues for Business/Market/State to meet the stringent deadlines
Technical Skills Base SAS v9.3, SAS Macros, SAS/Access, SAS/ODS , strong in SQL Good experience in Unix and Basic Shell Scripting Knowledge in VB Scripting would be added advantage
SAS/SPDS experience would be plus
Version control tools like Team Foundation Server
Exposure to Autosys
Day to day This is the regulatory reporting team, they will use SAS to put into the reports, doing DA tasksPulling and analyzing data and run SQL, meeting with the business