Associate FP&A Analyst 2

At PowerSchool, we are a dedicated team of innovators guided by our shared purpose of powering personalized education for students around the world. From the central office to the classroom to the home, PowerSchool supports the entire educational ecosystem as the global leader of cloud-based software for K-12 education. Our employees make it all possible, and a career with us means you’re joining a successful team committed to engaging, empowering, and improving the K-12 education experience everywhere.

Team Overview

Our Finance team is a passionate, high-performing group committed to supporting PowerSchool operations through accurate and timely financial transaction management. The team provides critical business guidance on a broad range of accounting, reporting, and analytical projects, ensuring the integrity of financial data.

Description

• The Financial Analyst will serve as a key member of the Financial Planning & Analysis (FP&A) team reporting directly to the Senior Manager, Finance and will be expected to leverage financial systems to streamline PowerSchool’s financial reporting and forecasting. By way of first-class management reporting, diligent analyses, and strategic modelling, the Finance team plays a key role in informing leadership of actual and projected performance in a fast-paced and highly collaborative environment. You will be empowered to expand PowerSchool’s use of financial planning software, visualization tools, and ETL tools/processes to automate our finance operations and extract valuable insights from PowerSchool’s various software tools.  We are seeking an experienced finance and systems professional, to move our team beyond Excel and maximize the value of our data and financial planning software.

  Responsibilities

  Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

  • Extract data and harness insights from/using CRM/ERP/BI/Financial Software tools
  • Function as Adaptive Insights Systems Admin and represent FP&A on technology discussions with Accounting, Data Governance, and other cross-functional operations
  • Translate Excel models to Adaptive
  • Build dashboards in DOMO or other visualization tools

  To be considered for and to perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required.

Minimum Qualifications

• Qualifications include:

  • 3+ years of experience in a finance or technology setting working with CRM/ERP/BI/Financial Software tools
  • Expert knowledge of Adaptive Insights or similar financial planning software (Vena, Anaplan) with the confidence to function as our Adaptive Systems Admin
  • Direct experience with Salesforce CRM, Netsuite ERP and visualization tools (Domo, PowerBi, Tableau)
  • Strong understanding of RDBMS and experience leveraging ETL and BI tools on large data sets/databases
  • Working knowledge of accounting and finance to draw upon while translating Excel models to Adaptive
  • Intermediate Excel skills, including pivot tables, vlookups, and sumifs - VBA, MDX or DAX knowledge a plus
  • Ability to manage multiple competing priorities
  • The ability to work cross-functionally to effect change in our systems and our data
  • The willingness to dive into the detail to resolve even the smallest of issues
  • Experience working in SaaS-based business and constructing SaaS-driven data analytics/KPIs as an asset

   

•  

Preferred Qualifications

• (These are NICE to haves. Add up to 5, keep them objective and qualifiable/quantifiable if possible)

EEO Commitment

PowerSchool celebrates a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce, we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process, please let us know by emailing accomodations@powerschool.com.