Business Intelligence (Tableau) Administrator

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 Stanford Medicine Technology and Digital Solutions team was formed to provide the Stanford Medicine community with the most innovative technology services as efficiently as possible. Led by Michael Pfeffer, CIO and Michael Halaas, Chief Operating Officer and Associate Dean in the School of Medicine, the unified organization brings together the best of the School of Medicine and Stanford Health Care IT to enable new opportunities for groundbreaking work and compassionate care. Together, the Technology and Digital Solutions team will work to break down historic organizational barriers to enable even greater collaboration across Stanford Medicine hospital and clinics, and the entire University. This is a Stanford Health Care job. As a Remote Business Intelligence (Tableau) Administrator you will be primarily focused on administration and DevOps for Tableau and other BI tool uses with curated datasets within the Stanford Health Care Enterprise Data Warehouse (EDW) and Epic Cogito reporting framework. This role also develops Tableau solutions for special projects and internal administrative uses, coordinates and creates user and process documentation, and coordinates with development teams on effective uses of Tableau to implement best practices, effective security, etc. Python development experience preferred. May require after-hours work during upgrades and other major projects. A Brief Overview The Business Intelligence Analyst is responsible for monitoring production processes and providing first tier of support for user requests for user administration, enhancement requests, production incidents or outages related to Business Intelligence solutions owned by the CBA organization. In addition, this role will be involved in operational improvement projects and development/enhancement of BI solutions utilizing standard BI and/or ETL tools Locations Stanford Health Care What you will do With guidance, develops/enhances BI and ETL processes that reflect best practices for error handling, operations logging and alerting, scheduling and job control, etc. Prepares/Updates design specifications and operations documentation for BI solutions promoted to the production environment. Monitors production solutions and, where necessary, performs required manual procedures. Perform user administration within BI tools as requested and approved. Troubleshoots incidents surrounding supported solutions. Assists with installation and testing of software patches/upgrades and testing of operating system, hardware, and database patches/upgrades installed by system administrators. Manages work queue of incidents and user requests within Service Management application. Identifies improvements to operational processes and leads projects to implement such improvements, applying solid project management skills, team/user communications, etc. Understands and applies HIPAA standards and regulations to all areas of work. Education Qualifications BS/BA in information or business-related field from an accredited college or university Experience Qualifications Two (2) years of experience with design and development of BI solutions and/or administration of BI tools. Required Knowledge, Skills and Abilities Experience delivering 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 best practices and common processes for developing solutions with, and/or administering, multiple standard SHC tools, including: o SAP BusinessObjects: BusinessObjects Enterprise (BOE), WebIntelligence, Crystal Reports, Xcelcius, BusinessObjects Data Services, CMC, SDK o QlikView o Microsoft SQL Server: SQL Server, SSIS, Management Studio, Team Foundation Services (TFS) o Epic: Clarity ETL Admin (Compass), Clarity Data Model o Oracle: Oracle RDMS10/11, Oracle Client o Remedy/ITSM Service Management (Help Desk/Support) application Demonstrated experience with Windows Server management or coordination with Windows administrators to investigate/resolve Incidents, implement Windows patches, monitor hardware utilization, and perform hardware migrations/upgrades (of both virtual and non-virtual servers) as needed. Demonstrated ability to troubleshoot incidents and enhancement requests for reporting and analytical applications. Recommends improvements to supported applications to supervisors and implements approved enhancements. Over 1 year of experience with SQL in an Oracle and/or SQL Server enviroment. Very proficient with SQL (joins, multpile joins, subqueries, unions) including DDL for creation of tables, views, materialized views, etc. Ability to perform basic performance tuning to optimize queries to meet user needs. Demonstrated proficiency 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.), Oracle tools, and/or Epic Clarity Compass. Complex Report writing & some metadata (i.e., BusinessObjects universes, QlikView QVW) creation with SHC standard tools. Effectively implemented upgrades/patches of these tools, managed production scheduling, and administered user access. Accountable for management interactions up to Tier 4 of the organization (Directors and VPs). Demonstrated ability for completing moderately complex projects and/or multiple assigned projects. Seeks and embraces coaching and mentoring from team members in order to develop skills and integrate with the team. Ability to understand basic tenants of the SHC vision and communicates them to others. Appropriately questions how their assigned work relates and supports this vision. Demonstrates expertise in one or more functional or technical domains while developing expertise in other domains. Ability to anticipate functional, design, or technical problems with standard recurring work or projects and suggest viable alternatives. Ability to partner with multidisciplinary teams with limited supervision. Track record of producing consistently good work with limited problems or defects. Experience utilizing Lean concepts including visibility walls, problem solving A3s, and Gemba rounding principles. Makes reliable operational internal decisions with limited supervision. Effectively formulates and presents basic ideas to a group of peers. Effective verbal, written, and interpersonal communication skills. Licenses and Certifications None 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 Stanfords 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 familys 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 $54.22 - $71.84 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. 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) .