Stanford Health Care Lead Reporting Analyst - Service Excellence - Remote Possible in Massachusetts
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.
The Lead Reporting Analyst is responsible for the design and the development of complex reporting solutions. This individual will work with team members, users, and others to triage requests, define requirements, design, develop and deploy high-quality reporting solutions that meet current and future foreseeable user needs utilizing SHC's tools and infrastructure.
Understand report requirements and build reports that functions as desired.
With minimal supervision, performs analysis, development, and testing of complex reporting solutions.
Build strong working relationships with users and team members, including Directors and above. Gains trust and respect of key users.
Manage multiple independent complex activities. Manage tasks, dependencies, and user/team expectations regarding scope and timeline of solution delivery.
Participates in, and effectively contributes to, project working groups with team members, users, analysts, clinicians, and SHC leadership.
Independently performs analysis, development, and testing of solutions.
Utilizes depth of reporting and tool specific expertise to recommend leading edge solutions to users that meet their expressed and unexpressed future needs.
Designs and develops complex reporting solutions that enable user functionality with minimal on-going maintenance and post-production incidents.
Provides expertise in understanding and using SHC data models and systems, and acts as resource in the interpretation and use of data generated and utilized by users.
Participates in teams to define design and development standards and conduct peer reviews of solution designs.
Troubleshoots incidents surrounding supported solutions.
Tune performance of complex solutions (both queries and database structures).
Organizes and conducts regular project status sessions and design reviews leveraging appropriate project artifacts. Consistently contributes valuable input during design reviews of team member solutions.
Stanford Health Care's Commitment to Providing an Exceptional Patient and 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
Knowledge, Skills and Abilities Required:
These are the observable and measurable attributes and skills required to perform successfully the essential functions of the job and are generally demonstrated through qualifying experience, education, or licensure/certification.
Delivers high quality Reporting & Analytics solutions that meet user requirements with minimal on-going maintenance and a low volume of production incidents (production failures, help desk calls, etc.).
Proficient with, and contributes to, best practices and common processes for developing solutions with SHC tools (i.e., SSIS, Crystal Reports, WebI, Qlikview, Tableau, etc.) utilized in role. Tableau experience is preferred.
Troubleshoots and performs root cause analysis of incidents and establishes countermeasures to improve supported applications.
4+ years' experience with SQL in an Oracle and/or SQL Server environment. Proficient with complex SQL (multi joins, subqueries, unions) and creation of database objects (tables, views, materialized views, etc.). Ability to utilize performance tuning utilities (Explain Plans, etc.) to optimize queries.
Deep experience and expertise with Data Warehousing and ETL concepts, including source to target mapping, transformations, error handling, job control, logging, alerting, and scheduling.
Demonstrated proficiency in Data Definition Language (DDL) , Data Manipulation Language (DML), and Extraction, Transformation and Loading (ETL) design and development using SQL Server tools (SQL Management Studio, T-SQL, SSIS, Team Foundation, etc.) , Machine Learning (Random Forest Classification, Natural Language Processing, Clustering, SVM and KHN)
Complex Report writing & proficient in metadata (universe) creation. Test, develops, shares innovative practices of BI/Reporting tools and participates in evaluating/impending new products or upgrades of existing products.
Able to work without direct supervision based on general direction provided by a superior, is able to give guidance to peers on complex issues and makes recommendations to supervisors on best path forward. Provides regular updates to supervisor on pending tasks, pain points, and potential roadblocks and manages user expectations accordingly.
Partnership interaction up to Tier 4 levels of the organization.
Demonstrated ability for completing multiple complex projects.
Contributing team member with best practices developed.
Helps fulfill SHC's vision. Understands how their work supports the vision and proposes better ways to achieve the vision. Can articulate these ideas in a manner that builds consensus and influences decision making up to the Director level.
Has mastered multiple domains and understands how the domains interrelate. Has some cross-functional knowledge and skill outside of formal position.
During the request process, the Lead Analyst can anticipate issues with the request and negotiate a viable alternative before the report writing process begins. The Lead Analyst is constantly looking at the "big picture" and develops reports that solve multiple problems, where possible, and anticipates other uses for the report requested.
Successfully implement role based standard work and develop the ability to identify exceptions.
Work is excellent with only rare problems or defects with complex solutions.
Solutions are recognized in industry publications or events for their quality and innovation.
Utilizes active daily management and is an expert with Lean methods.
Makes reliable operational internal decision independently and reliable tactical external decisions independently
Can successfully present complex ideas and information to a variety of audiences up to the Director level, and industry groups
Strong written, verbal, and interpersonal skills
- 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
- Five (5) or more years of experience in business intelligence or healthcare technology
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.
At Stanford Health Care, we seek to provide patients with the very best in diagnosis and treatment, with outstanding quality, compassion and coordination. With an unmatched track record of scientific discovery, technological innovation and translational medicine, Stanford Medicine physicians are pioneering leading edge therapies today that will change the way health care is delivered tomorrow.
As part of our spirit of discovery, we also leverage our deep relationships with luminary Silicon Valley companies to develop new ways to deliver preeminent patient care.
Learn about our awards (https://stanfordhealthcare.org/about-us/awards.html) and significant events (https://stanfordhealthcare.org/about-us/our-history.html) .
Stanford Health Care
- Stanford Health Care Jobs