Data Reporting & UAT Analyst, Richmond, VA, US

Intellibee; Richmond (VA); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

Future Planning

GC Assistance

Job summary

IntelliBee in Richmond, VA is seeking a Data Reporting & UAT Analyst to review design documents, map data between interfaces, assist with test plans, and demonstrate solutions to internal teams and stakeholders. You will work with Business, QAs, and Dev to track issues end-to-end and ensure timely resolutions and accurate data ownership.

The ideal candidate has 5+ years in Medicaid/Medicare, 3+ years as a Data Analyst with SQL in Teradata, and experience creating dashboards in Tableau, Power BI,

Qualifications

• 5+ years of Medicaid/Medicare experience.
• 3+ years as a Data Analyst or similar role with a focus on data testing and SQL development.
• Advanced Teradata SQL skills including performance tuning and Teradata SQL Assistant.
• Experience writing test plans and performing data validation.
• Collaborative experience with vendors and IT teams.

Responsibilities

• Design, execute, and document test cases to ensure data accuracy across data pipelines, ETL processes, and reports.
• Write, optimize, and execute SQL queries against our data warehouse (Teradata) to pull scheduled and ad-hoc reports.
• Act as the primary technical contact for the data warehouse vendor and track resolutions and bottlenecks.
• Translate business requirements into dashboards using Tableau, Power BI, or Looker.
• Maintain data definitions, reporting logic, and warehouse schemas to ensure transparency.
• Experience with Medicaid policy/regulatory reporting preferred.

Skills

Medicaid/Medicare experience

SQL development

Data testing & QA

Data extraction & reporting

Vendor collaboration

Communication & collaboration

Education

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

Tools

Teradata SQL Assistant

Tableau

Power BI

Looker

Job description

Data Reporting & UAT Analyst

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: 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.

Skill Matrix:

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

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.