Company Description

By working at Harvard University, you join a vibrant community that advances Harvard's world-changing mission in meaningful ways, inspires innovation and collaboration, and builds skills and expertise. We are dedicated to creating a diverse and welcoming environment where everyone can thrive.

Why join the Harvard Faculty of Arts and Sciences?

The Faculty of Arts and Sciences (FAS) is the historic heart of Harvard University. It is the home of Harvard's undergraduate program (Harvard College, founded in 1636) as well as all of Harvard's Ph.D. programs (the Harvard Kenneth C. Griffin Graduate School of Arts and Sciences, founded in 1872), Harvard Athletics and the Division of Continuing Education. The 40 academic departments and 30+ centers of the FAS support a community unparalleled in its academic excellence across the broadest range of liberal arts and sciences disciplines.

Job Description

The FAS Office of Finance is a dynamic work environment that conducts strategic and financial analysis, as well as other projects, to inform resource allocation and decision making for Academic Leadership and other Senior Management. The Senior Business Systems and Data Analyst will develop financial tools and enhanced processes that guide the preparation of annual budgets, mid-year forecasts, multi-year financial plans, and quarterly management reporting of budget to actual financial information and personnel investments.

Job Summary

Research, design, document, implement, configure, and validate solutions to business needs. Solve highly complex technical problems. May manage multiple projects simultaneously.

Job-Specific Responsibilities

Analytical Design and Financial Modeling

• Design and build analytical tools that enhance multi-year financial planning, planning initiatives, annual budget and forecast, and budget-to-actual monitoring.
• Recommend, design, and create new models and methods that will improve data accuracy, provide consistent reporting and deliver information more efficiently.
• Evaluate tools to support or optimize business processes and determine solutions that can be scaled to the size of the Faculty of Arts and Sciences ($1.6B expense budget).
• Provide accurate and timely analytical support for budget and planning team.

Data Management and Report Development

• Develop and produce materials to facilitate forecast, budget, and multi-year financial planning for the Faculty of Arts and Science.
• Build new tools for financial monitoring of budget-to-actuals at the school and department/unit level.
• Gather business requirements for data and reporting needs. Translate business requirements into reports and analyses.
• Develop technical solutions for complex business processes and for information needs including writing ad hoc SQL queries and Oracle PL/SQL code and developing reports and dashboards in Oracle Analytics Server.
• Ensure data integrity and accuracy by reconciling data discrepancies between different data sources.