Data Quality Assurance Analyst LOC : Arlington, VA
100,000 - 200,000
Job Description:
Who You??ll Be Working With
- The Data Quality Analyst will be responsible for ensuring and maintaining the quality of the client and vendor data received as part of each assigned data onboarding initiative.
- The Data Quality Analyst will work closely with the client, carrier & PBM vendor(s) and internal Data and Technical
- Leads to understand the client / vendor data and develop the appropriate test plan, test cases and test schedule in support of data on boarding and all necessary data quality assurance tasks.
What You??ll Be Doing
- Analyze and understand data sources and end-user requirements for loading healthcare data into enterprise data warehouse as it relates to clinical, as well as eligibility, medical, pharmacy claims and provider data.
- Analyze data mapping and transformation requirements in order to develop test strategies, procedures, and plans.
- Develop and execute SQL data quality test cases, scripts and procedures to test data integration processes.
- Document test cases and test results.
- Participate in defect resolution analysis and track defects to resolution.
- Profile and analyze data to ensure quality standards are met.
- Participate in data quality problem resolution.
- This may involve interacting with business users to resolve data quality problems using techniques such as root cause analysis as well as collecting user requirements.
- Participate in cross-functional teams and development or improvement task forces.
- Assist other groups in database setup, design of edit checks, test plans, DQ policy decisions, etc. to ensure data quality objectives are met.
The Experience You Need (Required)
- Requires BS/BA degree, 5 years quality assurance experience, which includes skills necessary to work with computer systems, knowledge of data manipulation tools and analysis techniques
- 3+ years of advanced SQL skills to write queries and view/test data in relational database
- Experience in converting mapping documents and transformation requirements into a testing strategy, test cases and test data
- Experience creating SQL QA checks to test data integration and data transformation
- Knowledge of healthcare data and industry
- Strong written and verbal communications skills to present findings and recommendations
- Should be detail oriented, have strong problem solving skills and understand benefits of data quality
- Finishing Touches (Preferred)
- Experience with ETL processes using ETL tool such as SSIS
- Knowledge of BI tools such as Micro Strategy