Oracle BI Reporting Analyst (Hcm, Faw)

Work Location: Stanford's Redwood City, CA campus

Work Schedule: Hybrid work schedule (at least 2 days per week on-site)

University IT (UIT), part of the Business Affairs organization at Stanford University, is dedicated to delivering world-class service and technological solutions to advance research, teaching and learning, administration, and healthcare. UIT is embarking on a long-term strategy to plan, replace, and implement new cloud-based solutions for several enterprise-wide systems.

UIT seeks an experienced Business Intelligence Reporting Analyst to support the technical implementation of the University's cloud-based Human Capital Management (HCM) and Enterprise Learning Management (ELM) software application suite as part of the Pinnacle program. Pinnacle includes replacement of the legacy HR, Payroll and ELM systems. The Oracle HCM Business Intelligence Reporting Analyst will be responsible for performing 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.

Implementation of the new cloud-based HCM/ELM application is sponsored by University HR, Financial Management Services and University IT.

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, 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.

MINIMUM REQUIREMENTS:

Education & Experience:

Bachelor's degree 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, Skills and Abilities:

• Proficiency with Oracle HCM Cloud reporting and analytics tools and solutions, business processes, and workflow.

• Demonstrated report and analytic development ability with Oracle HCM Cloud enterprise application and database driven applications.

• Solid understanding of Oracle's analytics such as Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), and Autonomous Data Warehouse (ADW)

• Experience with Business Intelligence Cloud Connector (BICC), Oracle Transactional Business Intelligence (OTBI), BI Publisher and OBIEE (or OAS).

• Sound knowledge of analytical and ETL tools such as Informatica, Tableau, etc.

• Demonstrated ability to review business processes and translate into BI reporting and analysis solutions.

• Experience with relational and dimensional logical data modeling.

• Extensive background and experience with report and analysis design and application of User Interface and User Experience best practices.

• Experience working with Oracle on Product bugs

• Experience in data analysis and root cause analysis and developing problem solving and analytical thinking capabilities.

• Ability to understand and apply the software development lifecycle and production change control and project management techniques.

• Skilled in facilitating group meetings, including discussions with business owners and users as well as IT development and technical teams working on integration, data flows and reporting.

• Excellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needs.

PREFERRED REQUIREMENTS:

Knowledge, Skills and Abilities:

• Project management skills as needed.

Certifications and Licenses:

• Oracle HCM Cloud Certification

• Fusion Analytics Warehouse Solution Engineer Specialist Certification

PHYSICAL REQUIREMENTS*:

• Constantly perform desk-based computer tasks.

• Frequently sit, grasp lightly/fine manipulation.

• Occasionally stand/walk, use a telephone.

• 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.

WORKING CONDITIONS:

• May work extended hours, evenings and weekends.

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.

The expected pay range for this position is $92,000 - 147,000 per annum.

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.

At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website (https://cardinalatwork.stanford.edu/benefits-rewards) provides detailed information on Stanford's extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process.

Why Stanford is for You:

Stanford University has revolutionized the way we live and enrich the world. Supporting this mission is our diverse and dedicated 17,000 staff. We seek talent driven to impact the future of our legacy. Our culture and unique perks empower you with:

• Freedom to grow. We offer career development programs, tuition reimbursement, or audit courses. Join a TedTalk, film screening, or listen to a renowned author or global leader speak.

• A caring culture. We provide superb retirement plans, generous time-off, and family care resources.

• A healthier you. Climb our rock wall or choose from hundreds of health or fitness classes at our work-class exercise facilities. We also provide excellent health care benefits.

• Discovery and fun. Stroll through historic sculptures, trails, and museums.

• Enviable resources. Enjoy free commuter programs, ridesharing incentives, discounts and more!

• Redwood City. Our Stanford Redwood City campus, opened in 2019, is the workplace for approximately 2,700 staff whose jobs are important to supporting the University's mission. The campus offers amenities such as an onsite cafe and a dining pavilion, a high-end fitness facility with an outdoor pool, and a childcare center for Stanford families.

Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.

Additional Information

• Schedule: Full-time

• Job Code: 4738

• Employee Status: Regular

• Grade: J

• Requisition ID: 100572

• Work Arrangement : Hybrid Eligible