Senior Reporting Analyst

Stanford Health Care•Palo Alto, CA

4d•$65 - $86

About The Position

The Senior Reporting Analyst is responsible for designing and developing complex reporting solutions using Stanford Health Care’s tools and infrastructure. The analyst works with team members, users, and other stakeholders to triage requests, define requirements, and deliver high-quality solutions that meet current and foreseeable user needs. The role requires expertise in reporting tools, SHC data models, and systems, along with the ability to provide guidance on data interpretation and usage. The analyst also contributes to design and development standards, peer reviews, and project working groups, and troubleshoots and tunes complex solutions. Employees are expected to support Stanford Health Care’s commitment to an exceptional patient and family experience by following C-I-CARE standards and its experience pillars: Know Me, Show Me the Way, and Coordinate for Me.

Requirements

Bachelor’s degree in information technology, information systems, business management, business analytics, business administration, or a directly related field from an accredited college or university.
Four or more years of experience in reporting, business intelligence, or healthcare technology.
Proficient with SHC tools used in the role and able to contribute to development best practices and common processes.
Demonstrated ability to build advanced SQL skills quickly.
Experience writing complex reports and creating metadata (universes) with SHC standard tools.
Recognized expertise in one or more reporting or visualization tools.
Able to work with limited supervision, make recommendations, and provide regular updates to a supervisor.
Demonstrated ability to complete multiple complex projects and contribute as a team member.
Ability to understand how work supports SHC’s vision and to communicate improvement ideas in ways that build consensus and influence Director-level decisions.
Mastery of multiple domains and understanding of how they interrelate, with some cross-functional knowledge outside the formal position.
Ability to anticipate request issues, negotiate viable alternatives, consider the broader context, and solve multiple problems through reporting solutions.
Work quality should be excellent, with only rare problems or defects in complex solutions.
Ability to make reliable internal operational decisions independently and tactical external decisions with limited supervision.
Effective verbal, written, and interpersonal communication skills, including presenting moderately complex information to varied audiences such as senior managers and industry groups.
Demonstrated ability to learn new tools and data models quickly.
Adoption and execution of SHC C-I-CARE standards for patients, families, and colleagues.

Nice To Haves

Two or more years of SQL experience in an Oracle and/or SQL Server environment, including working knowledge of multi-table joins, subqueries, and unions.
Experience creating database objects such as tables, views, and materialized views, and using performance-tuning utilities such as Explain Plans.
Experience with Databricks.
EPIC Certification.

Responsibilities

Understand report requirements and build reports that function as desired.
Analyze, develop, and test complex reporting solutions.
Build strong working relationships with users and team members, including Directors and above.
Manage multiple complex activities, tasks, dependencies, and expectations regarding scope and delivery timelines.
Participate and contribute effectively in project working groups with team members, users, analysts, clinicians, and SHC leadership.
Use reporting and tool expertise to recommend solutions that address users’ expressed and foreseeable needs.
Design and develop complex reporting solutions that minimize ongoing maintenance and post-production incidents.
Provide expertise in SHC data models and systems, including interpreting and using data.
Help define design and development standards and conduct peer reviews of solution designs.
Troubleshoot incidents involving supported solutions.
Tune the performance of complex solutions, including queries and database structures.
Organize and conduct project status sessions and design reviews using appropriate project artifacts, and contribute to reviews of team members’ solutions.
Provide regular updates to supervisors on pending tasks, pain points, and potential roadblocks.
Anticipate issues during the request process and negotiate viable alternatives before report development begins.
Develop role-based standard work to coordinate improvement work effectively.
Support SHC’s vision and contribute to patient- and family-centered interactions in accordance with C-I-CARE standards.