Business Intelligence Analyst - SLAC Budget Office

Position Overview:

SLAC National Accelerator Laboratorys Business Services Division (BSD) has an exciting opportunity for a Business Intelligence Analyst in the Office of the Chief Financial Officer (OCFO). Reporting to the SLAC Business Intelligence Manager, you will have the opportunity to apply a variety of skills in business intelligence, analytics data management, and data modeling. You will also provide management decision support using PeopleSoft, Workday Adaptive, SQL, Tableau, and Excel-based tools.

This position is expected to maintain an effective and engaged working relationship across all finance functions at SLAC (peers within and outside of the team, business managers, finance managers, cost account managers (CAMS), Principal Investigators, directorate management, Controller's Office, etc.). The ideal candidate is skilled in balancing customer service and support with controls and compliance.

Your specific responsibilities include:

• Under limited supervision, perform 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 (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.

To be successful in this position you will bring:

• Bachelor's degree in in Computer Science, Computer Information Systems, Management Information Systems and 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 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..
• Extensive background and experience with report and analysis design and application of User Interface and User Experience best practices.
• Strong writing and analytical skills.
• Extensive background and experience with report and analysis design.
• Experience with the application of User Interface and User Experience best practices.
• Familiarity with Workday Adaptive Planning preferred.

Certifications and Licenses: None

SLAC employee competencies:

• Effective Decisions: Uses job knowledge and solid judgment to make quality decisions in a timely manner.
• Self-Development: Pursues a variety of venues and opportunities to continue learning and developing.
• Dependability: Can be counted on to deliver results with a sense of personal responsibility for expected outcomes.
• Initiative: Pursues work and interactions proactively with optimism, positive energy, and motivation to move things forward.
• Adaptability: Flexes as needed when change occurs, maintains an open outlook while adjusting and accommodating changes.
• Communication:¿Ensures effective information flow to various audiences and creates and delivers clear, appropriate written, spoken, presented messages
• Relationships: Builds relationships to foster trust, collaboration, and a positive climate to achieve.

Physical requirements and Working conditions:

• 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 his or her job.
• Given the nature of this position, SLAC is open to on-site, hybrid, and remote work options.

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 environment, safety, and security; communicates related concerns; uses and promotes safe behaviors based on training and lessons learned. Meets the applicable roles and responsibilities as described in the ESH Manual, Chapter 1General Policy and Responsibilities:
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,

-

• Classification Title: Business Intelligence Analyst 1
• Job Code: 4738 Grade: J
• Duration/Employment status: Continuing

The expected pay range for this position is $136,236 - $159,462 per annum. SLAC National Accelerator Laboratory/Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location, and external market pay for comparable jobs.