RedwoodCityRecruiter Since 2001
the smart solution for Redwood City jobs

SENIOR BUSINESS INTELLIGENCE ANALYST

Company: Stanford Health Care
Location: Redwood City
Posted on: June 2, 2021

Job Description:

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. Stanford Healthcare Technology and Digital Solutions (TDS) is seeking a Sr. Business Intelligence Analyst. The successful candidate will join the TDS Analytics team - a highly collaborative, multi-disciplinary team working in Agile Scrum - to deliver BI solutions to Stanford School of Medicine (SoM) clients in Clinical and Basic Science Departments and Central Units (e.g. Finance, HR, Academic Affairs). Please refer to "For SoM-Facing Employees" for the specifically required tool skills in the Knowledge, Skills and Abilities section below.Job DescriptionThis is a Stanford Health Care job.A Brief OverviewThe SR BUSINESS INTELLIGENCE ANALYST is responsible for 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, infrastructure and vendor product deployment projects, and development of BI solutions.LocationsStanford Health CareWhat you will doDevelops/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 and tool administration within BI tools as requested and approvedTroubleshoots incidents surrounding supported solutionsCoordination with Infrastructure team on maintenance of hardware, upgrades, database administration/tuning, etc. of the EDW/BI stall/Test software patches/upgrades and test operating system, hardware, and database patches/upgrades installed by system administratorsManage work queue of incidents and user requests within Service Management applicationIdentifies 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 workEducation QualificationsBS/BA in information or business-related field from an accredited college or universityExperience QualificationsFour (4) years of experience with design and development of BI solutions and/or administration of BI tools.Required Knowledge, Skills and AbilitiesFor Senior Business Intelligence Analyst (In General):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.).Demonstrated ability to troubleshoot, and perform root cause analysis of, production incidents and established countermeasures to improve supported applications.Two (2)+ years of experience with SQL in an Oracle and/or SQL Server (preferred) 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 to meet user needs and improve normal operations.Ability to work without direct supervision based on general direction provided by a superior, provide guidance to peers, and make recommendations to supervisors on best path forward. Provides regular updates to supervisor on pending tasks, pain points, and potential roadblocks.History of proactive interactions up to Tier 4 management of the organization (Directors and VP's).Demonstrated ability for completing multiple complex projects.Actively seeks and embraces coaching and mentoring from team members and contributes to the success and development of the team through effective partnering.Contributes to realization of SHC's vision. Understands how their work supports the vision and proposes better ways to achieve the vision. Articulates these ideas in a manner that builds consensus and influences decision making at the Director level.Demonstrates expertise in multiple functional and/or technical domains and develops some cross-functional knowledge and skill outside scope of area of responsibility.Ability to anticipate functional, design, or technical problems with standard recurring work or projects and negotiates a viable alternative before the issues manifests itself in production operations or development. Considers the "big picture" and develops solutions that address multiple problems or needs.Ability to independently partner with multidisciplinary teams.Track record of producing excellent work with limited problems or petent utilizing Lean concepts including visibility walls, problem solving A3's, and Gemba rounding principles. Utilizes active daily management techniques.Makes reliable operational internal decision independently and reliable tactical external decisions with limited supervision.Successfully presents moderately complex ideas and information to a variety of audiences, including senior managers and industry groups. Effective verbal, written, and interpersonal communication skills.For SHC-facing employees only:Proficient with, and contributes to, best practices and common processes for developing solutions with, and/or administering, multiple standard SHC tools, including:SAP BusinessObjects: BusinessObjects Enterprise (BOE), WebIntelligence, Crystal Reports, Xcelcius, BusinessObjects Data Services, CMC, SDKQlikViewMicrosoft SQL Server: SQL Server, SSIS, Management Studio, Team Foundation Services (TFS)Epic: Clarity ETL Admin (Compass), Clarity Data ModelOracle: Oracle RDMS10/11, Oracle ClientRemedy/ITSM Service Management (Help Desk/Support) applicationDemonstrated 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.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.), Oracle tools, and/or Epic Clarity plex Report writing & some metadata develop (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.For SoM-facing employees only:Oracle: OBIEE, Oracle RDMS10/11/19c, Oracle ClientTableau Desktop, Tableau Server, Tableau PrepAdministration, architecture tuning, and upgrades of OBIEE Environment.Demonstrated proficiency with database management systems (SQL Server and Oracle) as well as Structured Query Language (SQL).Demonstrated proficiency with Business Intelligence (BI) tools and best practices.Licenses and CertificationsNone#LI-AL1 These principles apply to ALL employees:SHC Commitment to Providing an Exceptional Patient & Family ExperienceStanford 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 careShow Me the Way: Guide and prompt my actions to arrive at better outcomes and better healthCoordinate 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.

Keywords: Stanford Health Care, Redwood City , SENIOR BUSINESS INTELLIGENCE ANALYST, Other , Redwood City, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Redwood City RSS job feeds