Lead Reporting Analyst Patient Experience Analytics and Reporting

If youre ready to be part of our legacy of hope and innovation we encourage you to take the first step and explore our current job openings. Your best is waiting to be discovered.

This is a Stanford Health Care job.

A Brief Overview

The Lead Reporting Analyst designs develops and maintains the patient experience analytics and reporting solutions that Stanford Health Cares leaders clinicians and service-line teams rely on to understand and improve the patient and family experience. Working within the Patient Experience Analytics and Reporting (PEAR) team this individual partners with stakeholders to triage requests define requirements and deliver high-quality self-service dashboards automated reports and advanced analyses spanning both structured survey results and unstructured patient and provider comments using SHCs modern cloud data platform (Databricks lakehouse) Tableau and Qualtrics.

As a senior technical resource and mentor the Lead Analyst sets development and data-governance standards anticipates current and future stakeholder needs and continually evaluates and adopts emerging analytics and AI capabilities to advance the teams impact.

Locations
Stanford Health Care

What you will do

• Partner with patient experience leaders clinical and service-line stakeholders and team members to triage requests define requirements and deliver reporting and analytics solutions that meet current and future foreseeable needs.
• With minimal supervision perform analysis development testing and deployment of complex patient experience reporting analytics and BI solutions on SHCs Databricks platform.
• Design build and maintain Tableau dashboards and self-service reporting products that surface HCAHPS Qualtrics survey results and other patient experience measures for audiences ranging from frontline units to executive leadership.
• Develop and maintain data pipelines (ETL/ELT) in Databricks ingesting transforming and modeling survey and operational data using Spark SQL Delta Lake and notebooks with reliable scheduling logging alerting and error handling.
• Apply modern analytics techniques including text and natural-language analytics on unstructured patient and provider comments) driver and trend analysis and predictive or statistical methods to generate actionable insight beyond standard reporting.
• Administer and support patient experience survey data operations and the comment-review and coding workflow ensuring data quality completeness and timeliness.
• Provide expertise in SHCs data models and the patient experience data domain and support the transition from legacy data sources to the Databricks; serve as a resource in the interpretation and appropriate use of data.
• Build strong working relationships with users and team members including Directors and above; gain the trust and respect of key stakeholders.
• Manage multiple independent complex activities tasks dependencies and stakeholder expectations regarding scope and timeline of solution delivery.
• Establish and contribute to design and development standards data-governance practices documentation and version control; conduct peer reviews of solution designs and code.
• Tune the performance of complex solutions (queries and data structures); troubleshoot incidents and perform root-cause analysis on supported solutions.
• Evaluate and pilot emerging analytics automation and AI tools; recommend leading-edge solutions and share innovative practices with the team.
• Organize and conduct regular project status sessions and design reviews leveraging appropriate project artifacts and contribute valuable input during reviews of team-member solutions.

Education Qualifications

• Bachelors degree in information technology information systems data analytics data science statistics business analytics business administration or a directly related field from an accredited college or university.

Experience Qualifications

• Five or more years experience in either (or both) Business Intelligence or Healthcare technology required.

Required Knowledge Skills and Abilities

• Delivers high-quality reporting and analytics solutions that meet user requirements with minimal ongoing maintenance and a low volume of production incidents (production failures help desk calls etc.).
• Proficient with the modern BI and analytics tools used in the role Tableau (required) and Qualtrics including experience/text analytics. Experience with additional or transitional BI tools is a plus.
• Proficient developing on a cloud lakehouse platform Databricks preferred (Spark SQL Delta Lake notebooks and Workflows/Jobs); PySpark and Unity Catalog / data-governance familiarity are strong pluses.
• 4 years experience with SQL across enterprise data platforms. Proficient with complex SQL (multi-joins subqueries unions window functions) and creation of database/lakehouse objects (tables views Delta tables etc.) and able to use performance-tuning tools to optimize queries.
• Deep experience with data warehousing / lakehouse and ETL/ELT concepts including source-to-target mapping transformations error handling job control logging alerting and scheduling.
• Familiarity with applied analytics and data-science methods relevant to patient experience natural-language processing of comments text classification and clustering driver and trend analysis and predictive/statistical modeling and able to translate them into operational reporting.
• Strong data-visualization and data-storytelling skills; tests develops and shares innovative practices and participates in evaluating and implementing new analytics products or upgrades.
• Applies sound data-governance privacy and security practices appropriate to healthcare analytics (PHI/HIPAA) and contributes to enterprise data-governance standards.
• Troubleshoots and performs root-cause analysis of incidents and establishes countermeasures to improve supported solutions.
• Able to work without direct supervision based on general direction; provides guidance to peers on complex issues and makes recommendations to supervisors on the best path forward. Provides regular updates on pending tasks pain points and potential roadblocks and manages user expectations accordingly.
• Anticipates issues with a request and negotiates a viable alternative before development begins; consistently looks at the big picture and builds solutions that solve multiple problems and anticipate future uses.
• Partnership interaction up to Tier 4 levels of the organization; can present complex ideas and information to a variety of audiences up to the Director level and to external/industry groups.
• Has mastered multiple domains and understands how they interrelate with cross-functional knowledge beyond the formal position.
• Utilizes active daily management standard work and Lean methods to drive continuous improvement.
• Makes reliable operational and tactical decisions independently. Strong written verbal and interpersonal skills.

Licenses and Certifications

• N/A

These principles apply to ALL employees:

SHC Commitment to Providing an Exceptional Patient & Family Experience


Stanford Health Care sets a high standard for delivering value and an exceptional experience for our patients and families. Candidates for employment and existing employees must adopt and execute C-I-CARE standards for all of patients families and towards each other. C-I-CARE is the foundation of Stanfords patient-experience and represents a framework for patient-centered interactions. Simply put we do what it takes to enable and empower patients and families to focus on health healing and recovery.



You will do this by executing against our three experience pillars from the patient and familys perspective:

• Know Me: Anticipate my needs and status to deliver effective care
• Show Me the Way: Guide and prompt my actions to arrive at better outcomes and better health
• Coordinate for Me: Own the complexity of my care through coordination

Equal Opportunity Employer Stanford Health Care (SHC) strongly values diversity and is committed to equal opportunity and non-discrimination inall ofits policies and practices including the area of employment. Accordingly SHC does not discriminate against any person on the basis of race color sex sexual orientation or gender identity and/or expression religion age national or ethnic origin political beliefs marital status medical condition genetic information veteran status or disability or the perception of any of the above. People of all genders members of all racial and ethnic groups people with disabilities and veterans are encouraged to apply. Qualified applicants with criminal convictions will be considered after an individualized assessment of the conviction and the job requirements.

The salary of the finalist selected for this role will be set based on a variety of factors including but not limited to internal equity experience education specialty and training. This pay scale is not a promise of a particular wage.