Data Quality Analyst II

Job Summary:

The Data Quality Analyst II is responsible for working with team members, developers and department leadership to develop, maintain, implement and execute a data quality assurance process. They play a critical role in ensuring the accuracy, reliability, and consistency of data within our organization.

Essential Functions:

• Analyze data sources to understand their structure, relationships, and quality; identify anomalies, inconsistencies, and gaps in data
• Execute regression, functional, integration, and data tests against user-acceptance test criteria and expected results for documented test cases to verify and validate the data quality rules and standards
• Design and execute tests to validate data pipelines, reporting, and ETL processes
• Ensure seamless data flow between systems and components
• Maintain regression test suites to verify data quality after system upgrades or changes
• Detect any unintended impacts on existing data
• Document defect issues, communicate/collaborate with agile team for defect resolution, and retest to validate fix was implemented
• Collaborate with Agile Team members to understand the data under test, associated user acceptance criteria, and test cases/scenarios
• Collaborate with stakeholders to communicate data quality findings and improvements
• Update test cases as needed
• Employ test automation to streamline testing processes, reduce repetitive manual work, and decrease the environmental impact of prolonged testing cycles
• Implement automated data validation scripts using SQL and Databricks notebooks
• Monitor data pipelines and trigger alerts for anomalies
• Generate scripts to perform automated testing cycles
• Utilize existing tools and techniques to innovate new testing/validation functionality
• Work consists of tasks that are occasionally not routine and often works independently and is required to apply discretion within established operational boundaries and procedures
• Problems and issues faced are occasionally vague, and may need some analysis to understand
• Perform any other job duties as requested

Education and Experience:

• Bachelor’s Degree in Computer Science, Information Systems, a related field, or equivalent years of relevant work experience is required
• Minimum of three (3) years of experience in advanced SQL scripting required
• Minimum of three (3) years of experience with the administration of a quality assurance program required
• Experience in the healthcare payer industry is preferred

Competencies, Knowledge and Skills:

• Skilled in data testing and troubleshooting
• Advanced proficiency in SQL (including complex queries, stored procedures, and performance optimization)
• Familiarity with Azure Databricks, SQL, Postman, LoadRunner or similar data tools
• Familiarity with Microsoft business intelligence tools
• Strong understanding of data quality concepts (accuracy, completeness, consistency)
• Familiarity with data profiling tools
• Ability to effectively prioritize and execute tasks while working both independently and in a team-oriented, collaborative environment
• Strong interpersonal skills including excellent written and verbal communication skills; listening and critical thinking; presentation skills, facilitation skills
• Understanding of data governance principles
• Proficient in testing tools (ADO)
• Understanding of health care data is preferred
• Effective problem-solving skills with attention to detail
• Knowledgeable of phases of the software development life cycle
• Familiarity with Agile Frameworks and traditional project delivery lifecycle
• Quick learner; flexible; process oriented; highly organized and proactive
• Ability to manage multiple projects while demonstrating a sense of urgency

Licensure and Certification:

• None

Working Conditions:

• General office environment; may be required to sit or stand for extended periods of time

Compensation Range:

CareSource takes into consideration a combination of a candidate’s education, training, and experience as well as the position’s scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. In addition to base compensation, you may qualify for a bonus tied to company and individual performance. We are highly invested in every employee’s total well-being and offer a substantial and comprehensive total rewards package.

Compensation Type (hourly/salary):

Organization Level Competencies

• Create an Inclusive Environment

• Cultivate Partnerships

• Develop Self and Others

• Drive Execution

• Influence Others

• Pursue Personal Excellence

• Understand the Business

This job description is not all inclusive. CareSource reserves the right to amend this job description at any time. CareSource is an Equal Opportunity Employer. We are dedicated to fostering an inclusive environment that welcomes and supports individuals of all backgrounds.