Senior FP&A Analyst (Project Management)

SoftWriters is on a Mission to Save Lives!  As a pioneer and market leader in long-term care pharmacy technology, we are proud to develop complex software and services that help pharmacies to deliver superior patient care to the most fragile population in the U.S.   We are passionate about building the best company, achieving the #1 Top Workplace designation in Pittsburgh.  We value quality, cultivating diverse teams, delivering successes and results, collaboration, innovation, thought leadership, integrity, teamwork, and growth. 

As we grow in size and complexity, we face some distinct challenges that require outstanding leaders and problem solvers.  Our culture and our people are our unique differentiator.  If you are seeking to join a growing team and making your mark on our noble mission, then you have come to the right place!

 

Overview:

 

FP&A Senior Analyst will ensure that SoftWriters makes sound financial decisions through quantitative analysis of accurate financial and operational data.  As a Senior Analyst, your work, whether it is financial modeling or tracking key performance indicators, will be used by senior leaders to make important strategic decisions.  You will support the financial and business planning activities and collaborate with cross-functional stakeholders to instill sound financial acumen and assess growth/efficiency initiatives.

 

We are looking for someone with analytical rigor and strategic thinking to continue to grow our FP&A function. This is an exciting role with exposure to all leaders and functions within the business.

 

To be successful in this role, you must approach problems with an analytical framework and the determination to solve problems.  You must be an effective communicator with the ability to distill complex findings into simple, concise recommendations.  You should also enjoy collaborating with colleagues on a wide-range of projects to ensure processes that influence data are continuously improving.

 

Responsibilities:

The essential functions include, but are not limited to, the following:

• Compare financial results with budgets, historical performance, and forecasts.  Prepare meaningful analytics to articulate financial drivers of revenue and expense line items.
• Build maintain stacked financial statement models (P&L, SCF, BS) to evaluate financial performance, strategic decisions, and investments.
• Build and maintain SaaS metric models including, but not limited to, CLTV, CAC, total ARR, new/expansion/churn ARR, cohort retention analysis, etc. by customer by product.
• Maintain and improve financial forecasts with new information as it is received and assist in communicating expectations of financial performance throughout financial periods.
• Identify, create, and maintain periodic reporting to disseminate financial and operational information to key decision makers.  Reporting includes, but is not limited to, executive scorecard reporting, commercial reporting, implementation / training reporting, departmental expense reporting, etc.
• Analyze financial results and write supporting commentary to present financial performance to multiple different financial & non-financial audiences including board of directors, executive leadership team, people managers, etc.
• Continuously improve new & existing analytical models through a “product” mindset to reduce manual inputs and leverage formulas / VBA / generative AI to ensure accurate, efficient, scalable, & flexible reporting.
• Partner with other functions in the organization to instill financial acumen into key decisions.
• Understand operational drivers in non-financial functions, including product, support, engineering, sales, implementation, to develop metrics and drive operational efficiency / optimal capital allocation.
• Identify process weaknesses that lead to inaccurate data, determine a solution, and lead others to buy-in and adopt recommendations. 
• Drive data integrity through well-defined processes and periodic auditing to ensure all financial and operating reporting is built on a foundation of accurate data.
• Use data to design key metrics, solve problems, and influence decision-making.
• Assist in continuous improvement in reporting processes and outputs, leveraging tech to create real-time access to analytics.
• Assist in preparation of data to support technology implementation efforts to improve operational processes and create real-time access to analytics.
• Other ad hoc financial and operational reporting.
• Other duties as assigned.

 

Minimum Qualifications:

• BA/BS degree in finance, accounting, or a related field required.
• 7-10 years of relevant experience, ideally in a publicly-held company.
• 3-5 years of relevant experience building stacked financial statement models (P&L, SCF, BS)
• 3-5 years of relevant experience reporting SaaS metrics (CLTV, CAC, ARR, etc.)

• Exceptionally strong proficiency in Microsoft Excel. Strong proficiency in PowerPoint. 

 

Preferred Qualifications:

 

• MBA or relevant Masters degree
• CPA or CFA
• Track record of successfully converting data into actionable insights.
• Ability to absorb the details without losing sight of the bigger picture.
• Strong process orientation and execution focus.
• Ability to manage multiple projects simultaneously.
• Uncompromising trust and integrity.
• Proficiency/comfort with financial solutions (ERP, G/L, Analytics Platforms) such as Sage300, Oracle FCC, and Adaptive Insights.
• Proficiency in writing VBA applications (primarily in Excel for automation of tasks).

 

Skills:

 

• Strong analytical capabilities and process-driven thinking
• Strong time and project management skills
• Strong written and verbal communication skills
• Ability to work in a team environment
• Ability to quickly learn new technology solutions, including HubSpot, Freshdesk
• Exceptionally strong proficiency in Microsoft Excel. Strong proficiency in Word, PowerPoint.  Previous experience with VBA in Excel a plus.

 

SoftWriters, Inc. is an equal opportunity employer. All qualified candidates receive consideration for employment without regard for race, color, religion, gender, sexual orientation, national origin or citizenship status, age, disability, genetic information or veteran status.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c) Finance/Accounting