Business Systems Analyst

Harvard University Information Technology (HUIT) is a community of Information Technology professionals committed to delivering service and technological solutions in support of teaching, learning, research and administration.

Job-Specific Responsibilities:

• Write and maintain calculation scripts in Oracle Planning's calc scripting language to model complex business logic and calculations for planning models.
• Define and maintain business rules in Oracle Planning and Groovy to enforce validation, constraints, and automation across planning processes.
• Configure drivers, dimensions, hierarchies and other metadata aspects of Oracle Planning models.
• Perform testing, debugging and troubleshooting of business rules to ensure calculations are functioning as intended.
• Provide ongoing support and guidance to business users on Oracle Planning functionality and processes.
• Analyze business requirements and workflow needs to recommend enhancements to existing Oracle Planning configurations.
• Develop training and documentation materials for business users.
• Collaborate with stakeholders to translate business needs into systems requirements and scoping.
• Work on an Agile team to deliver technical solutions that meet our user's needs.
• Ensure that operational tasks are completed on time and coordinate with business units as needed.
• Participate in production support by responding to user tickets, user questions, system issues and requests for data sets, reports and system enhancements. Independently research and troubleshoot any issues. Consult other analysts as needed.
• Identify opportunities for process and/or system improvements. Make suggestions to implement those changes.
• Analyze business processes and requirements and document functional specifications for system enhancements and new applications.

Qualifications

Basic Qualifications:

• 5+ years of post-secondary education or relevant work experience.

Additional Qualifications and Skills:

• 5+ years of experience with Oracle Planning, Hyperion Financial Management/Planning, and SmartView.
• Expert knowledge of Oracle Planning calc scripting language, Groovy rules, and SmartView.
• Experience in higher education (a strong plus).
• Experience with configuring drivers, dimensions and other metadata.
• Experience with documenting requirements and functional specifications.
• Experience with testing and supporting business applications.
• Experience with project management methodologies.
• Agile project management and Jira tracking tool (a plus).
• Oracle Strategic Modeling (a plus).
• Excel VBA (a plus).
• Oracle Developer (a plus).
• SQL language (a plus).
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.

Certificates and Licenses:

• Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred.
• Any Oracle EPM Certifications (a plus).