Medicaid Data Modernization Consultant

Washington, AR - USA

Hourly Salary: $ 63 - 70

Posted on: 15 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Description:

Short Description:

Client is looking for a contractor to assist in the data modernization efforts associated.

Complete Description:

1. Position Purpose

The Medicaid Data Systems Analyst is the functional anchor for the agencys data modernization. This role ensures the technical infrastructure remains trustworthy by leading the implementation of an Enterprise Data Catalog and managing the transition of business logic from TFS/SSIS to the Azure/Databricks environment. They act as the Metadata Architect ensuring that all raw MMIS schemas are translated into governed auditable and BI-ready assets.

2. Expanded Key Responsibilities

A. Data Catalog Implementation & Metadata Governance

Business Glossary Ownership: Lead the implementation of the Enterprise Data Catalog (e.g. Microsoft Purview or Unity Catalog) from a functional perspective. Define and maintain the business glossary for all Medicaid data.
Data Lineage Mapping: Document and verify end-to-end data lineagefrom the raw MMIS source table through the transformation layer in Databricks to the final PowerBI report.
Discovery & Search: Organize the catalog so that policy analysts and actuaries can easily discover Medicaid datasets understand their sensitivity (PHI/PII) and view their update frequency.

B. Infrastructure & FinOps Support

Data Reliability Engineering: Support the infrastructures health by monitoring Data Quality (DQ) dashboards. Alert the Senior Data Engineer if upstream MMIS schema changes cause data drift or pipeline failures.
FinOps Collaboration: Partner with the Senior Data Engineer to analyze cloud consumption. Identify unused or redundant datasets that can be purged or archived to optimize Azure storage and compute costs.
Infrastructure Validation: Verify that the Infrastructure as Code deployments (Managed by the Engineer) correctly apply the Row-Level Security (RLS) and masking rules defined by the Lead Architect.

C. Schema Transformation & Migration Support

Legacy-to-Cloud Logic Audit: Translate legacy SSIS logic stored in TFS into clear business requirements for the Engineer to rebuild in Azure Data Factory and Databricks.
Target Mapping: Take raw table schemas from the current MMIS and define the Target format for the Data Warehouse ensuring it meets the specific needs of modern BI tools.

CONTRACT JOB DESCRIPTION

Responsibilities:

1. Leads the adoption or implementation of an advanced technology or platform.

2. Expert on the functionality or usage of a particular system platform or technology product.

3. Serves as a consultant to clients guiding the efficient use or adoption of a particular IT product or platform.

4. Creates implementation testing and/or integration plans.

5. Demonstrates expertise in a particular IT platform or service allowing for maximum IT investment.

Minimum Education/ Certification Requirements:
Bachelors degree in Information Technology or related field or equivalent experience
Training or certification in a particular product or IT platform/service as required

Skills Matrix

Expert T-SQL skills for deep-dive data auditing and parity testing between legacy SQL Server and Azure Synapse.

Experience with MMIS data specifically claims (837) eligibility (270/271) and T-MSIS federal reporting.

Familiarity with TFS (for reviewing legacy logic) and Azure DevOps (for modern project tracking).

Industry certification/training in specific IT product/platform or service

5 yrs. leading advanced technology projects or service projects

Hands-on experience in specific product or IT platform

5 yrs full system engineering lifecycle

Bachelors degree

Certification in Data Governance (e.g. CDMP) or Cloud Fundamentals (e.g. Azure AZ-900).

Experience with Power BI or Tableau to validate that transformed data meets visualization requirements.

Hands-on experience with Microsoft Purview Collibra Informatica and Alation

Flexible work from home options available.

Compensation: $63.00 - $70.00 per hour

About Us

AHU Technologies INC. is an IT consulting and permanent staffing firm that meets and exceeds the evolving IT service needs of leading corporations within the United States. We have been providing IT solutions to customers from different industry sectors helping them control costs and release internal resources to focus on strategic issues.

AHU Technologies INC. was co-founded by visionary young techno-commercial entrepreneurs who remain as our principal consultants. Maintaining working relationships with a cadre of other highly skilled independent consultants we have a growing number of resources available for development projects. We are currently working on Various projects such as media entertainment ERP Solutions data warehousing Web Applications Telecommunications and medical to our clients all over the world.

Required Experience:

Contract

Job Description:Short Description:Client is looking for a contractor to assist in the data modernization efforts associated. Complete Description:1. Position PurposeThe Medicaid Data Systems Analyst is the functional anchor for the agencys data modernization. This role ensures the technical infrastr...