at Northwestern University in Evanston, Illinois, United States
Job Description
Apply for Job
Job ID50543
LocationEvanston, Illinois
Add to Favorite Jobs
Email this Job
Department: Kellogg Financial Admin
Salary/Grade: EXS/6
Join our dynamic financial analysis team at the prestigious Kellogg School of Management as a Full-time Financial Analyst! This role is a hybrid role (60%remote/40% in office) and offers a unique opportunity to make a significant impact across the institution by maintaining and enhancing our data warehouse, which serves as the foundation for critical reporting and forecasting activities. With a diverse set of responsibilities, including data management, template creation, and PowerBI dashboard maintenance, you will play a crucial role in ensuring data accuracy and availability for faculty and unit area P&Ls. Your expertise will support the continuous improvement of our financial processes, directly influencing strategic decision-making. If you are a proactive problem solver with a passion for data analysis and financial modeling, we invite you to apply and help drive the financial success of Kellogg School of Management.
Required Skills/Experience:
Data Management: The successful candidate must be proficient in using MS Access Data tables and Microsoft Excel. Experience in maintaining data warehouses is crucial, including the ability to perform data table mapping reviews, data pulls and loads, data reconciliations, and forecast uploads.
Financial Analysis and Modeling: Candidates should have at least 2 years of experience in data analysis and/or financial modeling. A strong understanding of financial principles and practices is essential for this role.
Technical Proficiency: Advanced skills in Microsoft Excel are required, along with experience in using PowerBI for dashboard creation and maintenance.
Template Creation: The ability to develop monthly and quarterly forecast files, as well as yearly budget templates using MS Excel and/or PowerBI, is necessary for this position.
Attention to Detail: Strong organizational skills and a keen attention to detail are vital for maintaining data accuracy and consistency throughout the financial processes.
Communication Skills: Effective communication skills are important for collaborating with FP&A team members and other users, ensuring clear and accurate dissemination of financial information.
Support and Adaptability: The candidate must be capable of providing unit support for a budget under 350k. Flexibility to adapt to changing requirements and priorities is also essential.
Analytical Thinking: Strong analytical and problem-solving skills are required to interpret financial data and provide actionable insights that drive strategic decision-making.
Job Summary:
Supports a university accounting-related area or program. Manages financial operations &/or analysis in support of area/unit's mission & in coordination with central offices such as HR, Budget, Financial Aid, Facilities, Purchasing, IT, Provost, etc.Reviews a portfolio of multiple schools/depts' financial operations comprisedof work that involves some complex problems &/or decisions.
Specific Responsibilities:
Budget:
Participates in determination of budget including fiscal resource allocation of appropriated, discretionary, endowment &/or gift revenues.
Prepares analysis & reports.
Provides account research.
Assists with budget projects.
Updates budget estimates & provides commitment tracking support for all financial activity.
Ensures lead schedules are prepared.
Guides units of responsibility through university budgeting and forecasting processes, reviews budget and forecasting submissions.
Acts a Budget Office expert on units and functions within portfolio of responsibilities.
Coordinates &/or provides information for the annual salary review process.
Reviews & reconciles actual expenses to budget per NU Audit guidelines.
Approves funds reallocation within budget as necessary & appropriate.
Analysis, Statements & Reporting:
Creates daily, monthly, annual, &/or project end analysis & reports regarding area/unit, grants &/or awards, accounts, funds, payroll, expense &/or revenue allocation, customer service activity, etc.
Prepares financial analysis and lead schedules for supplies, equipment, &/or personnel decisions.
Records journal entries and creates reports.
Performs financial account reconciliations, statement analysis, and transaction research.
Provides support for annual audit workpapers and quarterly financial statement workpapers.
Maintains, and updates financial models and analysis.
Transactions:
Provides review and oversight of all types of financialtransactions some of... For full info follow application link.
Northwestern University is an Equal Opportunity, Affirmative Action Employer of all protected classes, including veterans and individuals with disabilities. Women, racial and ethnic minorities, individuals with disabilities, and veterans are encouraged to apply.
