Salary Grade: JFour year fixed term position Description IR&DS (Institutional Research & Decision Support) is looking for a Business Intelligence Analyst to help analyze, define, and shape future enhancements to SIRIS (Student Integrated Reporting and Information System), a tool designed to improve student reporting and analytics capabilities at Stanford University. This position is a business/systems analyst role focused on:
business analysis (requirements gathering, process and data modeling, system testing)
business intelligence (report building, dashboards, and information delivery)
technical expertise (ETL via Informatica, Oracle and other databases, scripting (bash, perl/python/ R), etc).
This role is an opportunity to make a difference in supporting the teaching mission of the university by providing decision-makers and front-line staff with the information, understanding, and analysis they need. This position is a 4-year term limited position with a possibility of extension.
JOB PURPOSE: Under limited supervision, provide project coordination, business/data analysis, and user support in the context of SIRIS in the form of data management (including an understanding of the data flows from source systems, and real-world use cases) and design support for the SIRIS dashboard and reports; Ensure the uniformity, accuracy, and semantic consistency of the data through the application of effective data management, security, stewardship, and governance processes.
Perform assigned activities involving decision support systems query and reporting. Assist ongoing scoping, requirements gathering, prototyping and testing initiatives; Support data processing, profiling, 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.
Facilitate data stewardship efforts for additional SIRIS work, and develop the supporting metadata.
Analyze data and provide data sets to users for analysis; develop operational and analytical reports for end users.
Coordinate the development, documentation and enrichment of key conceptual and logical data models that support and underlie the SIRIS system.
Troubleshoot SIRIS business intelligence environment issues and identify opportunities for improvement. Coordinate with development team to resolve application bottlenecks and performance issues.
As part of a collaborative team, assist in the planning, coordination, and review of other information created by analytics-type staff.
Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing.
Perform fit-gap analysis comparing existing reporting solutions with BI strategy and assess compliance with best practices and established standards.
Support existing ETL processes by running and auditing ETL jobs, either as scheduled or on demand.
Troubleshoot, update, and repair existing ETL processes as needed.
* - Other duties may also be assigned
Education & Experience:
Bachelor's degree and three years of relevant experience or combination of education and relevant experience. Work experience in a quantitative discipline such as economics, finance, statistics or engineering desired. Experience with student data and/or experience in higher education strongly desired. This position requires both business and technical competence. Experience in the use of information to solve business problems required. Knowledge, Skills and Abilities:
Capabilities in the following: data mapping, conversion, table structure knowledge, running and analyzing traces, custom coding logics, issue analysis and recommendations, writing and running SQL queries, documentation skills, functional analysis, coordination of user acceptance and sign-off, business process improvement, fit/gap analysis, requirements documentation and process flow charting, presentation of options and solutions facilitation.
Strong business analysis skills, including running focus groups, developing specifications, developing documentation via reverse engineering, and vetting requirements with end-users using a variety of techniques.
Experience with university administrative systems and knowledge of higher education administrative processes. In particular, knowledge of Stanford University information systems, and administrative processes and data would be advantageous.
Business Process analysis skills, including the ability to develop models of user interaction and opportunities for optimization from user interviews, as well as mapping those into system requirements. Experience with relational and dimensional logical data modeling.
Demonstrated ability to review business processes and translate them into BI reporting and analysis solutions.
Knowledge of computer system capabilities, business processes and workflows.
Experience in data analysis and root cause analysis. Proven problem solving and analytical thinking capabilities.
Demonstrated ability with enterprise application and database driven applications.
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.
Experience with the application of User Interface and User Experience best practices.
Strong written and oral communication skills; proven presentation experience and comfort with senior management audiences and effective facilitation skills with diverse groups.
Ability to prioritize workload and work with minimal supervision.
Experience with ETL processes design, support and customization.
Constantly perform desk-based computer tasks.
Rarely writing by hand; lift/carry/push/pull objects that weigh up to 10 pounds.
* - 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.WORK STANDARDS:
Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.
We are unable to provide sponsorship for this position
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.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.
Location: Institutional Research & Decision Support, California, United States Schedule: Classification Level:
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.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
Located between San Francisco and San Jose in the heart of Silicon Valley, Stanford University is recognized as one of the world's leading research and teaching institutions. Leland and Jane Stanford founded the University to "promote the public welfare by exercising an influence on behalf of humanity and civilization." Stanford opened its doors in 1891, and more than a century later, it remains dedicated to finding solutions to the great challenges of the day and to preparing students for leadership in a complex world. The University's thriving diverse community is comprised of nearly 7000 undergraduate students, 9000 graduate students, 2000 faculty members, 1900 postdoctoral scholars, and over 11,000 academic and administrative staff in seven schools including several interdisciplinary research centers and institutes. The campus spreads over 8000 contiguous acres and nearly all undergraduates live on campus. Stanford offers bachelor's and master's degrees in addition to doctoral degrees (PhD, MD, DMA and JD) plus a number of professional and continuing education programs and certifications. More at http://facts.stanford.edu and http://www.stanford.edu.Stanford University is an eq...ual opportunity employer and is committed to increasing the diversity of its faculty. It welcomes nominations of and applications from women, members of minority groups, protected veterans and individuals with disabilities, as well as from others who would bring additional dimensions to the university’s research, teaching and clinical missions.