What are the responsibilities and job description for the Data/Information Architect position at Refulgent Technologies Inc.?
Job Details
Job: Data/Information Architect
Location: Columbia, SC ( Hybrid)
Specific duties include, but are not limited to:
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.
Assist in determining when reprocessing is necessary.
Support the preparation of responses to questions from CMS/Mathematica, as required.
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.
Create reports to identify potential issues in advance of monthly T-MSIS file submission.
Develop test plans for individual data quality issues; to include Unit and SIT testing.
Leverage strong analytical skills to check data quality issues, conduct root cause analysis, discuss findings with business users and coordinate with development team to resolve.
Collaborate with stakeholders at every level of the organization to prepare recommendations and detailed plans for improving T-MSIS data and ensuring compliance with federal and state regulations.
Provide support for the identification and resolution of the root cause for T-MSIS error trends.
Actively engage with internal business/technical teams to ensure consistency and improvement of data quality.
Support technical and data teams on the achievement of target T-MSIS data quality and completeness.
REQUIRED SKILLS:
Three (3) or more years of Transformed Medicaid Statistical Information System (T-MSIS) Analytic file practical experience.
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.
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).
