Lead Reporting Analyst - Patient Experience Analytics and Reporting

Stanford Health Care • Palo Alto, CA

1d • $71 - $93 • Onsite

About The Position

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.

Requirements

• 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.
• Five or more years’ experience in either (or both) Business Intelligence or Healthcare technology required.
• 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.
• 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.

Nice To Haves

• Experience with additional or transitional BI tools is a plus.
• PySpark and Unity Catalog / data-governance familiarity are strong pluses.

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior