This is a 1 year fixed term position. The expected pay range for this position is $135,236 to $150,000 per annum. Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location and external market pay for comparable jobs. At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website (https://cardinalatwork.stanford.edu/benefits-rewards) provides detailed information on Stanford's extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process. Stanford University seeks people committed to excellence and to improving our world and, in turn, is dedicated to supporting its employees as they develop their careers and enrich their lives. Stanford's Business Affairs provides administrative policies, infrastructure, systems, services, and support for the benefit of the university community. Financial Management Services (FMS), a department within Business Affairs, is responsible for creating an ecosystem which promotes innovative and sound financial administration policies and practices that balance controls, compliance, and customer service. FMS is primarily responsible for financial policy oversight, quality assurance and financial services at Stanford University and its affiliated entities. It also serves as a liaison to the hospitals and the Stanford Linear Accelerator Center (SLAC). The FMS work environment is grounded by core values that include cultivating growth, celebration and appreciation, and collaborating with curiosity in order to nurture an inclusive environment where everyone is valued, respected, and can thrive. JOB PURPOSE FMS is a partner on the long-term strategy to plan, replace, and implement new cloud-based solutions for several enterprise-wide systems. Implementation of the new cloud-based HCM application is sponsored by University HR, Financial Management Services and University IT. The Business Intelligence Analyst is a key member of the Financial Systems & Reporting (FSR) team within the FMS group. FSR seeks an analyst to support the Pinnacle project which will transition the university HR, Timekeeping and Payroll systems to Oracle Cloud. The analyst will support reporting integration efforts, including testing and operationalization of new reports, as well as testing of finance data flows between payroll and the university data warehouse. This also includes supporting projects parallel to Pinnacle, mainly the OBI retrofit project, operational reporting and data governance updates. CORE DUTIES Your Responsibilities Will Include: * Perform assigned activities involving decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting, and data mining. * Manipulate data into user-friendly formats for diverse audiences and uses, collect and study data and produce analytics solutions for organizational monitoring, improvement, efficiency, and/or decision-making. * Develop insightful business intelligence reports (KPIs, metrics, adhoc queries), dashboards, scorecards, continuous monitoring (thresholds), and/or ad hoc analyses. * Clean and transform data as required to deliver actionable information. * Collaborate with application developers, end users, vendors, and management to ensure the creation and delivery of business intelligence solutions. * Facilitate working sessions with central and distributed end users and management to identify and document current information flows, data models, reporting systems, user populations, and coordinate with current and future initiatives impacting reporting. * Originate and coordinate data governance/stewardship assignments. * Use reports and analyses to identify potentially problematic data, make corrections, and eliminate root cause for a range of complex data problems (e.g.: input errors or inadequate field edits), and recommend possible solutions and communicate their organizational impact. * Perform fit-gap analysis comparing existing reporting solutions with BI strategy and assess compliance with best practices and established standards. * Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing. * This position may be heavily involved with the following applications: Oracle, OBI, ServiceNow, SQL, Tableau, Incorta, Python, RStudio. Knowledge on how to gather data from these and other systems is highly desirable. Note: Not all unique aspects of the job are covered by this job description MINIMUM REQUIREMENTS Education & Experience: * Bachelor's degree plus three years of applicable experience, or a combination of education and relevant work experience. Knowledge, Skills and Abilities: * Knowledge of computer system capabilities, business processes and workflow. * Ability to understand and apply the software development lifecycle and project management techniques. * Demonstrated ability to review business processes and translate into BI reporting and analysis solutions. * Experience in data analysis and root cause analysis and developing problem solving and analytical thinking capabilities. * Demonstrated ability with enterprise application and database driven applications. * Experience with relational and dimensional logical data modeling. * In-depth knowledge of and ability using MS Office; analytical and business intelligence programs such as OBIEE, business objects, Tableau, Python, etc.. * Extensive background and experience with report and analysis design and application of User Interface and User Experience best practices. * Strong writing and analytical skills. * Experience at Stanford University and/or Oracle EBS, PeopleSoft HRMS and Oracle HCM is preferred. Certifications and Licenses: None PHYSICAL REQUIREMENTS* * Constantly perform desk-based computer tasks. * Frequently sitting. * Occasionally stand/walk, reach/work above shoulders, use a telephone, writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds. * Rarely twist/bend/stoop/squat, sort/file paperwork or parts, lift/carry/push/pull objects that weigh 11-20 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 the job. WORKING CONDITIONS: * May work extended hours, evenings and weekends. 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. WHY STANFORD IS FOR YOU Stanford University has revolutionized the way we live and how it enriches the world. Supporting this mission is our diverse and dedicated 17,000 staff. We seek talent driven to impact the future of our legacy. Our culture and unique perks empower you with: * Freedom to grow. We offer career development programs, tuition reimbursement, or audit a course. Join a TedTalk, film screening, or listen to a renowned author or global leader speak. * A caring culture. We provide superb retirement plans, generous time-off, and family care resources. * A healthier you. Climb our rock wall or choose from hundreds of health or fitness classes at our world-class exercise facilities. We also provide excellent health care benefits. * Discovery and fun. Stroll through historic sculptures, trails, and museums. * Enviable resources. Enjoy free commuter programs, ridesharing incentives, discounts and more! * Redwood City. Our new Stanford Redwood City campus, which opened in 2019, is the workplace for approximately 2,700 staff, including FMS, whose jobs are important to supporting the university's mission. The campus will offer amenities such as onsite cafes and a dining pavilion, a high-end fitness facility with an outdoor pool, and a childcare center for Stanford families. The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned. Consistent with its obligations under the law, the University will provide reasonable accommodations to applicants and employees with disabilities. Applicants requiring a reasonable accommodation for any part of the application or hiring process should contact Stanford University Human Resources by submitting a contact form. Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Additional Information * Schedule: Full-time * Job Code: 4738 * Employee Status: Fixed-Term * Grade: J * Requisition ID: 106388 * Work Arrangement : Hybrid Eligible