Data Integrity and Quality Analyst II

Are you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a Data Integrity and Quality Analyst II today with HealthTrust.

Job Summary and Qualifications

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.

• 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.

• 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.

• 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.

• 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.

• 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

• 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