Note: Not all unique aspects of the job are covered by this job description.
The expected pay range for this position is $90,000 to $140,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.
The Business intelligence (Bl) Analyst is a key member of the Information Delivery, Management and Architecture (IDMA) team within the Financial Management Services (FMS) group. This role acts as the primary liaison between IDMA and various business units at each stage in the BI solution delivery lifecycle. The Business Affairs and University IT (UIT) organizations are embarking on a long-term strategy to plan, replace, and implement new cloud-based solutions for several enterprise-wide systems. The BI Analyst will synthesize information and provide analysis in support of the strategic planning efforts. The Bl Analyst focuses on requirements gathering, business rule clarification, user acceptance testing, and change management phases of large BI project work. The BI Analyst also supports and furthers enhancements of Oracle Business Intelligence (OBI) Financial dashboard reports and ad hoc subject areas and contributes to the development of new BI solutions. This role interfaces with a broad set of stakeholders, from business owners in central units to managers and analysts in distributed business units. Additionally, the BI Analyst contributes to the ongoing Data Stewardship efforts for FMS to ensure that Finance data and metadata follow the university's governance standards.
Duties, Responsibilities and Role:
Carry out analysis in support of the long-term strategic plan and the roadmap for data analytics and reporting.
Lead and contribute to project evaluation and scoping for reporting and data management initiatives and continuous improvement of the solutions that IDMA supports.
Facilitate working sessions with central and distributed users and managers to identify and document business needs for financial reporting.
Lead the development of key project deliverables and artifacts such as business requirements and fit/gap analyses.
Act as the business lead in the development of key project deliverables and artifacts such as functional design documents and report mockups.
Provide analysis and recommendations regarding data management and the design of dashboards and reports.
Facilitate and support the use and development of Oracle Business Intelligence Analysis-based reports and dashboards for central and distributed use cases.
Manage User Acceptance Testing for issues and enhancements, and design and execute effective and efficient Bl test cases.
Support Data Governance and alignment efforts across multiple functions at Stanford (HR, Sponsored Research, Student, etc.), and implements standards and practices for metadata management and data management for the university's enterprise data.
Facilitate Data Stewardship for Finance by developing and enhancing business metadata in collaboration with business owners and subject matter experts in central and distributed units, including establishing official names and definitions for Finance concepts and terms.
Assist in the review of Financial Reporting data enhancements to ensure consistency in names, definitions, and placement in the OBI ad hoc presentation layer.
* - Other duties may also be assigned
Education & Experience:
Bachelor's degree and five to seven years of relevant experience or combination of education and relevant experience in a quantitative discipline such as economics, finance, statistics, computer science, or engineering.
Knowledge, Skills and Abilities:
Three to five years of experience in enterprise data management and delivery (preferably financial data) or providing consultation to organizations that are similar to Stanford in size and complexity.
Strong analytical capabilities, strategic thinking skills, and problem-solving abilities.
Excellent oral and written communication skills.
Extensive experience eliciting, interpreting, and documenting business requirements preferably in the context of Bl or reporting initiatives.
Prior success in positions requiring indirect leadership and high levels of self-directed work.
Demonstrated project management experience, including the ability to lead workstreams on systems and reporting projects to completion and ensure high quality deliverables.
Proven experience in facilitating large and diverse groups.
Demonstrated experience with Business Intelligence tools.
Proven experience in designing and/or delivering interactive reporting solutions that meet the needs of diverse sets of stakeholders.
Expertise in MS Excel and extensive use of its advanced analytical capabilities including pivot tables and lookup and reference formulas.
Experience with Oracle Business Intelligence Analysis/Answers or other BI tools preferred.
Experience with Oracle E-Business Suite is a plus.
Previous higher education and Stanford University experience preferred.
Certifications and Licenses:
Constantly perform desk-based computer tasks.
Frequently sit, sort, file paperwork or parts, grasp lightly, and use fine manipulation, lift, carry, push and pull objects that weigh 10 pounds or less.
Occasionally write by hand, twist, bend, stoop and squat.
Rarely stand, walk, reach or work above shoulders and use a telephone.
* - 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.
May work extended hours during peak business cycles.
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.
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.
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.
Why work at Stanford?Stanford University has changed the world, over and over again.We are one of Silicon Valley's largest employers - and also one of the most unique. Our mission is to educate future leaders and promote interdisciplinary, world-class research and teaching. This passion makes Stanford an intensely creative, rewarding, and challenging place to work. At the same time, our traditions of respect and collaboration sustain a humane, supportive environment in which to pursue your life and your career.At Stanford you'll work with bright, diverse, dedicated people. You'll find encouragement to learn and grow. You'll enjoy excellent benefits and an outstanding environment. How will it change you?