UAT Analyst

Akaasa Technologies; Virginia; Presencial; USD 75 000 - 115 000; Tempo integral

Resumo da oferta

Akaasa Technologies is seeking an DMAS Data Reporting and UAT Analyst to support data testing, extraction, and reporting for Medicaid-related datasets near Richmond, VA. The role focuses on validating data across pipelines, coordinating with vendors, and building stakeholder dashboards.

Responsibilities include writing complex SQL in Teradata, validating data quality, and contributing to test plans and go-live support with cross-functional teams.

Qualificações

• Domain knowledge: 5+ years in Medicaid or Medicare with regulatory reporting exposure.
• Technical: 3+ years as Data Analyst/QA with strong SQL and data testing.
• Testing: Experience writing test plans and validating data for pipelines and reports.
• Experience interacting with vendors and stakeholders to map requirements.

Responsabilidades

• Data Testing & Validation: design, execute, document test cases for data pipelines and reports.
• Data Extraction & Reporting: write and optimize SQL queries in Teradata for reports.
• Vendor Collaboration: liaise with data warehouse vendor on performance and data loads.
• Reporting & Visualization: create dashboards in Tableau/Power BI/Looker from business requirements.
• Data Governance & Documentation: maintain data definitions and testing docs.

Conhecimentos

SQL development

Data testing

Data validation

ETL processes

Data visualization

Stakeholder communication

Medicaid knowledge

Formação académica

Bachelor's degree in CS/Stats/Data Analytics

Ferramentas

Teradata

SAS

Tableau

Power BI

Looker

Teradata SQL Assistant

Descrição da oferta de emprego

DMAS Data Reporting and UAT Analyst

1 /day week ON SITE required once the candidate starts. Only looking for candidates within 50 mile radius of Richmond, VA. This role will review the Design documents, proactively identify requirement gaps and issues, map data between interface systems, assist lead analyst in projectcollaboration, 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

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.