Serigor Inc · 21 hours ago
Medicaid Data Systems Analyst (Hybrid)
Washington, DC
Contract
Hybrid
Senior Level
5+ years expSerigor Inc is focused on data modernization for Medicaid systems, and they are seeking a Medicaid Data Systems Analyst to lead the implementation of an Enterprise Data Catalog and manage the transition of business logic to the Azure/Databricks environment. The role involves ensuring data reliability, overseeing metadata governance, and supporting infrastructure health while collaborating with data engineering teams.
ConsultingInformation ServicesInformation Technology
Hiring Manager
Arun K.
Responsibilities
Leads the adoption or implementation of an advanced technology or platform
Expert on the functionality or usage of a particular system, platform, or technology product
Serves as a consultant to clients, guiding the efficient use or adoption of a particular IT product or platform
Creates implementation, testing, and/or integration plans
Demonstrates expertise in a particular IT platform or service, allowing for maximum IT investment
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
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
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
Qualification
Required
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
Expert T-SQL skills for deep-dive data auditing and parity testing between legacy SQL Server and Azure Synapse.-Required-5-Years
Experience with MMIS data, specifically claims (837), eligibility (270/271), and T-MSIS federal reporting.-Required-5-Years
Familiarity with TFS (for reviewing legacy logic) and Azure DevOps (for modern project tracking).-Required-5-Years
Industry certification/training in specific IT product/platform or service-Required-5-Years
Leading advanced technology projects or service projects-Required-5-Years
Hands-on experience in specific product or IT platform-Required-5-Years
Full system engineering lifecycle-Required-5-Years
Bachelor's degree-Required- -
Preferred
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
Company
Serigor Inc
Serigor provides IT Services and IT staffing to Government and Commercial enterprises of all sizes.
51-200 employees
H1B Sponsorship
Serigor Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (2)
2023 (6)
2022 (7)
2021 (5)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase