Company DescriptionSailoTech is an Enterprise Business Software (ERP, CRM, SCM, BI) consulting company with primary focus on mid-size organizations across industries. It helps its clients manage every aspect of their ERP Initiative, from strategic planning to everyday operations.Job DescriptionPosition Details:Job Title: SAS Technical ArchitectLocation: Raleigh, NCDuration: 6 Months (Strong possibilities of extensions) Short Description: SAS Architect to perform work related to the development of data extracts and create reports for the Transformed Medicaid Statistical Information System(TMSIS). Complete Description: SAS Architect to perform work related to the development of data extracts and create reports for the Transformed Medicaid Statistical Information System as per the Federal mandate. This position is responsible for the design , architect and development of the reporting datasets in SAS and other formats which includes creating and validating input files and formats as per the data mapping artifacts, architecting output datasets and validating data based on the requirements; quality assurance of data and interaction with division/federal staff, vendors and stakeholders to resolve data quality issues and manage all data extracts based on the policies and standards. This position involves the ability to research and analyze complex healthcare data from variety of sources in order to evaluate, define, design, develop, test and implement technical solutions to produce accurate data extracts/reports in the required file layout based on the Federal requirements. This position is also responsible for analyzing and data mapping utilizing data and information from data warehouse, Medicaid claims processing system (MMIS - Claims, Eligibility, provider etc.) and other division data sources using various SAS Business Intelligence tools. This position will need to work with Division staff and other stakeholders to understand the requirements and providing technical support/guidance. Knowledge and ability for utilizing secured file transfer protocols/process compliant with the defined Federal standards. Skill Assessment:- (kindly type in the years of experience you hold in the skills mentioned below)Skill Required / Desired Amount of experience Years Used Last UsedShould have the capability to translate business requirements into technical solutions Required 8 Years Should have the capability to Architect the SAS Programs and run the programs in Batch mode to create extract files for CMS. Required 8 Years Demonstrated proficiency working with databases - Oracle (11) , DB2 Required 8 Years Extensive SAS programming knowledge, SQL, Pl/Sql and other SAS tools (Base SAS 9.2, SAS BI Suite, Enterprise guide and Enterprise Miner). Required 8 Years Strong understanding of healthcare claims processing - Claims, Provider, Eligibility Required 7 Years Understanding of data modeling techniques and experience working with relational data base concepts and data Required 10 Years Hands-on experience in different file transfer methodologies and different file types and layouts Required 7 Years Working knowledge of Medicaid and/or MMIS Required 7 Years Excellent verbal and written communication skills with the ability present to both technical and business audiences. Required SAS Certification, Mainframe Skills desired not required .Additional InformationAll your information will be kept confidential according to EEO guidelines.