Excelraise, LLC is a leading provider of full-service IT solutions and a talent management company headquartered in Denver, CO. At Excelraise, we specialize in IT staffing solutions tailored for government and federal clients across the USA.

Excelraise, LLC values your referrals! Refer qualified candidates for our open Job Postings and earn a generous REFERRAL BONUS for successful placements. Submit referrals here: Excelraise Referral Program.

Excelraise, LLC is seeking an Data / Information Architect (MMIS, Healthcare systems, TMSIS) for our client in Columbia, SC.

***This is 25% Remote Work***

SCDHHS is seeking a Data/Information Architect – Advanced to assist with constructing T-MSIS data layouts and reports to submit to the Centers for Medicare and Medicaid Services (CMS). The Data/Information Architect-Advanced will be assigned to projects for the South Carolina Department of Health and Human Services (SCDHHS), the Medicaid Agency for SC working on the Transformed Medicaid Statistical Information System (T-MSIS) data. Candidates who enjoy working with data on complex, change-oriented projects will find this position attractive

Responsibility:

• Utilize Data Warehouse and other relational databases, using BI Query or SQL, to perform investigative studies to identify errors or weaknesses in T-MSIS-processed data.
• Document current and change states of SC TMSIS mapping and reporting
• Identify specific problems and sources of unusual variations in processed results.
• Assist in determining when reprocessing is necessary.
• Support the preparation of responses to questions from CMS/Mathematica, as required.
• Investigate alternative data mapping options. when necessary.
• Map and develop missing values in T-MSIS data.
• Test recent changes to the extract process.
• Monitor updates on CMS websites related to T-MSIS and communicate relevant information to leadership.
• Prepare Source-To-Target (S2T) revisions, as required, from changes or additions to the extract process utilized for TMSIS.
• Perform regular maintenance and update functions as required.

Required skills:

• Three (3) or more years of Transformed Medicaid Statistical Information System (T-MSIS) Analytic file practical experience.
• Quantitative data analysis skills for analyzing claims and encounter data.
• Analysis and problem-solving skills to resolve operational problems and improve reporting performance.
• Ability to summarize technical claim and complex clinical information and explain it to less-technical team members.
• Working knowledge of both MMIS and Healthcare systems
• Comprehensive knowledge in ETL mapping design, coding and implementing the client business logics.
• Practical experience with documenting data mapping and transformation of data sources for consolidated federal reporting.
• Ability to Identify specific problems and sources of unusual variations in processed results of data.
• Ability to work calmly under pressure, Strong character, Team Player, Flexible and able to manage client relationships
• Strong communicator; including e-mail, phone and in-person.
• Microsoft Word (creating, editing, and saving documents)
• Microsoft Outlook (email and calendar management)
• Microsoft PowerPoint (creating, editing and presenting slide decks)
• Microsoft Excel (filtering, sorting and editing data in spreadsheets, formulas, and creating pivot tables).

Preferred skills:

• In-depth knowledge and technical understanding of the various segments of healthcare EDI formats.

Required education:

• Bachelor’s degree in a science or technical field