Business Intelligence Analyst
Stanford University
Stanford's Graduate School of Business (GSB) has built a global reputation based on its immersive and innovative management programs. We provide students a transformative leadership experience, pushing the boundaries of knowledge with faculty research, and offering a portfolio of entrepreneurial and non-degree programs that deliver global impact. We invite you to be part of our mission of developing innovative, principled, and insightful leaders who change lives, change organizations, and change the world.
Stanford Graduate School of Business seeks a Business Intelligence (BI) Analyst. The BI Analyst will work to develop a robust data-informed ecosystem for the GSB External Relations Office. The analyst will be part of a groundbreaking and innovative analytical approach to both alumni relations and development at the GSB. This position will focus on the long-term technical infrastructure and leverage university-wide resources to support the team's day-to-day operations and strategy.
In this role, you will be able to design compelling information-sharing systems, articulate and capture the impact of External Relations within the GSB, act as a trusted partner, collaborator/advisor, and grow in a hands-on, supportive, data-informed community.
Your primary responsibilities* include:
- Perform activities involving decision support systems, query and reporting, online analytical processing, data profiling (OLAP cubes, slice & dice, drilling), statistical analysis, forecasting, and data mining to support long-range planning for development and alumni relations. Develop insightful business intelligence reports (KPIs, metrics, ad-hoc queries), dashboards, scorecards, continuous monitoring (thresholds), and/or ad hoc analyses that facilitate an at-a-glance understanding of the current state of campaigns and other initiatives. Clean and transform data as required to deliver actionable information.
- Manage the effort with IT in creating user reports that summarize and aggregate existing data sources.
- Participate in creating and maintaining Tableau dashboards that visualize trends and patterns in data sets.
- Develop ad hoc analyses of one-off studies/experiments capturing the impact of organizational initiatives, events, and digital products.
- Collaborate with application developers, end users, vendors, and management to ensure the creation and delivery of business intelligence solutions, such as creating and maintaining Oracle Apex web applications and department-specific database enhancements.
- In collaboration with leadership, facilitate working sessions with central and distributed end users and management to identify and document current information flows, data models, reporting systems, and user populations and coordinate with current and future initiatives impacting reporting.
- Originate and coordinate data governance and data stewardship in line with university-wide policies and industry best practices.
- Collaborating directly with colleagues, use reports and analyses to identify potentially problematic data, make corrections, and eliminate root causes for various complex data problems (e.g., input errors, missing values, or inaccurate data). Recommend possible solutions and communicate their organizational impact.
- Perform fit-gap analysis comparing existing reporting solutions with a coherent long-range 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 testing results.
To be successful in this position, you will bring:
- Bachelor’s degree and three years of relevant experience or combination of education and relevant experience. Experience in a quantitative discipline such as economics, finance, statistics, or engineering. Experience in higher education 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 applications and database-driven applications.
- Experience with relational and dimensional logical data modeling.
- In-depth knowledge of and ability using MS Office, Google Suite, analytical and business intelligence programs such as OBIEE, business objects, 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.
- Ability to work a hybrid schedule.
- Ability to work occasional evenings and weekends.
The expected pay range for this position is $135,236 to $165,000 per year.
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.
Why Stanford is for You
Stanford’s dedicated 16,000 staff come from a breadth of educational and career backgrounds. We are a collaborative environment that thrives on innovation and continuous improvement. At Stanford, we seek talent committed to excellence, driven to impact the future of our legacy, and improve lives on a global sphere. We provide competitive salaries, excellent health care and retirement plans, and a generous vacation policy, including additional time off during our winter closure. Our generous perks align with what matters to you:
- Freedom to grow. Take advantage of career development programs, tuition reimbursement, or audit a course. Join a TedTalk, film screening, or listen to a renowned author or leader discuss global issues.
- A caring culture. We understand the importance of your personal and family time and provide you access to wellness programs, child-care resources, parent education and consultation, elder care and caregiving support.
- A healthier you. We make wellness a priority by providing access to world-class exercise facilities. Climb our rock wall, or participate in one of hundreds of health or fitness classes.
- Discovery and fun. Visit campus gardens, trails, and museums.
- Enviable resources. We offer free commuter programs and ridesharing incentives. Enjoy discounts for computers, cell phones, recreation, travel, entertainment, and more!
We pride ourselves in being a culture that encourages and empowers you.
How to Apply
We invite you to apply for this position by clicking on the “Apply for Job” button. To be considered, please submit a cover letter and résumé along with your online application.
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.