finance/credit/treasury/accounts Analyst

$70,000 - $70,000/Yr

Ahu Technologies - East Pittsburgh, PA

Full-time - Entry Level

East Pittsburgh, PA

Professional, Scientific, and Technical Services

About the position

The Junior Business Analyst position is a full-time role within the Reporting team of the Accounting department in Pittsburgh. The primary focus of this role is to prepare and maintain various reports and spreadsheets, ensuring accurate data collection and analysis to support business evaluations and special projects.

Responsibilities

• Prepare and maintain various Excel spreadsheets related to cyclical reporting, including headcount, billable hours, and realization/effective rates.
• Gather, organize, and verify data essential for cyclical reports, special projects, and business evaluations using SSRS and Excel.
• Create ad hoc reports using a multidimensional cube as requested by various attorneys, departments, and senior management.
• Develop summaries and reports of findings from data collected for special projects and business evaluations.
• Work with the Financial Business Manager to create documentation and workflows for department data, focusing on automation.
• Support system upgrades and conversions by coordinating testing of changes, preparing user manuals, and responding to attorney questions.
• Work closely with the Human Resource and Billing departments to ensure timekeeper data is accurately reflected in systems.

Requirements

• Bachelor's degree in Business Administration or Systems.
• Minimum 2 years' experience in a related field.
• Strong knowledge of MS Excel, including Pivot Tables.
• Working knowledge of relational databases, SQL, and/or MDX is a plus.
• Analytical and problem-solving skills.
• Ability to perform effectively in a fast-paced environment, managing multiple competing priorities simultaneously.
• Strong attention to detail.
• Team player with the ability to work overtime as required.