What are the responsibilities and job description for the Financial Planning Analyst position at ConsultNet Technology Services and Solutions?
About the Role
This is a temporary contract engagement supporting a finance team's data transformation, forecasting, and budgeting initiatives. The specialist will work directly with the FP&A function to consolidate and restructure financial data from multiple source systems into clean, usable Excel-based models. Key deliverables include supporting the current-year forecast, building out the following year's budget, and contributing to a three-year midterm financial plan. This is a newly created position, meaning the successful candidate will have the opportunity to make a real impact from day one without stepping into an existing set of constraints. The role is expected to last approximately four months, with the possibility of extension depending on business needs.
Responsibilities
- Build and maintain advanced Excel models to support financial consolidation, forecasting, and budgeting processes
- Use Power Query to connect, clean, and transform data pulled from multiple source systems into flat files for analysis
- Support the FP&A team with current-year forecasting, next-year budget development, and a three-year midterm planning cycle
- Follow and expand upon existing Excel-based processes and templates already in use by the finance team
- Collaborate closely with the FP&A Director and finance lead to understand data requirements and deliver accurate, timely outputs
- Identify opportunities to improve data workflows and reporting efficiency within the existing Excel-based infrastructure
- Handle data sourced from a variety of systems and formats, extracting to flat files and restructuring as needed for downstream use
Required Skills
- Advanced proficiency in Microsoft Excel, including complex formulas, dynamic arrays, and structured data modeling
- Significant hands-on experience with Power Query for data extraction, transformation, and loading (ETL) workflows
- Solid background in Financial Planning and Analysis (FP&A), including familiarity with P&Ls, budgets, forecasts, and multi-year financial planning
- Ability to quickly understand and work within existing financial models and adapt them to evolving business needs
- Comfortable handling data from multiple, varied source systems without requiring deep technical knowledge of those systems
- Strong communication and collaboration skills with the ability to work closely alongside finance leadership
- Minimum 2-3 years of relevant experience in a finance or data-focused role, with demonstrated technical and business understanding