Senior Medicaid Data Analyst

MasterApp Labs LLC; Richmond (VA); Hybride; USD 95 000 - 120 000; Plein temps

Avantages offerts par ce poste

401(k) matching

Dental insurance

Health insurance

Vision insurance

Résumé du poste

MasterApp Labs LLC seeks a Senior Medicaid Data Analyst for a Richmond, VA contract role with hybrid work (on-site 1 day/week after start; equipment pickup in person). You will test and validate data pipelines, write Teradata SQL queries for reports, and build dashboards with Tableau/Power BI/Looker.

Collaboration with vendors and thorough data governance are key to success. The role requires Medicaid/Medicare experience, strong SQL skills, and a degree in a related field.

Qualifications

• 5+ years of experience with Medicaid or Medicare and related policy implementations.
• 3+ years as a Data Analyst or similar role with strong SQL focus.
• Advanced SQL skills in Teradata (performance tuning, BTEQ, Teradata SQL Assistant).
• Experience writing test plans, data validation, and identifying data issues.
• Collaborates with vendors/IT teams to manage updates and resolve issues.
• Bachelor’s degree in CS, Stats, Data Analytics, Mathematics, or related field.

Responsabilités

• Data Testing & Validation: design, execute, and document test cases and scripts.
• Data Extraction & Reporting: write and optimize SQL queries to produce reports.
• Vendor Collaboration: primary contact for data warehouse vendor and issue resolution.
• Reporting & Visualization: create dashboards in Tableau, Power BI, or Looker.
• Data Governance & Documentation: maintain data definitions and schemas.
• Preferred Medicaid policy knowledge relevant to reporting requirements.

Connaissances

SQL

Data testing

Data validation

Data extraction

Data reporting

Tableau

Power BI

Looker

Vendor management

Data governance

Medicaid knowledge

Formation

Bachelor’s degree

Outils

Teradata

Teradata SQL Assistant

BTEQ

Description du poste

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Vision insurance

Title: Senior Medicaid Data Analyst

Location: Richmond, VA, (Hybrid)- 1 /day week ON SITE required once the candidate starts. Then the weekly expectation / regular team schedule can be discussed later

Position Type: Contract

Interview Mode: Either Phone or In Person

*MUST be able to pick up equipment IN PERSON. *

Key Responsibilities

• Data Testing & Validation: Design, execute, and document comprehensive test cases and validation scripts to ensure data accuracy, integrity, and consistency across data pipelines, ETL processes, and reports.
• Data Extraction & Reporting: Write, optimize, and execute complex SQL queries against our data warehouse (in Teradata) to pull scheduled and ad-hoc operational and analytical reports.
• Vendor Collaboration: Act as the primary technical point of contact for our data warehouse vendor, escalating performance bottlenecks, troubleshooting data loading issues, and tracking resolutions.
• Reporting & Visualization: Translate business requirements into intuitive, actionable data visualizations and dashboards using tools such as Tableau, Power BI, or Looker
• Data Governance & Documentation: Maintain documentation of data definitions, reporting logic, testing procedures, and data warehouse schemas to ensure organization-wide transparency.
• Preferred Experience: Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred.

Qualifications & Requirements

• Domain Knowledge: 5+ years of experience with Medicaid or Medicare. Prior experience working on federal or state legislative policy implementations (e.g., CMS rules, HR1 provisions, Medicaid expansion/unwinding efforts).
• Technical Experience: 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development.
• Technical Expertise: Advanced SQL skills specifically within Teradata environments (including performance tuning, BTEQ, and Teradata SQL Assistant).
• Testing & QA: Demonstrated experience writing test plans, performing data validation, and identifying data anomalies or discrepancies.
• Collaboration: Experience working closely with third-party vendors, IT infrastructure teams, or database administrators to manage system updates and resolve issues.
• Education: Bachelor’s degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field.

Additional skills/experience should include

• Excellent interpersonal, verbal and written communications skills, with a demonstrated ability to prepare and present reports on complex concepts and findings to all levels of the organization.
• Strong quantitative analysis skills, including working knowledge of SAS, SQL, data mining software, statistical validation techniques, predictive modeling construction and data visualization.
• Proficiency in Microsoft Office Suite, including Access, Excel, Power Point and Word.
• Demonstrated ability to plan, organize, implement, and monitor large scale/time sensitive projects; and to work collaboratively across teams.
• Must be well organized, with the ability to prioritize work and possess a great attention to detail and accuracy and an ability to complete multiple complex assignments within short time frames and with minimal direction.
• Experience working with Medicaid eligibility and enrollment data, health plans’ operations and data (encounters, claims, clinical quality, etc.) strongly preferred.
• Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred.

Required/Desired Skills

• Experience with Medicaid or Medicare or other health systems | Required | 5 |
• Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs | Required | 5 |
• Exp w/analyzing project requirements and developing detailed technical specifications | Required | 5 |
• Exp with technical developers to strategize solutions to align with business requirements | Required | 5 |
• Recent SQL writing experience | Required | 5 |
• Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions | Required | 5 |
• working knowledge of relational databases/database structures | Required | 5 |
• Requirements Traceability | Required | 5 |
• BI reporting tools | Required | 5 |
• developing test data and test scenarios | Required | 5 |
• Bachelor’s degree or equivalent work experience | Required | |

Flexible work from home options available.