Senior Reporting Analyst

Stanford Health Care•Palo Alto, CA

About The Position

The Senior Report Analyst designs, develops, tests, and deploys complex reporting solutions using Stanford Health Care’s tools, data models, systems, and infrastructure. The role works with users, team members, analysts, clinicians, and SHC leadership to clarify and triage requests, define requirements, and deliver high-quality solutions that meet current and foreseeable needs. The analyst manages multiple complex activities and expectations around scope and timelines, builds strong working relationships with users and leaders, and recommends solutions informed by reporting expertise and anticipated user needs. The role also contributes to design and development standards, peer reviews, project status sessions, and design reviews; troubleshoots supported solutions; and tunes query and database performance. The position requires a bachelor’s degree in a directly related field and at least four years of experience in reporting, business intelligence, or healthcare technology. It calls for strong reporting and analytics skills, expertise with one or more reporting or visualization tools, the ability to learn new tools and data models quickly, and effective communication and project coordination. SQL experience is preferred, as are experience with database objects and performance-tuning utilities, Databricks experience, and EPIC certification.

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.
Ability to deliver high-quality reporting and analytics solutions that meet user requirements with minimal ongoing maintenance and few production incidents.
Proficiency with SHC tools and best practices for developing solutions, such as SSIS, Crystal Reports, WebI, and Tableau.
Ability to troubleshoot incidents, perform root cause analysis, and establish countermeasures.
Experience with SQL in an Oracle and/or SQL Server environment, including multi-table joins, subqueries, and unions.
Ability to develop advanced SQL skills quickly.
Experience writing complex reports and creating metadata (universes) with SHC standard tools.
Recognized expertise with one or more reporting or visualization tools.
Ability to work with limited supervision, make recommendations, and provide regular updates to a supervisor.
Demonstrated ability to complete multiple complex projects.
Ability to anticipate issues, negotiate viable alternatives, and consider broader needs when developing reports.
Ability to make reliable operational decisions independently and tactical decisions with limited supervision.
Effective verbal, written, and interpersonal communication skills, including the ability to present moderately complex ideas to varied audiences.
Demonstrated ability to learn new tools and data models quickly.
Ability to fulfill SHC’s vision and communicate ideas in ways that build consensus and influence decision-making at the Director level.
Ability to understand multiple interrelated domains and apply cross-functional knowledge.
Commitment to executing SHC C-I-CARE standards in interactions with patients, families, and colleagues.

Nice To Haves

Two or more years of SQL experience.
Experience creating database objects such as tables, views, and materialized views.
Experience using performance-tuning utilities such as Explain Plans.
Experience with Databricks.
EPIC certification.

Responsibilities

Understand reporting requirements and build reports that function as intended.
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, scope, timelines, and expectations.
Participate and contribute effectively in project working groups with team members, users, analysts, clinicians, and SHC leadership.
Recommend leading-edge reporting solutions that address users’ expressed and foreseeable needs.
Design and develop complex solutions that provide user functionality with minimal ongoing maintenance and few post-production incidents.
Provide expertise on SHC data models and systems, and help users interpret and use data.
Contribute to design and development standards and conduct peer reviews of solution designs.
Troubleshoot incidents involving supported solutions and perform root cause analysis.
Tune the performance of complex solutions, including queries and database structures.
Organize and conduct regular project status sessions and design reviews using appropriate project artifacts.
Provide valuable input during reviews of team members’ solutions.
Anticipate issues in report requests and negotiate viable alternatives before report development begins.
Develop role-based standard work to coordinate improvement work.
Provide regular updates to the supervisor on pending tasks, pain points, and potential roadblocks.