Data Information Architect

Date Posted: 01/30/2025

Hiring Organization: Rose International

Position Number: 477386

Job Title: Data Information Architect

Job Location: Columbia, SC, USA, 29202

Work Model: Hybrid

Employment Type: Temporary

Estimated Duration (In months): 13

Min Hourly Rate($): 65.00

Max Hourly Rate($): 70.00

Must Have Skills/Attributes: Data Analysis, Editing, ETL, Medicaid, Microsoft Excel

Job Description

***Only qualified Data/Information Architect candidates located in the Columbia, SC area to be considered due to the position requiring an onsite presence***

REQUIRED EDUCATION:

• Bachelor’s degree in a science or technical field

PREFERRED SKILLS:

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

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)

The Medicaid Management Information System (MMIS), Member Management Systems, and Business Intelligence System (BIS) are critical systems to our business. The Data/Information Architect-Advanced will be assigned to projects for the CLIENT, the Medicaid Agency for client 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

CLIENT 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).

Objectives to Be Fulfilled by Candidate:

This position is primarily involved in the development and day-to-day operations of producing submissions to the Transformed Medicaid Statistical Information System, or T-MSIS. The position regularly works with other staff and outside contractors to write queries and other programming to investigate internal data to map to federal standards. The goal will be to improve data quality in the monthly submissions, as well as document changes that occur to the process used to build the submissions.

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

• 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

• 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

• Provide support to operational and technical teams for auditing or inquiries

• 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

Start date: 2/25/2025

Work Location: Columbia, SC

Interview type: Remote

Remote Work availability: 25%

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).