The mission of the Office of Facilities Planning and Management (OFPM) in the School of Medicine (SoM) is to plan for and manage the facilities needs of the Stanford School of Medicine community in the areas of facilities operations, capital planning and budgeting projects from programming through occupancy, space inventory, facility assets, and health and safety. In the pursuit of this mission the office has an immediate opening for a Business Analyst who is energetic and loves a challenge.
Our ideal candidate is someone that will represent OFPM at the Enterprise Technology (E.T.) meetings and collaborate with Stanford business units like LBRE, EHS, ITS, and VSC to champion requirements needed for the School of Medicine. This position will act as a liaison between business and technical teams working closely with functional leaders and subject matter experts to document business processes, identify business requirements, deliver/implement functionalities, and provide support to our business users. This role also requires impeccable listening and communication skills with a good understanding of how technology can be used to solve business challenges.
The Business Analyst will support OFPM with Oracle eAM, Inventory, and Procurement modules, as well as the MobileApp application. This position will be expected to gather business requirements for new or changing functionality, working with E.T. team to translate those requirements into tangible system functionalities that can be implemented and easily adopted. This position will also be responsible for creating test cases/test scripts, executing the test scripts, and providing staff with training and support materials as necessary.
On the reporting side, the Business Analyst will need to be familiar with tools like BI, Tableau, and Smartsheet so to create reports and dashboards that can visually display key business metrics. This position will participate in reporting system upgrades, enhancements and change requests, as well as planning, conducting, and documenting testing results. Additionally, the Business Analyst will be responsible for evaluating new tools and creating prototypes to improve business efficiency.
Duties include:
- Translate business processes into system requirements and develop systems solutions.
- Conduct functional requirements analysis and work with IT developers to design new solutions or improve existing solutions
- Perform thorough and detailed system testing for new tools, systems upgrade, patches; and document results to share
- Review, research, and evaluate software to determine its usefulness and appropriateness as related to existing or proposed business systems; assist or develop preliminary and detailed system design documentation
- Able to analyze user issues, and determine the best solution that would work across the team/departments and achieving value for many
- Work with users to assess requests, document business requirements, and implement solution which may include tools like Smartsheet, Tableau, Box, Qualtrics, Excel, and OBI Reports
- Develop insightful business intelligence reports (KPIs, metrics, adhoc queries) and/or dashboards, and having the ability to identify potential problematic data areas, suggest solutions, and implement the solutions
- Develop instructional materials, training and job aids
- Analyze data and provide data sets to users for analysis. May include development of operational and analytical reports for end users
- Liaise with external vendors or partners in support of business systems, which may include system development and implementation
- Understand data flows, data contents, and able to perform data validations
- Examine data problem areas, find process redundancies, and automate/standardize the data collection process
- Support Website updates
* - Other duties may also be assigned.
DESIRED QUALIFICATIONS:
- Experience with Oracle Financial systems, specifically with eAM, Inventory, and Procurement modules
- Experience supporting a Work Request System and demonstrating a strong customer focus, business process understanding, user requirements definition, technical consulting, negotiating skills and teamwork
- Expertise in creating BI reporting solutions with data sourcing, system integration, and dashboards/reports creation in Tableau
- Experience with the AppTree Mobile App
- Experience with Excel VB, PLSQL, databases, OBIEE, FileMaker, Smartsheet, Python, and other various reporting and business tools
- Ability to pick up new tools and create sample proof of concepts to demonstrate how the tool can meet a specific need.
- Ability to pull data from various sources and perform data integration.
- Strong analytical skills and ability to perform data/functionality gaps between current and new systems
- Previous Stanford experience a plus.
EDUCATION & EXPERIENCE (REQUIRED):
- Bachelor's degree and five years relevant experience or a combination of education and relevant experience.
KNOWLEDGE, SKILLS AND ABILITIES (REQUIRED):
- Knowledge of, computer system capabilities, business processes, and workflow.
- Experience with enterprise applications and understanding of database driven applications.
- Strong understanding of the software development life cycle.
- Knowledge of principles and techniques used in conducting management studies and in systems analysis.
- Current knowledge of rapidly changing computer technology.
- Skill in conducting interviews and facilitating group meetings.
- Skill in developing and conducting training programs.
- Excellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needs.
- Strong listening, negotiation and conflict resolution skills.
- Ability to design and document complex business systems.
- Proven problem solving and analytical thinking and ability to approach problems logically and systematically.
PHYSICAL REQUIREMENTS*:
- Constantly perform desk-based computer tasks.
- Frequently sit, grasp lightly/fine manipulation.
- Occasionally stand/walk, use a telephone.
- Rarely writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds.
* - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.
WORKING CONDITIONS:
WORK STANDARDS:
- Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
- Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
- Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.
As an organization that receives federal funding, Stanford University has a COVID-19 vaccination requirement that will apply to all university employees, including those working remotely in the United States and applicable subcontractors. To learn more about COVID policies and guidelines for Stanford University Staff, please visit https://cardinalatwork.stanford.edu/working-stanford/covid-19/interim-policies/covid-19-surveillance-testing-policy
