Job Details
Job Location
Dublin Office - Dublin, OH
Description
JOB SUMMARY
The Data Validation Analyst is responsible for validating processes, outcomes and BI reports developed by the Data and Analytics team. This individual will also be responsible for overseeing, preparing, processing and analyzing data to make the data valuable and useful for operational and/or decision-making purposes. The Data Validation Analyst plays such an important role to the Data Services team and the company in general as data integrity is an integral concept to the success of Outcomes.
Essential Duties & Responsibilities - Manage field validation for raw data:
- Identify data or systems not adhering to the normal data standards
- Track issues for the purpose of identifying the severity level
- Create daily and weekly reports used to document data validation for use by other teams
- Provide quality guidance and assessment to ensure maintenance of validated systems are managed in accordance with current corporate and regulatory requirements
- Discover and diagnose modeling related risks including input data, assumption, concept, methodology, process and implementation
- Validate data in new and existing BI Reports before dashboards are pushed to production
- Extract and manipulate data to perform trend calculations, identify benchmarking opportunities and business needs, and measure process or organizational performance
- Review code (SQL, PL/SQL, Powershell) written by the Data and Analytics team to ensure stability, efficiency and accuracy
Qualifications
KNOWLEDGE & REQUIREMENTS
- Get along with people and establish cooperative working relationships with all coworkers.
- Timely and effectively communicate information to and consult with others in order to complete work assignments.
- Act in a responsible, trustworthy and ethical manner that considers the impact and consequences one’s actions or decisions.
- Communicate ideas, thoughts, and facts in writing through the use of proper grammar, spelling, document formatting and sentence structure.
- Identify and respond to current and future clients needs; provide excellent client service.
- Evaluate and analyze problems or tasks from multiple perspectives; adaptively employ problem solving methods to find creative or novel solutions; use logical, systematic and sequential processes to solve problems.
- Complete assigned job tasks in an accurate and timely manner.
- Carefully prepare for meetings and presentations; follow up with others to ensure that agreements, tasks or commitments have been fulfilled.
- Demonstrate commitment to achieving Company’s core business objectives of increasing the role of pharmacy and improving patient health in America.
- Knowledge of business analytical practices and methodologies.
- Systematic and orderly planning abilities, with a high attention to detail.
- Effective written and oral communication and interpersonal skills.
- Ability to be flexible and work rapidly in a constantly changing environment.
- Ability to work independently and meet deadlines.
- Ability to work effectively and interact with all levels of management including executive leadership.
- Travel Requirements: Domestic and/or International, up to 10%
Education & Experience Requirements - Minimum years of work experience: 1 year
- At least one year experience in SQL, knowledge of relational database concepts and file structures
- One or more years of healthcare experience is preferred.
- Minimum level of education or education/experience: Bachelors or equivalent work experience
Physical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
- Frequent sitting in stationary position at a desk
- Occasional standing, walking, stooping, kneeling, squatting, and climbing stairs
- Occasional twisting of body
- Occasional reaching by extending hands and arms in any direction
- Occasional lifting, pulling, or pushing