Data REporting & UAT Analyst

Global Sumi Technologies Inc.,; Richmond (VA); On-site; USD 75,000 - 110,000; Full time

Job summary

Global Sumi Technologies Inc. in Richmond, VA seeks a Data Reporting & UAT Analyst to design data tests, validate pipelines, and generate compliant reports.

You will write complex SQL against Teradata, collaborate with the data warehouse vendor, and create dashboards with Tableau, Power BI, or Looker. The role requires 5+ years in Medicaid/Medicare contexts, strong SQL and data validation skills, and a Bachelor’s degree in a related field.

Qualifications

• 5+ years of experience with Medicaid or Medicare and awareness of CMS rules.
• 3+ years as a Data Analyst, Data Quality Analyst, or similar with SQL focus.
• Expertise in Teradata environments, including performance tuning and tooling.
• Experience writing test plans, validating data, and spotting anomalies.
• Collaborates with vendors and IT teams on data-related updates.
• Bachelor’s degree in a relevant field.

Responsibilities

• Design and execute test cases and validation scripts for data pipelines.
• Write and optimize SQL to pull reports from the data warehouse.
• Serve as primary contact for data warehouse vendor and issue resolution.
• Translate requirements into dashboards using Tableau/Power BI/Looker.
• Document data definitions, reporting logic, and warehouse schemas.
• Coordinate with stakeholders on regulatory reporting needs.

Skills

SQL

Data testing

Data validation

Data analysis

Collaboration

Education

Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or related field

Tools

Teradata

BTEQ

Teradata SQL Assistant

Tableau

Power BI

Looker

Job description

Data Reporting & UAT Analyst

Richmond, VA

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.