Data Quality Analyst

• Analyze and understand data sources and end-user requirements for loading healthcare data into enterprise data warehouse as it relates to eligibility, medical, pharmacy claims, as well as clinical and provider data.
• Develop and execute SQL/SAS data quality test cases, scripts and procedures to support the data quality metrics.
• Resolve data quality problems. Activities include: Identify, assess, fix, document, and communicate potential quality issues in the way data is collected, stored, processed, or used. 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. Fixing the data problem may require the DQA to recommend, design, implement and monitor quality procedures for use in the data production process. It may also include data cleansing operations such as removing duplicate records.
• Manage data quality documentation. Activities include: Define and maintain data standards, definitions, and models (e.g. data dictionary, organizational data model. This may also include any DQA documents such as checklists, guidelines, manuals, templates, forms, etc.)
• 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.
• Track defects to resolution

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
• 2+ years of experience in writing/executing test scripts in SAS.
• Experience in converting mapping documents and transformation requirements into a testing strategy, test cases and test data
• Experience creating SQL/SAS QA checks to test data integration and data transformation
• Knowledge of healthcare data and industry
• Must possess 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

Preferred

• Experience with ETL processes using ETL tool such as Informatica and SSIS
• Knowledge of BI tools such as Micro Strategy
• Basic Knowledge of Hadoop