Job Description & Details
This is a hands-on hybrid role bridging heavy data validation, UAT coordination, and complex healthcare policy reporting. If you know your way around Teradata and have spent time wrestling with Medicaid or Medicare data pipelines, this gig gives you a chance to own the quality lifecycle from design doc review straight through to post-go-live fixes.
What You'll Actually Be Doing
Your days will be split between deep-dive technical validation and cross-functional wrangling. You'll review design specs, map data between unruly interface systems, write complex SQL queries to pull and verify data, and build out test scenarios with stakeholders. When data loading issues or performance bottlenecks pop up with the data warehouse vendor, you'll be the primary technical point of contact to track those issues down to resolution. You'll also translate technical findings into digestible dashboards using tools like Tableau or Power BI for non-technical leadership.
The Core Tech Stack
Teradata is the absolute anchor here—you need advanced SQL skills specifically within this environment, including performance tuning and BTEQ. Alongside that, you'll rely heavily on data visualization tools like Tableau, Power BI, or Looker, and potentially some SAS or Excel for quantitative analysis. Domain knowledge is non-negotiable; you must understand healthcare operations, specifically Medicaid/Medicare eligibility, claims, encounters, and federal/state regulatory reporting requirements.
Interview Expectations
Expect the hiring team to grill you on your Teradata optimization skills and how you handle complex data discrepancies during UAT. They will likely present a scenario where a data pipeline fails right before a major state reporting deadline and ask you to walk through your troubleshooting steps. The interviewer is secretly looking for someone who doesn't just throw errors over the wall to developers, but actively investigates root causes using SQL, designs the test scenarios, and communicates the impact clearly to business stakeholders.
Application Advice
To get past the ATS and grab the recruiter's attention, make sure your resume explicitly calls out your years of experience with Medicaid or Medicare data alongside heavy SQL development. Don't just list "SQL"—specify "Teradata SQL", "BTEQ", and "Performance Tuning". Weave in phrases like "User Acceptance Testing (UAT)", "Requirements Traceability", and specific healthcare data types like claims and encounters so your profile matches the skills matrix they are evaluating.