SAS Programmer

We are seeking a highly skilled SAS Programmer to join our team in Sacramento, CA. As a SAS Programmer, you will be responsible for developing and maintaining data feed processes from various data sources and transmitting data in preparation for loading into the MIS/DSS data warehouse.

• Develop and maintain data feed processes from various data sources
• Transmit data in preparation for loading into the MIS/DSS data warehouse
• Analyze DHCS warehouse requirements and research existing claim and eligible processes to develop the data feed process
• Utilize statistical tools such as SAS EG to create reports and trends from the MIS/DSS and support user requests
• Experience using Informatica to help support TMSIS and PERM reporting

• Five (5) years' experience with front-end data warehouse or similar processing which includes extracting data for large files from various sources, cleansing data, and preparing the data for loading into a data warehouse
• Five years' experience as an analyst-programmer performing various system development life cycle functions including; project planning, requirements analysis, program specifications, coding, testing, and implementation
• Experience with paid and denied claims (diagnosis codes, procedure codes, etc.) and data standards (Protected Health Information, privacy standards, HIPAA data elements, and code sets)
• Intermediate skill level with Microsoft Office Suite of tools and VISIO in facilitating written communication such as developing status reports, creating/updating technical and procedure documentation, and communication with team members, end users and stakeholders
• Experience in oral communication in a variety of situations such as interacting with the user community (e.g. State staff, vendors, and Data Center staff), making presentations, facilitating meetings and walkthroughs, and user training
• Experience transitioning program changes into production
• Experience with Medicaid, SSA, or other welfare programs specific to state and federal policies and procedures

• Two years' experience working with Business Objects
• Five years-experience working in a mainframe environment (with working knowledge of COBOL, VSAM file structures, JCL and TSO)
• Intermediate level experience with developing program specifications, pseudo code, or logic diagrams

Work Location: Sacramento, CA = 1 day per week. Telecommute = 4 days per week.

Interview Process: 2-3 rounds via video. Detailed technical interviews.