Strategy Analyst at Stanford University in Stanford, CA

Specify, devise, and deploy enterprise-wide analysis, processes, reporting and system capability solutions enabling efficient and effective decision making from enterprise applications. Business intelligence analysis and reporting results typically answer the questions of what happened, when, who and how many.

The Strategy Analyst supports the Executive Associate AD, Strategy in building and executing the strategic roadmap for Stanford Athletics. This onsite position plays a critical role in turning data into actionable insights, supporting decision-making across administration, varsity, recreation, and physical education programs. The Analyst will blend quantitative analysis, business modeling, and creative problem-solving to inform priorities across financial sustainability, competitive excellence, and student-athlete experience.

Responsibilities

Core Duties:

• 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.
• Coordinate the planning, development, and presentation of training for users of BI reporting and analysis.

Minimum Education:

Bachelor’s degree.

Minimum Experience:

Three years of relevant experience or combination of education and relevant experience. Experience in a quantitative discipline such as economics, finance, statistics or engineering.

Knowledge, Skills and Abilities:

• Strong 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. High level of proficiency with data management languages and query tools such as Python, SQL, R, and/or GUI tools such as SQL Developer.
• Notable background and experience with report and analysis design.
• Experience with the application of User Interface and User Experience best practices.