Senior Data Reporting and UAT Analyst

Pay Range: $60.00hr - $65.00hr Job Overview: This role will review Design documents, proactively identify requirement gaps and issues, map data between interface systems, and assist the lead analyst in project collaboration, documentation, and coordination. The successful candidate will review and contribute to test plans, work with stakeholders to build test scenarios, provide demonstrations to internal teams and project stakeholders, and work closely with business, QA, and development teams on pre- and post-go-live issues. Additionally, the role involves developing workflows, providing solutions, tracking issues end to end, and ensuring 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 the organization's 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 the 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 & Requirements: Domain Knowledge: 5+ years of experience with Medicaid, Medicare, or other health systems. 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, developing test data and scenarios, 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, or equivalent work experience. Additional Skills and Experience: Strong verbal and written communication 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, relational databases, data mining software, statistical validation techniques, predictive modeling construction, and data visualization. Proficiency in Microsoft Office Suite, including Access, Excel, PowerPoint, 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, maintain great attention to detail and accuracy, and 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. Experience facilitating customer requirements gathering sessions (such as JAD sessions) and maintaining Requirements Traceability. Benefits: Our Benefits Include: Medical, Dental, and Vision Insurance 401(k) Retirement Plan Health Savings Account (HSA) Disability Insurance (Short-Term and Long-Term) Life and AD&D Insurance Paid Sick Leave (where required by applicable state or local law) Supplemental Insurance Plans Identity Theft Protection Pet Insurance Employee Wellness Programs Employee Assistance Program (EAP) Career Growth and Professional Development Opportunities Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws. About Cynet Systems Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia. As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.