The Business Intelligence (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 that ensure the uniformity, accuracy, and semantic consistency of enterprise data through the application of effective data management, security, stewardship, and governance processes.
Perform assigned activities involving decision support systems, query and reporting, online analytical processing, data profiling (slice & dice, drilling), statistical analysis, forecasting, and data mining. Develop insightful business intelligence 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 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.
Builds long-term relationships between multiple business partners to drive engagement in IT strategy. Influences business partner decision making to optimize requirements prioritization.
Builds long-term relations with IT teams. Educates these teams on project's business technical context and engages them to ensure solution quality and targeted business outcomes.
Education and Experience
Indicate only the required type of education and years of experience.
Bachelor's degree and three years of relevant experience or combination of education and relevant experience in a quantitative discipline such as 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.
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.
Expertise with SQL (Structured Query Language).
Experience with relational and dimensional logical data modeling.
In-depth knowledge of and ability using analytical and business intelligence tools including Tableau and Oracle applications.
Proficiency using Microsoft Excel and strong experience with the Microsoft Office suite.
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 manage multiple priorities concurrently.
Proven problem solving and analytical thinking and ability to approach problems logically and systematically.
diverse and distributed organization.
Exceptional communications skills (written and verbal), including the ability to communicate in both technical and non-technical environments. Ability to interpret technical jargon and concepts, and to present information to non-technical audiences. Effective listening skills with demonstrated ability to build feedback loops. Strong facilitation and process skills.
Certificates and Licenses
Tableau, Oracle, SQL and BI certificates are desirable.
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: Business Affairs: University IT (UIT), 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 ...equal 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.