Previous Job
Previous
IT Lead SAS Technical Architect
Ref No.: 16-00609
Location: Raleigh, North Carolina
Client: NCDHHS-AM
Location: Raleigh North Carolina
Duration: 6 Months
Agency Interview Type: Either Phone or In Person
No New Submittals After: 05/23/2016


Job Description:
NC Dept of Health and Human Services is seeking for one Lead Business and Technology  SAS Architect to perform work related to the development of data extracts and create reports for the Transformed Medicaid Statistical Information System(TMSIS)

NC Dept of Health and Human Services (DHHS) is lead Business and Technology 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
Required / Desired
Amount
of Experience
 
Should 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 .
Desired
 
 
 
 
Questions
 
 
Description
 
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
All work must be completed on site. Do you accept this requirement?
Question 3
Please list candidate's email address HERE that will be used when submitting E-RTR.
Question 4
Please indicate how soon this candidate is available to start work. The candidate should be able to start immediately to meet the Federal mandate and schedule.
Question 5
Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?
Question 6
Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?
Question 7
Please note – that if your candidate is selected for hire, the Iran Divestment Act Certification form must be completed and uploaded to the Compliance tab as a part of the onboarding process. This form must be received within a timely manner (expectation 1 business day). Without this form, the Purchase Order cannot be generated and your candidate cannot begin work. Do you accept this requirement?