Medicaid Data Systems Analyst (793450) at Derex Technologies Inc

Washington, District of Columbia, United States -

Full Time

Start Date

Immediate

Expiry Date

04 May, 26

Salary

0.0

Posted On

03 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Catalog Implementation, Metadata Governance, Data Lineage Mapping, Data Quality, Cloud Consumption Analysis, Infrastructure Validation, Schema Transformation, Azure, Databricks, PowerBI, SSIS, TFS, Business Requirements, Data Warehouse, Business Intelligence, Data Engineering

Industry

IT Services and IT Consulting

Description

Company Description Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America. With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies. Job Description Medicaid Data Systems Analyst (793450) Interview Type : In Person Location : 441 4th st new Washington DC Work type : Hybrid 1. Position Purpose The Medicaid Data Systems Analyst is the functional anchor for the agency’s 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 lineage—from 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 infrastructure’s 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: Bachelor’s degree in Information Technology or related field or equivalent experience Training or certification in a particular product or IT platform/service, as required. Regards, Manoj Derex Technologies INC Contact : 973-834-5005 Ext 206 Additional Information All your information will be kept confidential according to EEO guidelines.

Responsibilities

The Medicaid Data Systems Analyst leads the implementation of an Enterprise Data Catalog and manages the transition of business logic to the Azure/Databricks environment. They ensure data reliability and support infrastructure health while translating legacy logic into business requirements.