Senior Data Analyst (HCA/MAD #30810)

New Mexico Department of Justice; Santa Fe (NM); On-site; USD 90,000 - 120,000; Full time

Job summary

The Senior Data Analyst at New Mexico Department of Justice will ensure accuracy and timeliness of federally required Medicaid reporting, support oversight of MCOs, and help strengthen compliance operations across agencies.

You will manage data, coordinate complex reporting cycles, develop dashboards in Power BI, mentor staff, and communicate risks to leadership, ensuring state and CMS requirements are met with defensible, data-driven decisions.

Qualifications

• Experience with databases, data extraction, data migration, and data validation.
• Strong knowledge of SQL, databases, data warehouses, cloud technologies, and Power BI.
• Proficiency in writing and optimizing SQL queries; Python or PowerShell experience.

Responsibilities

• Federal Reporting Coordination and Compliance Oversight: develop procedures and project plans for Medicaid reporting.
• Policy and Regulatory Alignment: analyze CMS rules and ensure state implementation timelines.
• Operational Support, Data Management, and Risk Tracking: maintain shared workspaces and dashboards.
• Quality Assurance: conduct QA reviews and provide training and mentorship.
• Communicate with contractors, MCOs, and internal staff to support reporting and coordination.

Skills

SQL

Data analysis

Power BI

Python

PowerShell

Education

Bachelor's degree or equivalent

Tools

SQL tools

Job description

Press Control+M to start dragging object

For more Job Requirements & Classification Description:

Interviews are anticipated to be conducted within two weeks of closing date.

This job posting may be used to fill multiple vacancies.

The Health Care Authority (HCA) participates in E-Verify and will verify employment eligibility upon hire.

Our Vision

• Every New Mexican has access to affordable health care coverage through a coordinated and seamless health care system.

Our Mission

• We ensure that New Mexicans attain their highest level of health by providing whole-person, cost-effective, accessible, and high-quality health care and safety-net services.

Our Goals

• Leverage purchasing power and partnerships to create innovative policies and models of comprehensive health care coverage that improve the health and well-being of New Mexicans and the workforce.
• Achieve health equity by addressing poverty, discrimination, and lack of resources, building a New Mexico where everyone thrives.
• Implement innovative technology and data-driven decision-making to provide unparalleled, convenient access to services and information.
• Build the best team in state government by supporting employees continuous growth and wellness.

Why does the job exist?

The Senior Data Analyst will:

• Ensure the accuracy, timeliness, and compliance of federally required Medicaid reporting and support federal reporting oversight of Managed Care Organizations (MCO);
• Provide structured project management, data analysis, documentation, and recommendations to the Compliance and Special Projects Officer to strengthen compliance operations, improve reporting quality, and support alignment with federal and state regulatory requirements;
• Directly support the agency's responsibility to administer Medicaid in accordance with Centers for Medicare and Medicaid Services (CMS) rules, federal reporting standards, and state regulatory requirements;
• Coordinate complex reporting cycles, validate data, monitor compliance implementation, and ensure consistency across contract, policy, and regulatory materials;
• Reduce audit risk, enhance transparency, and improve the agency's ability to make timely, defensible decisions;
• Strengthen cross bureau coordination, support contractor and MCO engagement, and contribute to statewide operational readiness.

How does it get done?

The Senior Data Analyst is responsible for:

• Federal Reporting Coordination and Compliance Oversight:
  • Developing, maintaining, and executing procedures and project plans to coordinate all federally required Medicaid reporting, including 1115 Demonstration Reports, NAAAR, and MCPAR;
  • Establishing reporting timelines, templates, workflows, and cross bureau coordination processes to ensure complete, accurate, and timely submissions;
  • Monitoring reporting progress, identifying risks or delays, and escalating issues to the Compliance and Special Projects Officer with recommended actions;
  • Providing weekly written updates summarizing successes, risks, decisions needed, and percent complete status for each reporting project.
• Policy and Regulatory Alignment:
  • Researching federal rules and analyzing alignment across NMAC, Medicaid Contract, Policy Manual, and Letters of Direction (LOD);
  • Identifying inconsistencies and coordinating resolution with responsible bureaus;
  • Tracking and documenting state implementation timelines for new CMS Final Rule requirements and report progress to leadership;
  • Maintaining organized documentation and version control for all policy alignment activities.
• Operational Support, Data Management, and Risk Tracking:
  • Building and maintaining shared workspaces to support version control, document organization, and cross team collaboration;
  • Leading development of internal and external PowerPoint presentations to support reporting, compliance updates, and leadership briefings;
  • Documenting identified risks and escalating issues requiring decisions or additional resources;
  • Combining MCO reports, validating data, and contributing to dashboards and ad hoc reporting to support bureau and division leadership;
• Quality Assurance:
  • Conducting quality assurance reviews of report reviewer findings to ensure consistency in analysis, rejections, and documentation;
  • Preparing summary reports for the Compliance and Special Projects Officer;
  • Providing training, mentoring, and technical assistance to new or existing staff as assigned;
  • Communicating with state contractors, MCOs, and internal staff to support reporting, data validation, and operational coordination.
• Completing additional assignments as directed to support bureau and division priorities.

Who are the customers?

• Compliance Unit and Compliance leadership;
• Medical Assistance Division (MAD) program staff;
• Health Care Authority (HCA) leadership;
• Centers for Medicare and Medicaid Services (CMS);
• Internal and external stakeholders involved in compliance activities and regulatory coordination.

Ideal Candidate

The Ideal Candidate has:

• Experience with databases, data extraction, data migration, and data validation to ensure accurate and reliable data;
• Strong knowledge of SQL, databases, data warehouses, cloud technologies, and Power BI. Ability to extract, analyze, and transform data and create reports and dashboards to support business decisions;
• Proficiency in writing and optimizing SQL queries and working with tools such as Python or PowerShell. Experience with data models, database schemas, and relationships, along with creating visualizations and dashboards in Power BI.

Bachelor's degree and two (2) years of experience directly related to the position in research, statistics, computer science, data analysis, accounting, auditing, finance, economics, business, public administration, budgeting, management, and/or systems analysis or related professional certification as determined by the hiring agency. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling six (6) years may substitute for the required education and experience.

Employment Requirements

Must possess and maintain a valid Driver's License.
Must obtain a Defensive Driving Certification.

Working Conditions

Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage with extended periods of sitting. Some standing, bending and reaching may be required. Must be able to lift 25lbs.

Supplemental Information

Do you know what Total Compensation is? Click here

For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.

Bargaining Unit Position

This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.