NC Dept of Health and Human Services (DHHS) is seeking a senior IT Systems Analyst to perform Analytical and Technical work related to enhancements and operations of the Managed Care Transformation. This position will need to work with multiple vendors, division staff and other stakeholders to understand the requirements and providing technical support/guidance. This position involves the ability to research and analyze complex healthcare data from variety of sources to evaluate, define, design, and implement technical solutions based on the Federal and State Medicaid requirements. This position is responsible for the design and development of the interfaces across Medicaid internal and external. In addition, this position is responsible for creating and delivering reports and metrics using various SAS Business Intelligence tools utilizing data and information from NC Analytics Data warehouse. This position will also need to work with SQL queries to analyze data and create ad-hoc reports to support Business needs and requests. This involves 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. This position prefers experience working with Single Sign On applications and knowledge of State’s NCID system for login.

Skills

• Excellent written and oral communication and ability to facilitate small to large meetings Required
• Managing and Working with Multiple Vendors. Required.
• Demonstrated experience in gathering business requirements and developing of business rules and process flows. Required.
• Demonstrated proficiency working with one or more databases - Oracle, MS SQL Server.
• Experience developing SQL queries. Required
• Hands-on experience in different file transfer methodologies and different file types and layouts such as csv, txt, XML, etc.
• Proven experience delivering Business Intelligence solutions
• Knowledge of Agile Methodology
• Ability to communicate effectively and be able to work independently with minimal supervision.

Skill Matrix

• Experience working with multiple vendors Required
• Should have the capability to translate business requirements into technical solutions Required 5 Years
• Project Management Experience Required 5 Years
• Strong understanding of healthcare claims processing - Claims, Provider, Eligibility, Members Required 5 Years
• Working knowledge of Medicaid and/or MMIS Highly desired
• Proven experience delivering Business Intelligence solutions Required
• Demonstrated proficiency working with databases - Oracle (11) ,MS SQLServer etc. DB2 Required 5 Years
• Experience developing SQL queries. Required 5 Years
• SAS programming knowledge in SAS tools (Base SAS 9.4, SAS Macro, SAS BI Suite, Data Integration studio, Enterprise guide, etc.). Desired
• Proven experience delivering Business Intelligence solutions Required
• Excellent verbal and written communication skills with the ability present to both technical and business audiences. Required