67981BRAuto req ID:67981BRJob Code:I0858P IT Business Analysis Prfss IV Department Office Location:USA - MA - Cambridge Business Title:Senior Business Systems and Data AnalystSub-Unit:Administration and Finance Salary Grade (https://hr.harvard.edu/salary-ranges#ranges) :058Time Status:Full-time Union:00 - Non Union, Exempt or Temporary Additional Qualifications and Skills:The following Additional Qualifications are strongly preferred. If you meet some, but not all, you are still encouraged to apply. + Bachelor's degree preferred. + MBA, Master’s in Information Systems, Master’s of Information Science, or other relevant professional/graduate degree desirable. + Preferred experience at a higher education institution or in a high-quality professional services environment + Experience with programming or scripting in a language such as Oracle PL/SQL. + Experience with business intelligence reporting software such as Oracle Analytics Server. + Advanced knowledge of budget management, financial analysis, and financial modeling; working knowledge of accounting principles + Ability to organize and summarize complex and large data sets to answer a business question and to translate business requirements into reports and analyses. + Attention to detail and demonstrated experience with quality assurance and data integrity are required. + Strong problem-solving, organizational, analytical, data analysis, and facilitation skills. + Proven ability to work in a complex environment and take an assignment from project design to final presentation with a minimum of supervision is necessary. + Demonstrated desktop application skills including Excel (including VBA/Macros), Word, MS Project, Access, PowerPoint, and Visio. Additional Information:We regret that we are unable to provide visa sponsorship for this position. All formal offers will be made by FAS Human Resources.Department:FAS Office of FinancePre-Employment Screening:Identity Schedule:M-F 9 to 5Job Function:Information Technology School/Unit:Faculty of Arts and Sciences EEO Statement:We 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.Basic Qualifications: + Minimum of five years’ post-secondary education or relevant work experience Working Conditions:Work is performed in an office setting.Position 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. Financial information produced by this position is used to facilitate strategic financial decision-making for departments, affiliated tubs, and senior management in FAS, including the FAS Dean and University partners. This position provides data that is essential for successful financial planning activities, in the form of multi-year planning, annual budgeting and forecasting, and year-end reporting. Reporting to the Associate Director for Budget and Planning Analysis in the FAS Office of Finance, the Senior Business Systems and Data Analyst will play a vital role in managing data and information systems for a high-volume, data-driven office. 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 the 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 various financial reporting packages that support senior leadership in decision-making. + Develop technical solutions for complex business processes and for information needs. Technical solutions may include (a) writing ad hoc SQL queries and Oracle PL/SQL code to produce complex reports in an Oracle database environment and (b) developing reports and dashboards in Oracle Analytics Server. + Ensure data integrity and accuracy by reconciling data discrepancies between different data sources. Commitment to Equity, Inclusion, and Belonging:Harvard University views equity, inclusion, and belonging as the pathway to achieving inclusive excellence and fostering a campus culture where everyone can thrive. We strive to create a community that draws upon the widest possible pool of talent to unify this excellence while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values.Benefits:We invite you to visit Harvard's Total Rewards website (https://hr.harvard.edu/totalrewards) to learn more about our outstanding benefits package, which may include: + Paid Time Off: 3-4 weeks of accrued vacation time per year (3 weeks for support staff and 4 weeks for administrative/professional staff), 12 accrued sick days per year, 12.5 holidays plus a Winter Recess in December/January, 3 personal days per year (prorated based on date of hire), and up to 12 weeks of paid leave for new parents who are primary care givers. + Health and Welfare: Comprehensive medical, dental, and vision benefits, disability and life insurance programs, along with voluntary benefits. Most coverage begins as of your start date. + Work/Life and Wellness: Child and elder/adult care resources including on campus childcare centers, Employee Assistance Program, and wellness programs related to stress management, nutrition, meditation, and more. + Retirement: University-funded retirement plan with contributions from 5% to 15% of eligible compensation, based on age and earnings with full vesting after 3 years of service. + Tuition Assistance Program: Competitive program including $40 per class at the Harvard Extension School and reduced tuition through other participating Harvard graduate schools. + Tuition Reimbursement: Program that provides 75% to 90% reimbursement up to $5,250 per calendar year for eligible courses taken at other accredited institutions. + Professional Development: Programs and classes at little or no cost, including through the Harvard Center for Workplace Development and LinkedIn Learning. + Commuting and Transportation: Various commuter options handled through the Parking Office, including discounted parking, half-priced public transportation passes and pre-tax transit passes, biking benefits, and more. + Harvard Facilities Access, Discounts and Perks: Access to Harvard athletic and fitness facilities, libraries, campus events, credit union, and more, as well as discounts to various types of services (legal, financial, etc.) and cultural and leisure activities throughout metro-Boston. Work Format:Hybrid (partially on-site, partially remote) LinkedIn Recruiter Tag (for internal use only):#LI-CK1Work Format Details:Hybrid office environment; this position will be based in Cambridge, MA and there is an expectation of one workday per week (Monday) on campus. Additional details will be discussed during the interview process. All remote work must be performed within one of the Harvard Registered Payroll States. Certain visa types and funding sources may limit work location. Individuals must meet work location sponsorship requirements prior to employment.About Us:The FAS Office of Finance, in partnership with the University, supports the mission and strategic objectives of the Faculty of Arts & Sciences. We promote an environment of financial integrity to safeguard assets, enable optimal use of resources, and facilitate informed decision-making. In collaboration with FAS and University communities, we act as financial stewards to provide high-quality, timely, and accurate services to FAS leadership, faculty, staff, and students.