AMVETS Jobs

Job Category: Accounting Risquisition Number: JRBUS001106 Posted: September 16, 2024 Full-Time Pittsburgh, PA 15219, USA Job Details Description Junior Business Analyst

Buchanan Ingersoll & Rooney is a national law firm with a proven reputation for providing progressive, industry-leading legal, business, regulatory and government relations advice to our regional, national and international clients.

We are currently searching for a Junior Business Analyst for our Pittsburgh office. This position will sit on the Reporting team in our Accounting department.

Essential Duties and Responsibilities:

• Prepare and maintain various Excel spreadsheets related to cyclical reporting, including headcount, billable hours, and realization/effective rates.
• Gather, organize, and verify data via SSRS and Excel essential for cyclical reports, special projects, and business evaluations.
• 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 Financial Business Manager to create documentation and workflows for department data, with an eye toward 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 reflected correctly in our systems. Required Education/Experience:
• Bachelor's degree in Business Administration or Systems.
• Minimum 2 years' experience.
• Strong knowledge of MS Excel, including Pivot Tables.
• Working knowledge of relational databases, SQL, and/or MDX a plus.
• Analytical and problem-solving skills.
• Ability to perform at a high level of effectiveness, in a fast paced environment, managing multiple competing priorities simultaneously.
• Strong attention to detail.
• Team player with the ability to work overtime as required. Buchanan Ingersoll and Rooney PC offers outstanding benefits that include:
• Insurance -- Medical, Dental, Vision
• 401K program
• Retirement Savings Program
• Generous Paid Time Off
• Paid Holidays
• WorkWell wellness program
• Free use of building gym
• Caregiving assistance with Bright Horizons
• Firm-wide emergency assistance fund
• Available Hybrid schedule

We are an Equal Opportunity Employer.

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.35c

PI249830727