Hello
Urgently looking for DATA ANALYST with HEALHCARE EXP for RICHMOND VA location
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.
Required/Desired Skills
| Skill | Required/Desired | Amount | of Experience |
| Experience with Medicaid or Medicare or other health systems | Required | 5.0 | Years |
| Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs | Required | 5.0 | Years |
| Exp w/analyzing project requirements and developing detailed technical specifications | Required | 5.0 | Years |
| Exp with technical developers to strategize solutions to align with business requirements | Required | 5.0 | Years |
| Recent SQL writing experience | Required | 5.0 | Years |
| Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions | Required | 5.0 | Years |
| working knowledge of relational databases/database structures | Required | 5.0 | Years |
| Requirements Traceability | Required | 5.0 | Years |
| BI reporting tools | Required | 5.0 | Years |
| developing test data and test scenarios | Required | 5.0 | Years |
| Bachelor s degree or equivalent work experience | Required | | |
