Data Reporting & UAT Analyst

Data Reporting & UAT Analyst – Hybrid

• Richmond, VA About us Creative Information Technology Inc (CITI) is an esteemed IT enterprise renowned for its exceptional customer service and innovation. We serve both government and commercial sectors, offering a range of solutions such as Healthcare IT, Human Services, Identity Credentialing, Cloud Computing, and Big Data Analytics. With clients in the US and abroad, we hold key contract vehicles including GSA IT Schedule 70, NIH CIO-SP3, GSA Alliant, and DHS-Eagle II. Join us in driving growth and seizing new business opportunities. Role and Responsibilities Our client, the VITA
• Virginia Information Technology Agency, is looking for Data Reporting & UAT Analyst. Work schedule is Hybrid in Richmond, VA. 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. 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. Required Qualification 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. 5+ years of experience working with end users/customers to understand and develop requirements for technical solutions to meet business needs. 5+ years of experience analyzing project requirements and developing detailed technical specifications. 5+ years of experience working with technical developers to strategize solutions aligned with business requirements. Minimum 5 years of recent SQL writing experience. Minimum 5 years of experience facilitating customer requirements-gathering meetings, sessions, and Joint Application Development (JAD) sessions. Minimum 5 years of working knowledge of relational databases and database structures. Minimum 5 years of experience in requirements traceability. Minimum 5 years of experience with Business Intelligence (BI) reporting tools. Minimum 5 years of experience developing test data and test scenarios.

Preferred Skills

Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred. Experience working with Medicaid eligibility and enrolment 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.