Data Integrity and Quality Analyst II

The Analyst II, Data Integration & Quality (DIQ), performs advanced validation, profiling, and assessment of Supply Chain data as it moves across systems. This role applies stronger analytical judgment, SQL logic, and multi-source comparison techniques to evaluate integration outcomes, detect systemic data issues, and recommend corrective actions. The Analyst II supports refinement of data quality rules, contributes to integration testing and root-cause analysis, and ensures that data-in-motion conforms to DAMA-aligned governance expectations. The role operates with increased independence and provides subject matter support to Analyst I staff.

What you will do:

Data Quality Assessment

• Conduct complex source-to-target reconciliations using advanced lookup logic, pivot analysis, conditional expressions, and multi-file comparisons.

• Modify SQL queries, joins, and aggregations to validate accuracy of integrated datasets and confirm data completeness.

• Identify quality-impacting patterns and recommend improvements to rule criteria or validation logic.

Integration Validation and Troubleshooting

• Evaluate integration logs, transformation outputs, mapping behaviors, and load results to determine integration health.

• Diagnose data-related causes of integration failures using spreadsheet analysis, SQL validation, and pattern recognition.

• Partner with technical teams to clarify data behavior, mapping gaps, or systemic integration issues requiring remediation.

Exception Analysis & Continuous Monitoring

• Analyze data exceptions across cycles to identify recurring defects, dependencies, or upstream root causes.

• Build structured exception summaries or simple dashboard visuals to support readiness assessments and improvement plans.

• Recommend adjustments to data quality thresholds, validation rules, or process controls based on observed trends.

*Metadata, Lineage & Governance Documentation

• Document end-to-end validation processes, data lineage interpretations, integration flow observations, and exception patterns.

• Ensure structured documentation supports audit, compliance, and governance expectations for transparency and repeatability.

• Provide feedback on gaps in governance standards and contribute updates to metadata repositories as needed.

Controlled Use of Automation, Scripting & AI (Data Processing)

• Design and refine reusable validation templates and tools (e.g., standardized Excel workbooks, macros, Office Scripts, or basic scripts) that Analyst I staff can use to perform consistent data quality checks and source-to-target comparisons.

• Collaborate with the Supervisor or Manager to define approved automation and AI usage patterns for DIQ work (e.g., when to use AI for formula generation, how to structure exception summaries), and document these patterns as standard operating methods.

• Use AI tools to explore and prototype new validation or profiling approaches, then translate successful patterns into documented, repeatable job aids or templates for broader team adoption.

• Ensure that all automated workflows and AI-assisted methods are tested, versioned, and compliant with data governance, security, and privacy requirements before promoting them for regular team use.

*Support for Junior Team Members

• Model expected leadership behaviors aligned with HT values, Code of Conduct, and Mission.

• Provide guidance, structured review feedback, and knowledge-sharing to Analyst I staff on validation methods, SQL usage, and data quality concepts.

• Assist in building reusable templates, job aids, and examples that promote learning and consistency across the team.

• Bachelor's degree in a related field required.

• 3 years' experience performing data validation, profiling, audit, or analytics work involving structured datasets required.

• 1+ years' experience with demonstrated use of SQL and spreadsheet-based analysis in governed data environments preferred.

• 1+ years' experience supporting integration, data quality, or data readiness initiatives preferred.

• or 10+ years' experience performing data validation, profiling, audit, or analytics work involving structured datasets, including demonstrated use of SQL and spreadsheet-based analysis, and supporting integration, data quality, or data readiness initiatives analysis in governed data environments.

• Certified Data Management Professional (CDMP) Preferred

• APICS Certified Supply Chain Professional (CSCP) Preferred

HealthTrust, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services

• Wellbeing support, including free counseling and referral services

• Time away from work programs for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence

• Savings and retirement resources , including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling

• Education support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing

• Additional benefits for fertility and family building, adoption assistance, life insurance, supplemental health protection plans, auto and home insurance, legal counseling, identity theft protection and consumer discounts

Learn more about Employee Benefits (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)

HealthTrust Supply Chain (https://healthtrustpg.com/) is a critical part of HCA Healthcare's strategy. Our focus is to **improve performance** and reduce costs. We do this by joining non-clinical and administrative functions. HealthTrust Supply Chain best practice methodologies. We develop, apply and monitor **cost-efficient initiatives** and programs for HCA Healthcare. By improving facility efficiency, medical professionals can focus on our mission - patient care. HCA Healthcare has been recognized as one of the World's Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses. "The great hospitals will always put the patient and the patient's family first, and the really great institutions will provide care with warmth, compassion, and dignity for the individual."- Dr. Thomas Frist, Sr.