Strategy Analyst

Stanford University School of Medicine; Palo Alto (CA); On-site; USD 100,000 - 150,000; Full time

Job summary

Stanford Athletics seeks a Strategy Analyst to help build and execute its strategic roadmap. This onsite role blends data analytics, business modeling, and insights to inform decisions across financial sustainability, competitive excellence, and student-athlete experience.

You will produce BI reports and dashboards, collaborate with developers and administrators, govern data, and translate complex data into actionable strategies for leadership.

Qualifications

• Bachelor’s degree required.
• Three years of relevant analytics/BI experience or a combination of education and experience.
• Experience translating business processes into BI reporting and analysis solutions.
• Strong SQL and scripting skills (Python, R) and familiarity with data modeling.
• Proficiency with MS Office and BI tools such as OBIEE, Tableau, Informatica; good UX/UI sense.

Responsibilities

• Develop BI reports, dashboards, KPIs, and adhoc analyses; support continuous monitoring.
• Collaborate with developers, end users, vendors, and management to deliver BI solutions.
• Coordinate data governance/stewardship activities and ensure data quality.
• Perform data profiling, root cause analysis, and solve data-related issues.
• Assist in training users on BI reporting and analysis tools.

Skills

BI reporting

Data analysis

Root cause analysis

SQL

Python

Tableau

Excel

SAS/R/SPSS

UI/UX

Education

Bachelor's degree

Tools

OBIEE

Informatica

MATLAB

R

SPSS

SQL Developer

Excel

Job description

Job Description

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.