The Financial Analyst plays a key role on the College Track Finance team and will be responsible for analyzing financial data across the organization to support in budgeting, forecasting, reporting and ad-hoc analyses. The successful candidate will possess advance skill in Adaptive Planning and excel and be comfortable working with complex financial data, have an understanding of general accounting principles, experience using financial systems, and ability to form collaborative working relationships. The position reports to the Financial Planning & Analysis Manager.
Primary Responsibilities Include:
- Build and Maintain Dashboards/Reporting (45%)
- Build reports and dashboards online (Adaptive) or offline as needed.
- Maintain/update reports menu and listings with consistent naming convention and layout to facilitate navigating by all users.
- Support the preparation of financial reports for internal and external audiences (i.e. budget owners, donors, etc.)
- Partner with budget owners to establish budgets and build forecasts (20%)
- Own the relationship as business partner with 4-6 budget owners, leading quarterly and periodic budget meetings. Analyze monthly budget-actual results and forecasts across organization and provide summarized reports to budget owners.
- Support and lead aspects of the annual budgeting process including but not limited to calendaring and providing training (both technical and conceptual), documenting rationale and changes, providing analytics/metrics to facilitate target-setting and related decision-making, owning the consolidation and version control processes, producing online and offline reports for budget owners and producing final board presentation deck.
- Work cross-functionally with budget owners either as a team or one-on-one to provide general guidance and transactional information where needed to update ongoing forecasts. Includes areas of head-count/payroll and non-payroll variable expenses plus reasonableness checks on fixed expenses.
- Optimize FP&A Process and Reporting Functionality (15%)
- Own the technical and maintenance responsibilities for budgeting software including formula adjustments, updating account mapping, updating personnel and fixed assets sheets for proper projection of payroll and depreciation.
- Address administrative issues such as user set-up and access. Maintain/build online reports as needed.
- Identify and lead process improvement efforts on team.
- Support Monthly Close (10%)
- Complete monthly variation analyses between actuals and projections, and work with Accounting to reconcile discrepancies in data.
- Work closely with Accounting to take part in the close process including loading actuals into forecasts (Adaptive Insights).
- Ad-hoc Analyses and Projects (10%)
- Perform financial analysis and develop fact-based recommendations to help make informed business decisions.
- Identify and call out issues affecting the organization's operations, cash position and capital expenditures.
Skills & Experience Required
First and foremost, the Finance Analyst must embrace the College Track vision of transforming low-income communities into places where college readiness and college graduation are the norms. Additionally, candidates must possess the following qualifications:
- Bachelor degree in Finance, Accounting, Mathematics or related field required.
- Minimum 4-5 years of relevant experience (e.g. finance, financial analysis, economic analysis, etc.).
- Advanced knowledge of MS Excel (required) Adaptive Planning (preferred), and database skills (required). Familiarity with Intacct a plus.
- High degree of competency in math and critical thinking with exceptional organizational skills.
- Operates with a high sense of urgency and responsiveness balanced by a need for providing accurate information based on strategic priorities.
- Extremely detail-oriented, well-organized, and structured in the creation and presentation of information.
- Ability to problem solve and focus on details without losing sight of the broader task.
- Ability to manage multiple time-sensitive projects simultaneously; Uses sound judgment to prioritize and meet deadlines, copes well with change, and maintains composure under pressure.
- Exceptional communication skills with demonstrable ability to write effectively, speak persuasively, and listen attentively.
- High degree of flexibility and adaptability; can work within an ambitious, fast-moving environment, while also driving toward clarity and solution.
Position reports to Financial Planning & Analysis Manager.
College Track requires that the holder of this position be fully vaccinated, and boosted (if eligible), against COVID-19, as defined by the CDC. College Track will require proof of vaccination and a booster shot from all future employees. New hires who are booster eligible but have not yet received the booster shot will have 60 days from their date of hire to do so.
Compensation & Benefits
Full Colorado Salary Range: $64,700-$87,500
College Track offers a competitive, region-specific, salary based on the organization's compensation philosophy, grounded in market data. We also offer comprehensive health & welfare benefits and top-of-the-market paid time off. A complete look at the benefits College Track offers full time benefits eligible employees can be viewed here.
Please upload a PDF resume and thoughtful cover letter with your application. We will only contact candidates chosen for further consideration. No phone inquiries please.
College Track works to remove barriers for first generation college students on their journey to college completion. Our commitment to removing barriers for first generation college students doesn't stop when college ends. While we hire great people from a wide variety of backgrounds, we especially encourage applicants who identify as first-generation college graduates to apply for open opportunities on staff.
College Track is an equal opportunity employer fully committed to achieving a diverse workforce. College Track does not discriminate on the basis of race, age, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, or gender identity or expression.