Junior FP&A Analyst — Automation & Insights

Azend Pharma; SOUTH PLAINFIELD (NJ); On-site; USD 60,000 - 78,000; Full time

Benefits offered by this job

401(k)

401(k) matching

Dental insurance

Health insurance

Paid time off

Vision insurance

Job summary

Azend Pharma, a pharmacy consulting and healthcare advisory firm, is seeking an entry-level FP&A Analyst to support budgeting, forecasting, reporting, and performance analytics using Excel, Power Query, and Power Automate. The role collaborates with accounting during month-end close and helps scale a rapidly growing organization.

You will contribute to monthly/quarterly/yearly reporting, variance analysis, and KPI collection while building dashboards and financial models to drive insights and

Qualifications

• Bachelor’s degree in Finance, Accounting, Economics, or related field.
• 1–3 years of FP&A, financial analysis, accounting, or related roles.
• Strong understanding of financial statements, forecasting, and budgeting fundamentals.
• Advanced proficiency in Microsoft Excel (Power Query, PivotTables, formulas, modeling).
• Experience with Power Automate, SharePoint, or similar workflow tools preferred.
• Experience with ERP systems (NetSuite, or QuickBooks).
• Excellent analytical, communication, and organizational skills.

Responsibilities

• Support monthly, quarterly, and annual financial reporting cycles.
• Assist in preparing internal P&L, cash flow, and financial performance summaries.
• Maintain and update financial models for forecasting and planning.
• Perform budget vs. actual variance analysis and identify key performance drivers.
• Collaborate with accounting during month-end close to ensure accuracy of actuals and alignment with FP&A reporting.
• Prepare financial reports and schedules used in leadership reviews.
• Assist in developing and updating rolling forecasts for revenue, expenses, headcount, and cash flow.
• Monitor performance against budget and forecast, providing insights to improve financial accuracy.
• Work with business units to collect KPIs, operational data, and planning metrics.
• Develop and maintain advanced Excel models (Power Query, PivotTables, formulas) to streamline FP&A tasks.
• Support the creation and management of Power Automate workflows to automate recurring reporting and data tasks.
• Assist with SharePoint structure and document organization for finance-related materials.
• Identify and recommend process improvements that enhance speed, accuracy, and scalability within the FP&A function.
• Assist leadership and senior finance staff in evaluating new consulting projects or service lines.
• Support analyses related to pricing, project profitability, and cost structure optimization.
• Help prepare materials for strategic planning sessions, leadership meetings, and financial discussions.
• Maintain strong internal controls and ensure the integrity of financial data across systems.

Skills

Power BI

SQL

Consulting experience

Automation tools

Education

Bachelor’s degree in Finance/Accounting/Economics

Tools

Power Automate

SharePoint

NetSuite

QuickBooks

Job description

Azend Pharma, a pharmacy consulting and healthcare advisory firm, is seeking an entry-level FP&A Analyst to support budgeting, forecasting, reporting, and performance analytics using Excel, Power Query, and Power Automate. The role collaborates with accounting during month-end close and helps scale a rapidly growing organization.

You will contribute to monthly/quarterly/yearly reporting, variance analysis, and KPI collection while building dashboards and financial models to drive insights and