Finance Analyst – Excel Dashboards & Month‑End

Ascendo-Resources; Hagerstown (MD); On-site; USD 55,000 - 75,000; Full time

Job summary

Ascendo-Resources is seeking a detail-oriented Junior Financial Analyst to support the finance team of a growing manufacturing organization. The role focuses on Excel-based reporting, financial analysis, and month-end close activities.

The ideal candidate will have a background in accounting or finance, strong Excel skills, and experience working with financial data. This is a great opportunity to further develop financial analysis and reporting experience.

Qualifications

• Bachelor's degree in Finance, Accounting, Business, or a related field preferred.
• 1+ years of experience in finance, accounting, or financial analysis preferred.
• Advanced Microsoft Excel skills required, including VLOOKUP/XLOOKUP, Pivot Tables, formulas, and financial reporting.
• Experience creating Excel dashboards and financial models.

Responsibilities

• Assist with month-end close activities, including financial reporting, reconciliations, and variance analysis.
• Prepare and maintain financial reports, spreadsheets, and dashboards using advanced Excel functions.
• Analyze revenue, expenses, costs, and financial performance to identify trends and discrepancies.
• Support budgeting, forecasting, and financial planning activities.
• Create and update Excel-based financial models and reports.
• Gather, organize, and analyze financial data from various systems.
• Assist with ad hoc reporting and financial analysis requests.
• Collaborate with accounting and finance teams to ensure accuracy of financial information.
• Support process improvements related to reporting and data management.

Skills

Excel

Financial analysis

Pivot tables

VLOOKUP/XLOOKUP

Formulas

Dashboards

Month-end close

Financial reporting

Education

Bachelor's degree

Tools

ERP systems

Job description

Ascendo-Resources is seeking a detail-oriented Junior Financial Analyst to support the finance team of a growing manufacturing organization. The role focuses on Excel-based reporting, financial analysis, and month-end close activities.

The ideal candidate will have a background in accounting or finance, strong Excel skills, and experience working with financial data. This is a great opportunity to further develop financial analysis and reporting experience.