What are the responsibilities and job description for the Data Architect position at Advanced Automation Consulting?
Job Description
Job Description
AAC is looking for a Data / Information Architect for a position working onsite / hybrid (25% remote) in for our client located in Columbia, SC .
Scope Of the Project :
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 Client 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.
Daily Duties / Responsibilities :
- 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 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.
Required Skills :
Preferred Sills :
Company Description
Advanced Automation Consulting, Inc., headquartered in Columbia, SC, is an IT Consulting Services firm focused on the long-term success of our clients and consultants. At AAC, we never lose our intense, passionate focus on the needs of our clients. We attract and retain the best and brightest consultants and provide them with support, training, and the project discipline to ensure the success of our clients and AAC.
We operate at the highest level of integrity at all times, strive to be the Best of the Best in all that we do, and we are the Best Value service provider to our clients.
Company Description
Advanced Automation Consulting, Inc., headquartered in Columbia, SC, is an IT Consulting Services firm focused on the long-term success of our clients and consultants. At AAC, we never lose our intense, passionate focus on the needs of our clients. We attract and retain the best and brightest consultants and provide them with support, training, and the project discipline to ensure the success of our clients and AAC. We operate at the highest level of integrity at all times, strive to be the Best of the Best in all that we do, and we are the Best Value service provider to our clients.
