The Role
Performs data testing, validation, SQL-based reporting, and UAT for Medicaid and Medicare data systems. Reviews requirements and design documents, identifies gaps, maps data across interfaces, develops test plans and scenarios, investigates anomalies, and tracks issues through resolution. Builds dashboards and visualizations, maintains governance and technical documentation, collaborates with business, QA, development, infrastructure, and vendors, and supports pre- and post-production releases.
Summary Generated by Built In
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.
• 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.
Requirements
Skill
Required / Desired
Amount
of Experience
Experience with Medicaid or Medicare or other health systems
Required
5
Years
Required
5
Years
Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs
Required
5
Years
Required
5
Years
Exp w/analyzing project requirements and developing detailed technical specifications
Required
5
Years
Required
5
Years
Exp with technical developers to strategize solutions to align with business requirements
Required
5
Years
Required
5
Years
Recent SQL writing experience
Required
5
Years
Required
5
Years
Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions
Required
5
Years
Required
5
Years
working knowledge of relational databases/database structures
Required
5
Years
Required
5
Years
Requirements Traceability
Required
5
Years
Required
5
Years
BI reporting tools
Required
5
Years
Required
5
Years
developing test data and test scenarios
Required
5
Years
Required
5
Years
Bachelor’s degree or equivalent work experience
Required
Required
Skills Required
- 5+ years of experience with Medicaid, Medicare, or other health systems
- 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role focused on data testing and SQL development
- Advanced SQL skills in Teradata, including performance tuning, BTEQ, and Teradata SQL Assistant
- Experience writing test plans, performing data validation, and identifying data anomalies or discrepancies
- Experience collaborating with third-party vendors, IT infrastructure teams, or database administrators
- Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field
- Experience working with end users or customers to gather and develop technical requirements
- Experience analyzing project requirements and developing detailed technical specifications
- Experience collaborating with technical developers to align solutions with business requirements
- Recent SQL writing experience
- Experience facilitating customer requirements gathering or JAD sessions
- Working knowledge of relational databases and database structures
- Requirements traceability experience
- Experience with business intelligence reporting tools
- Experience developing test data and test scenarios
- Strong quantitative analysis skills, including SAS, data mining, statistical validation, predictive modeling, and data visualization
- Proficiency with Microsoft Office Suite, including Access, Excel, PowerPoint, and Word
- Experience with Medicaid eligibility, enrollment, encounters, claims, or clinical quality data
- Working knowledge of state and federal Medicaid policy and regulatory reporting requirements
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Novalink Solutions LLC is a global consulting, engineering, and AI product development company specializing in information technology and telecommunications. They provide AI-powered products, automation platforms, intelligent workflow systems, IT consulting, managed engineering, and staff augmentation services.
