Financial Reporting Systems Analyst

Company: Harvard University
Location: Cambridge
Posted on: January 8, 2021

Job Description:

Job SummaryPlan and conduct comprehensive applications/web development for complex projects; typically work as part of a team to implement complex business solutions. Perform expert coding: design, develop code at an expert level, and manage development projects, teams, programs. May manage multiple projects simultaneously.Job-Specific ResponsibilitiesDuties & Responsibilities: This position will support business information and reporting needs under the supervision of the Assistant Director for Campus Services Finance and Administration (F&A) in order to coordinate, administer, maintain and support the effective use of financial reporting data. The position is responsible for running, reconciling, and distributing the monthly and quarterly financial reports for Campus Services. This position is also involved in requirements analysis, customization, testing, and/or reporting functionality of business applications to meet the needs of the Campus Services Business Units. Specific responsibilities include:Monthly, Quarterly, and Annual Reporting:

• Develop an expert knowledge of Campus Services' use of the general ledger Chart of Accounts. Maintain the segment code hierarchies and roll up structures and understand differences/mapping to the University roll up structure;
• Ensure monthly, quarterly, and annual financial reports are accurately produced, reconciled to the general ledger, and made available to business unit managers on a timely basis
• Produce the Trial balance and Fund Balance reports monthly
• Schedule the reporting process to generate P+L reports in .pdf format and refresh Excel-based P+L's on a monthly basis
• Run Detail Listing reports for each Business Unit monthly to provide supporting transaction detail to general ledger amounts
• Produce quarterly reports including the Balance Sheets, Debt Roll Forward, Transfers and Subvention, Vacation Objects, FTE Counts, and budget flux reports
• Maintain the Business Line summary reporting template, Core Funding data, Employment data, and Budget Variance reports as needed at year end
• Maintain the Campus Services SharePoint site with all financial reports on a monthly basisBudgeting and Multi-Year Financial Planning (MYFP):
  • Support the annual budget process by producing reports and templates as needed with the use of the Oracle Hyperion Enterprise Budgeting System (aka Harvard University Budgeting System - HUBS)
  • Support the financial managers and analysts by resolving issues related to their use of the Hyperion Enterprise Budgeting System as well as other budgeting issues that arise
  • Conduct annual workshops for finance and accounting staff to review the use of the Hyperion Enterprise Budgeting System and enhancements as well as other updates in its use for budget preparation
  • Process the final HUBS chart code validation to ensure all segment code data is valid
  • Execute the copy process of HUBS data from working status to submission once all budget data has been entered and verified
  • Prepare and update the MYFP Models for each annual process, and refresh them with current forecast and budget data frequently during the budget process
  • Refresh the HUBS Excel based Budget Variance reports upon request
  • Maintain the process used for Property Management Fee budgeting
  • Process the HUBS Cash Flow reports as needed
  • Maintain the Business Line summary reporting template as needed
  • Update the Core Funding data extract as needed
  • Maintain the Budget Narrative reports and Power Point presentationsTypical Core Duties
    • Participate fully in software development life cycle
    • Research, design, and implement technical solutions to deliver business requirements
    • Identify opportunities to improve and simplify applications portfolio and implement related enhancements
    • Contribute to creation and maturing of software development best practices and new technologies
    • Draw on relationship and technical skills to act as technical liaison to internal and external clients and to mentor junior staff
    • Abide by and follow the Harvard University IT technical standards, policies and Code of ConductBasic Qualifications
      • Minimum of five years' post-secondary education and/or relevant work experienceAdditional Qualifications and SkillsGeneral Requirements:BA/BS required. A minimum of 8 years experience in accounting, financial and/or business systems operations. Strong knowledge of accounting required combined with exceptional analytical ability, financial modeling experience, and knowledge of Oracle or similar general ledger accounting systems. The ideal candidate will possess excellent verbal and written communication skills, strong interpersonal skills, and the ability to work effectively as part of a team and independently in a fast-paced environment, with keen attention to detail. Must be able to manage multiple responsibilities, set priorities, take initiative and meet deadlines. Must have excellent computer skills including in-depth understanding of databases and spreadsheet formulas and macros. Report specification writing experience is helpful.
        • Knowledge of information technology applications, processes, software and equipment
        • Highly specialized knowledge of a specific technology
        • Demonstrated team performance skills, service mindset approach, and the ability to act as a trusted advisorAdditional Technology Skills Required:Microsoft Office products including Excel, Word, PowerPoint, and Outlook; Relational database concepts; familiarity with Excel based Visual Basic Macros.Strong Knowledge of the following business applications a plus:
          • Oracle Business Intelligence
          • Oracle Analytics
          • Hyperion Interactive Reporting
          • ERP General Ledger systems, preferably Oracle Financials
          • Oracle Hyperion Budgeting and Planning System
          • Oracle SmartView Reporting
          • Microsoft SharePoint
          • Qlikview Access Point for HR FTE analytics and reportingCertificates and Licenses
            • Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferredWorking Conditions
              • Work is performed in an office settingAdditional InformationOther Responsibilities:
                • Develop and execute financial reports on an ad hoc basis using business intelligence tools including Oracle SmartView, Oracle Hyperion Enterprise Budgeting System, Oracle Business Intelligence, Oracle Analytics, or Brio/Hyperion Interactive Reporting as requested (ie vendor spend analytics and P-Card dashboard)
                • Represent Campus Services as the Local Implementation Manager for Oracle Business Intelligence, Oracle Analytics, and Hyperion Enterprise Budgeting Systems and inform finance and accounting staff of relevant information and facilitate upgrades and enhancements for Campus Services
                • Participate in development projects by contributing to project plans, providing business systems analysis services, developing appropriate system testing, documentation, process/system flows, etc. as requested
                • Prepare the annual Information Technology Assessment for Campus Services and provide supporting detail
                • Maintain the Financial Reporting SharePoint site user access and folder structure
                • Troubleshoot and resolve application related problems by phone and in person; provide day-to-day support handling simple to complex user problems/requests regarding software and reporting
                • Collaborate and communicate effectively with client groups, project managers, designers, and programmers, both internal and external to the University
                • Provide support to address day-to-day operational, policy and procedural questions from finance and accounting staff as requestedJob FunctionInformation TechnologyLocationUSA - MA - CambridgeJob CodeI0758P Applications Professional IVDepartmentCS Administration & FinanceTime StatusFull-timeSalary Grade058Union00 - Non Union, Exempt or TemporaryPre-Employment ScreeningEducation, Employment, IdentityEEO StatementWe are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.

Keywords: Harvard University, Cambridge , Financial Reporting Systems Analyst, Professions , Cambridge, Massachusetts