JAD Sessions Relational Database Requirements Traceability BI Reporting Bachelors

COOLSOFT; Richmond (VA); Hybrid; USD 83,000 - 124,000; Part time

Benefits offered by this job

Hybrid work model

On-site 1 day/week

Job summary

COOLSOFT is seeking a Data Analyst for a contract role in Richmond, VA, focused on Medicaid/Medicare data, SQL development, and test planning. You will review designs, map data between systems, and collaborate with stakeholders to validate data and build reports.

Responsibilities include SQL data extraction, data governance, and creating dashboards using Tableau/Power BI. On-site requirements include some days per week, with hybrid work options and client coordination.

Qualifications

• 5+ years of Medicaid or Medicare experience.
• 3+ years as a Data Analyst or similar role with focus on data testing and SQL development.
• Advanced SQL skills in Teradata (including performance tuning, BTEQ, Teradata SQL Assistant).
• Ability to write test plans and perform data validation.
• Bachelor’s degree in CS/Statistics/Data Analytics/Math or related field.

Responsibilities

• Review design documents and map data between interfaces.
• Design and execute data validation and test plans across ETL and reports.
• Write complex SQL queries for data extraction and reporting.
• Collaborate with vendors and IT teams to resolve data issues.
• Develop workflows and document data warehouse schemas.
• Create dashboards and visualizations to meet business needs.

Skills

Medicaid/Medicare experience

SQL development

Data testing/QA

Data analysis

Vendor collaboration

Dashboard tools

Education

Bachelor's degree in CS/Statistics/Data Analytics/Math

Tools

Teradata

BTEQ

Looker

Tableau

Power BI

SAS

Job description

JAD Sessions Relational Database Requirements Traceability BI Reporting Bachelors

Requirement id 159297

Job title Analyst

Job location in Richmond, VA

Skills required Medicaid Or Medicare, Technical Solution, Technical Developer, JAD Sessions Relational Database Require

Open Date 09-Oct-2026

Close Date

Job type Contract

Duration 8 Months

Compensation DOE

Status requirement ---

Job interview type ---

Job Description Analyst: Medicaid Or Medicare, Technical Solution, Technical Developer, JAD Sessions Relational Database Require

Start date: 11/2/2026

End Date : 06/30/2027

Submission deadline: 10/16/2026

Client Info: DMAS

Note:

• Hybrid
• Either Phone or In Person

Description:

PLS NOTE: If selected, some ON SITE work is required. Right now, they anticipate 1 /day week ON SITE required once the candidate starts. Then the weekly expectation / regular team schedule can be discussed later.

MUST be able to pick up equipment IN PERSON. **Parking is NOT provided for contractors

ABOUT THE ROLE

This role will review the Design documents, proactively identify requirement gaps and issues, map data between interface systems, assist lead analyst in project collaboration, documentation and coordination, review and contribute to the test plans, work with stakeholders to Build Test Scenarios, provide demonstrations to Internal teams and Project Stakeholders, work closely with Business, QAs, Dev team on project related pre and post go live issues, develop workflows, provide solutions, track issues end to end, ensure timely resolutions and accurate delegation of ownership.

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: Bachelors 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, Powe

EOE Protected Veterans/Disability