Lead Reporting Analyst - Patient Experience Analytics and Reporting

Stanford Health Care; California (MO); Hybrid; USD 96,000 - 128,000; Full time

Job summary

Stanford Health Care seeks a Lead Reporting Analyst to design, develop, and maintain patient experience analytics and reporting solutions. You will work with SHC leaders, clinicians, and service-line teams to deliver self-service dashboards, automated reports, and advanced analyses on a modern cloud data platform (Databricks lakehouse) using Tableau and Qualtrics.

As a senior technical resource and mentor, you will set data-governance standards, anticipate stakeholder needs, and evaluate AI

Qualifications

• Bachelor's degree in IT, IS, analytics, or related field.
• 5+ years in BI or healthcare tech.
• Experience delivering self-service dashboards and analytics.

Responsibilities

• Triage requests with stakeholders and define requirements.
• Develop and deploy complex analytics on Databricks.
• Design and maintain Tableau dashboards for multiple audiences.
• Ingest, transform, and model data using Spark SQL and Delta Lake.
• Apply NLP and analytics to derive actionable insights.

Skills

Tableau

Qualtrics

Databricks

Spark SQL

Delta Lake

PySpark

Data governance

SQL

Data visualization

Education

Bachelor's degree

Tools

Databricks

Tableau

Qualtrics

Job description

1.0 FTE Full time Day - 08 Hour R2657902 Hybrid 108610071 Admin Service Excellence Technology & Digital Solutions PALO ALTO, 900 Welch Rd, California

If you're 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.

Day - 08 Hour (United States of America)

The Lead Reporting Analyst designs, develops, and maintains the patient experience analytics and reporting solutions that Stanford Health Care’s leaders, clinicians, and service-line teams rely on to understand and improve the patient and family experience.

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 Care’s 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 SHC’s 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 team’s 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 SHC’s 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 SHC’s 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

• Bachelor’s 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 Stanford’s 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 family’s 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 in all of its 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.

Base Pay Scale: Generally starting at $70.52 - $93.43 per hour

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.