Overview
Business Intelligence Analyst – Inside Higher Ed
The BI Analyst is a member of the Stanford University IT organization responsible for the development of new analytics solutions as well as supporting and maintaining existing solutions. Under limited supervision, the BI Analyst performs moderately complex project and analytical work in a wide range of business intelligence activities to ensure the uniformity, accuracy, and semantic consistency of enterprise data through the application of effective data management, security, stewardship, and governance processes.
Core Duties
- Perform activities involving decision support systems, query and reporting, online analytical processing, data profiling (slice & dice, drilling), statistical analysis, forecasting, and data mining. Develop insightful BI reports (KPIs, metrics, ad-hoc 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 BI solutions. Facilitate working sessions with central and distributed end users and management to identify and document 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 causes for complex data problems; recommend solutions and communicate organizational impact.
- Perform fit-gap analysis comparing existing reporting solutions with BI strategy and assess compliance with best practices and standards.
- Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document testing results.
- Build long-term relationships with multiple business partners to drive engagement in IT strategy and influence prioritization of requirements.
- Build long-term relations with IT teams; educate teams on project context and engage them to ensure solution quality and targeted business outcomes.
Education and Experience
- Bachelor's degree and three years of relevant experience, or a combination of education and relevant experience in a quantitative discipline (e.g., economics, finance, statistics, or engineering).
Knowledge, Skills and Abilities
- Knowledge of computer system capabilities, business processes and workflow.
- Ability to understand and apply the software development lifecycle and project management techniques.
- Ability to review business processes and translate into BI reporting and analysis solutions.
- Experience in data analysis and root cause analysis; strong problem solving and analytical thinking.
- Experience with enterprise applications and database-driven applications.
- Expertise with SQL (Structured Query Language).
- Experience with relational and dimensional data modeling.
- Knowledge of BI tools such as Tableau and Oracle applications.
- Proficiency with Microsoft Excel and the Microsoft Office suite.
- Experience with report and analysis design and UI/UX best practices.
- Strong writing and analytical skills; ability to manage multiple priorities.
- Ability to communicate clearly in technical and non-technical environments; effective listening and facilitation skills.
Certificates and Licenses
- Tableau, Oracle, SQL and BI certificates are desirable.
Additional Information
- Schedule: Full-time
- Job Code: 4738
- Employee Status: Regular
- Grade: J
- Requisition ID: 82438
Location: Business Affairs: University IT (UIT), California, United States
Equal opportunity: 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.
#J-18808-Ljbffr