CambridgeRecruiter Since 2001
the smart solution for Cambridge jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Professions Jobs

Now Hiring Class A CDL Drivers - Home Daily
Company: Premier Transportation
Location: Taunton
Posted on: 01/19/2021

Warehouse Worker - Night Shift - McKesson
Description: Location 9 Aegean Drive - Methuen / MA Employment type Full-Time Pay 16.40/hour Benefits Medical, Dental, Vision, 401K, Paid Time-Off Job description Description: Join our team of dedicated associates (more...)
Company: McKesson
Location: Methuen
Posted on: 01/19/2021

TEAM DRIVERS --- Apply to the Top 10 Companies for Teams
Description: Hiring CDL drivers in your area. Apply once and choose a trucking job that works for you. Get home when you want to, and get paid what you deserve Available
Company: Live Trucking
Location: Concord
Posted on: 01/19/2021

CDL A Regional Truck Driver - Dedicated
Description: Join the Cowan Family as a regional road driver out of Uxbridge, MA. You'll enjoy our newly increased pay packages with a variety of schedules and shifts to fit your lifestyle. As a company driver, you'll (more...)
Company: Cowan Systems
Location: East Providence
Posted on: 01/19/2021

HIRING: Team Drivers - 10 Best Companies for Team Drivers
Description: Hiring CDL drivers in your area. Apply once and choose a trucking job that works for you. Get home when you want to, and get paid what you deserve Available
Company: Live Trucking
Location: Peabody
Posted on: 01/19/2021

Description: We're not in the shipping business we're in the information business -Peter Rose, Expeditors Founder Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, (more...)
Company: Expeditors
Location: Peabody
Posted on: 01/19/2021

Truck Driver - Home Daily Positions - Driver Referral Program
Description: Job DescriptionNow Seeking CDL-A Company Drivers Enjoy Your Home Life With KAG - Multiple Positions Available A driving career shouldn't leave you choosing between being home or making great money. With (more...)
Company: Kenan Advantage Group - Merchant Gas
Location: Plymouth
Posted on: 01/19/2021

CDL Team Truck Driver
Description: Hiring CDL drivers in your area. Apply once and choose a trucking job that works for you. Get home when you want to, and get paid what you deserve Available
Company: Live Trucking
Location: Peabody
Posted on: 01/19/2021

Food Production Associate
Description: WE ARE PEOPLEREADY Staffing. Its what we know. Because we have been providing staffing solutions, putting people to work, for nearly 30 years. Whether you are looking for work, or you are seeking workers (more...)
Company: PeopleReady
Location: Concord
Posted on: 01/19/2021

OTR CDL A Dedicated Truck Driver - Out 2-3 Weeks - $30/Hour
Description: JONES LOGISTICS DEDICATED DRIVER Jones Logistics is looking for highly motivated, outstanding, drivers to add to our fast-growing dedicated fleet with a major manufacturer in Wisconsin. As part of our (more...)
Company: Jones Logistics
Location: Concord
Posted on: 01/19/2021

Log In or Create An Account

Get the latest Massachusetts jobs by following @recnetMA on Twitter!

Cambridge RSS job feeds