Note: Not all unique aspects of the job are covered by this job description

Summary:

Under limited supervision, conduct complex project and analytical work in a wide range of business intelligence activities in order to provide valuable business insights to the Office of Development (OOD) and Stanford Alumni Association (SAA). The individual within this role will set organization-wide standards in reporting to ensure uniformity, accuracy, and consistency of the data and analysis shared with business users. They will drive the effort to provide business users across OOD and SAA access to the data and analytics that they need in order to do their jobs.

This is a two year fixed-term position currently scheduled to end on or around 8/31/2021.

Your responsibilities include:

• Perform assigned activities involving decision support systems, query and reporting, online analytical processing, data profiling (OLAP cubes, slice & dice, drilling), statistical analysis, forecasting, and data mining. 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.

* - Other duties may also be assigned

To be successful in the role you will bring:

• Bachelor’s degree and at least three years of relevant experience or combination of education and relevant experience (five years of experience strongly preferred).
• Experience in a quantitative discipline such as fundraising, economics, finance, statistics or engineering is preferred.
• 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, Informatica, Tableau, Matlab, SAS, R, SPSS 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. 

In addition, our preferred requirements include:

• Experience with Oracle Business Intelligence – Enterprise Edition
• Experience with SalesForce
• Experience with Google Analytics
• Knowledge of development/advancement/fundraising and how these organizations utilize data to make decisions
• Knowledge of alumni relations and how these organizations utilize data to make decisions
• Experience with PostGrads or other advancement databases
• Experience with Oracle Financials

* - 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.

Why Stanford is for You

Imagine a world without search engines or social platforms. Consider lives saved through first-ever organ transplants and research to cure illnesses. Stanford University has revolutionized the way we live and enrich 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!

How to Apply

We invite you to apply for this position by clicking on the “Apply for Job” button. To be considered, please submit your résumé and a one-page cover letter along with your online application.

Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.

Job Classification: Business Intelligence Analyst 1 

Job Family: Information Analytics

Job Series: Business Intelligence

Exemption: Exempt

Additional Information

• Schedule: Full-time
• Job Code: 4738
• Employee Status: Fixed-Term
• Grade: J