FPO Business Analytics Analyst - Fpo Administration ( Info Sys Anl 4 )
Our legacy of unsurpassed patient care and unceasing mission to integrate high-tech medical research with clinical operations has led to our prestigious standing as one of the top 10 hospitals in the nation according to U.S. News & World Report. As a premier health care institution dedicated to advancing health worldwide, UCSF Medical Center can also be the best place to advance and shape your career.
The medical center's employees are one of the most important reasons why we are recognized as one of the nation's best hospitals. To work at UCSF Medical Center is to be part of an institution that provides the highest caliber of care to patients; a nurturing, dynamic and team-oriented atmosphere in which to best use your skills and talents.
The Faculty Practice Business Operations and Analytics (FPBA) group is responsible for managing the operational and analytical tasks relating to the clinical funds flow agreement between the UCSF Health System and the School of Medicine.
This position interacts with Faculty Practice Finance, UCSF Health Strategic Support, Ambulatory Practice Leadership, Revenue Cycle Operations, and Clinical Department MSOs and analysts.
The ongoing development and operation of the clinical funds flow process requires an individual with a wide range of skills including program management, database programming, reporting and analysis. The Faculty Practice Business Analytics (FPBA) group is seeking a qualified business intelligence professional with proven experience in in these areas.
This position will report to the Director of the Business Operations and Analytics within the Faculty Practice Administration organization. The position will be responsible for data modeling, development of stored procedures, report writing, and functional documentation in support of the clinical funds flow process. The incumbent will provide reporting and analysis support for the faculty practice administration and ambulatory operations using the FPBA DART data mart and the DART BI platform. The data accessible through DART is critical to the operations of not only the FPO offices, but of the School of Medicine and UCSF Health System departments that utilize this resource.
- Minimum three years relevant experience
- Bachelor's degree in related field, with work in a quantitative discipline
- Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digitalforensics, including data collection, examination and analysis
- Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions
- Experience in data integration and the specification of data services
- Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner
- Works independently and as part of a team. Demonstrated problem-solving skills. Ability to learn effectively and meet deadlines. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments
- Strong analytical skills with demonstrated methods for implementing processes to ensure accuracy and consistentcy with deliverables
- Excellent skills in successfully managing competing priorities and tight deadlines. The ability to prioritize the deliverables of a strict production schedule and urgent ad hoc requests
- The ability to address complex, nebulous reporting and analysis problems with originality and creativity. Significant investigative and problem solving skills
- Excellent and advanced communications skills to convey complex information clearly and concisely to all levels of staff and management
- Hands-on experience and expertise in writing and executing complex T-SQL or PL/SQL queries to extract data from a both internal and external sources
- The flexibility to orient and work at all UCSF Medical Center locations
- Epic Clarity Data Model Certification
- Master’s degree in business, health care administration or related field
- Knowledge of HIPAA and other relevant privacy regulations
- Familiarity with Cognos 10.2 and/or QlikView applications
- Knowledge of revenue cycle standards, professional fee billing terminology and methodologies (i.e., ICD-9, CPT, RBRVS)
- Experience with data visualization and reporting in a 21st century Business Intelligence tool
- Hands-on experience and expertise in designing portals, reports, dashboards, and analytics with professional report building software packages. Proficient with report terminology and concepts such as drill-down, roll-up, aggregation, etc
- Ability to write clear functional specifications, presentations, training materials, and technical documentation
- Knowledge of faculty practice operations, finance, healthcareinformation technology, and revenue cycle activities
- Strong knowledge of relevant RDBMS systems and BI reporting tools, and the policies, principles, best practices, and standards involved with effective BI and analytics program support. Solid understanding of OLTP, OLAP information systems, data warehouses, and data marts
- Familiarity with data quality and governance issues and requirements
- Technical skill to develop, implement and test disaster recovery functions using backup technologies
- Demonstrated project management skills
- Demonstrated experience with database administration. Advanced knowledge of database management systems and standards. Knowledge relating to highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. Knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level
- Familiarity with logical data design and data mapping or data conversion
- Advanced knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Advanced knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
- Knowledge of test application code in client server environment
- In-depth knowledge of various areas of IT. Broad knowledge of the IT environment
- Advanced skills associated with programming design, modification and implementation. Advanced knowledge of secure software development. Demonstrated ability to create software specifications
Living Pride Standards
- Demonstrates service excellence by following the Everyday PRIDE Guide with the UCSF Medical Center standards and expectations for communication and behavior. These standards and expectations convey specific behavior associated with the Medical Center’s values: Professionalism, Respect, Integrity, Diversity and Excellence, and provide guidance on how we communicate with patients, visitors, faculty, staff, and students, virtually everyone, every day and with every encounter. These standards include, but are not limited to: personal appearance, acknowledging and greeting all patients and families, introductions using AIDET, managing up, service recovery, managing delays and expectations, phone standards, electronic communication, team work, cultural sensitivity and competency.
- Uses effective communication skills with patients and staff; demonstrates proper telephone techniques and etiquette; acts as an escort to any patient or family member needing directions; shows sensitivity to differences of culture; demonstrates a positive and supportive manner in which patients / families/ colleagues perceive interactions as positive and supportive. Exhibits team work skills to positively acknowledge and recognize other colleagues, and uses personal experiences to model and teach Living PRIDE standards.
- Exhibits tact and professionalism in difficult situations according to PRIDE Values and Practices
- Demonstrates an understanding of and adheres to privacy, confidentiality, and security policies and procedures related to Protected Health Information (PHI) or other sensitive and personal information.
- Demonstrates an understanding of and adheres to safety and infection control policies and procedures.
- Assumes accountability for improving quality metrics associated with department/unit and meeting organizational/departmental targets.
- Keeps working areas neat, orderly and clutter-free, including the hallways. Adheres to cleaning processes and puts things back where they belong. Removes and reports broken equipment and furniture.
- Picks up and disposes of any litter found throughout entire facility.
- Posts flyers and posters in designated areas only; does not post on walls, doors or windows.
- Knows where the Environment of Care Manual is kept in department; corrects or reports unsafe conditions to the appropriate departments.
- Protects the physical environment and equipment from damage and theft.