← Back to jobsJob ID col-cmwf8nn7f0dyj89hqhlcetu9h

HCL Global Systems IncPosted 8 days ago

DMAS - Data Reporting & UAT Analyst

Full-time
Hybrid
5+ years
Competitive
Posted 8 days ago

SCC is hiring a DMAS Data Reporting & UAT Analyst to validate and report on data across its data warehouse, pipelines, and reports. The role develops SQL-based reports and visualizations, coordinates with vendors and project stakeholders, and supports testing, documentation, and issue resolution.

Consulting

Posted
8 days ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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
  • 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

Qualifications

  • 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)
  • 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development
  • Advanced SQL skills specifically within Teradata environments (including performance tuning, BTEQ, and Teradata SQL Assistant)
  • Demonstrated experience writing test plans, performing data validation, and identifying data anomalies or discrepancies
  • Experience working closely with third-party vendors, IT infrastructure teams, or database administrators to manage system updates and resolve issues
  • Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field
  • 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 with Medicaid or Medicare or other health systems
  • Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs
  • Exp w/analyzing project requirements and developing detailed technical specifications
  • Exp with technical developers to strategize solutions to align with business requirements
  • Recent SQL writing experience
  • Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions
  • working knowledge of relational databases/database structures
  • developing test data and test scenarios
  • Bachelor's degree or equivalent work experience

Preferred

  • Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred
  • Experience working with Medicaid eligibility and enrollment data, health plans' operations and data (encounters, claims, clinical quality, etc.) strongly preferred

Required skills

BTEQData Testing and ValidationMedicaid and MedicareMicrosoft AccessMicrosoft ExcelMicrosoft PowerPointMicrosoft WordPredictive ModelingRelational DatabasesRequirements AnalysisRequirements GatheringRequirements TraceabilitySASSQL

Full job description

SCC is hiring a DMAS Data Reporting & UAT Analyst to validate and report on data across its data warehouse, pipelines, and reports. The role develops SQL-based reports and visualizations, coordinates with vendors and project stakeholders, and supports testing, documentation, and issue resolution.

Consulting

  • Human Resources
  • Information Technology
  • Software
  • B2B
  • Staffing Agency

Responsibilities

  • 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
  • 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

  • Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred
  • Experience working with Medicaid eligibility and enrollment data, health plans' operations and data (encounters, claims, clinical quality, etc.) strongly preferred

Benefits

  • Hybrid work: remote and on-site in Richmond, with an anticipated one day per week on-site once the candidate starts; the regular team schedule can be discussed later

Qualifications

  • 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)
  • 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development
  • Advanced SQL skills specifically within Teradata environments (including performance tuning, BTEQ, and Teradata SQL Assistant)
  • Demonstrated experience writing test plans, performing data validation, and identifying data anomalies or discrepancies
  • Experience working closely with third-party vendors, IT infrastructure teams, or database administrators to manage system updates and resolve issues
  • Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field
  • 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 with Medicaid or Medicare or other health systems
  • Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs
  • Exp w/analyzing project requirements and developing detailed technical specifications
  • Exp with technical developers to strategize solutions to align with business requirements
  • Recent SQL writing experience
  • Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions
  • working knowledge of relational databases/database structures
  • Requirements Traceability
  • BI reporting tools
  • developing test data and test scenarios
  • Bachelor's degree or equivalent work experience
  • Working knowledge of relational databases/database structures
  • Developing test data and test scenarios
  • Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred
  • Experience working with Medicaid eligibility and enrollment data, health plans' operations and data (encounters, claims, clinical quality, etc.) strongly preferred
  • 5+ years of experience with Medicaid or Medicare.
  • 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development.

Required skills

  • BTEQ, Data Testing and Validation, Healthcare Claims and Encounter Data, Medicaid Eligibility and Enrollment Data, Medicaid Policy and Regulatory Reporting, Medicaid and Medicare, Microsoft Access, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Predictive Modeling, Relational Databases, Requirements Analysis, Requirements Gathering, Requirements Traceability, SAS, SQL, Statistical Validation, Teradata, Teradata SQL Assistant, Test Plan and Scenario Development

Experience

  • 5+ years

Company

  • IT consulting, staffing, and systems integration services.
  • Farmington Hills, Michigan, USA
  • http://hclglobal.com

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 13, 2026

Work mode

Hybrid

Job source

www1.jobdiva.com

Company

HCL Global Systems Inc

Information Technology & AI

IT consulting, staffing, and systems integration services.

See all 8 jobs from HCL Global Systems Inc →
  • Farmington Hills, Michigan, USA
  • Information Technology & AI
  • hclglobal.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in Richmond

Consulting

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

Zillion Technologies, Inc. is seeking a Senior Data Analyst to support enterprise application modernization by analyzing legacy data ecosystems and ensuring data integrity through migration.

Why similarSame roleRelational DatabasesMcLean

Mindlance

1d ago

New

Data Analyst Senior

Full-timeOn-siteMcLean, VACompetitive

Mindlance is recruiting a Senior Data Analyst for a confidential client. The role supports legacy application modernization through data profiling, migration and transformation analysis, validation, and collaboration with business and technical teams.

Why similarSame roleRelational DatabasesMcLean

just now

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

Technology Ventures is seeking a Senior Data Analyst to support enterprise data platforms and application modernization initiatives. The role focuses on SQL, data profiling, data mapping, and data integration.

Why similarSame roleRelational DatabasesMcLean

Get new Data Analyst jobs in Richmond by email

Create job alert

DMAS - Data Reporting & UAT Analyst

HCL Global Systems Inc · Competitive

Apply on company site