The Sr.Data Quality Analyst will be responsible for ensuring and maintaining the quality of the client and vendor data received and processed in operational projects. The Data Quality Analyst will work closely with analysts, developers, 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 operations, driving quality assurance tasks and issue resolution.
•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
Key competencies/skill/success factors:
•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
Qualification and Experience:
•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 with ETL processes using ETL tool such as Informatica and SSIS
•Knowledge of BI tools such as Micro Strategy
•Basic Knowledge of Hadoop
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This position primarily works in a climate controlled based setting.The noise level and the work environment are moderately quiet. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines
Include the physical demands of the job, including bending, sitting, lifting and driving. For example, while performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms.
Why Join Evolent?
Named among Forbes’ 2014 America’s Most Promising Companies and Glassdoor’s 2015 Best Places to Work, Evolent provides an opportunity to work with top talent in an organization committed to career development. While we come from a variety of backgrounds, we pursue a singular mission: to change the health of the nation by changing the way health care is delivered