Financial Systems Analyst

Buchanan Ingersoll & Rooney PC • Pittsburgh, PA

1d • Hybrid

About The Position

Buchanan Ingersoll & Rooney is seeking a Financial Systems Analyst for its Pittsburgh, Pennsylvania office. The role sits within the Financial Analytics & Reporting team and supports the firm’s business intelligence ecosystem. Working directly with the Financial Business Manager, the analyst will manage core financial data pipelines, contribute to routine financial reporting, automate reporting where possible, and develop subject-matter expertise. The position follows a hybrid work schedule.

Requirements

• Bachelor’s degree in a quantitative discipline such as Finance, Management Information Systems, Business Analytics, or Computer Science, or equivalent.
• 3–5 years of progressive experience in corporate finance, financial systems, business intelligence, or data analytics.
• Proven ability to write and modify SQL queries and stored procedures and work confidently with relational databases.
• Advanced Microsoft Excel skills, including managing complex multi-tab workbooks with nested logic, lookup functions, and data validation rules.
• Ability to investigate data anomalies and independently perform root-cause analysis.
• Capacity to learn complex enterprise systems, including Elite 3E, OLAP cubes, and MDX.
• Excellent communication skills and professional maturity when handling sensitive firm data and collaborating with cross-functional stakeholders.
• Baseline knowledge of financial concepts, including how to read balance sheets and income statements.

Nice To Haves

• Experience in professional services or a legal environment.
• Knowledge of law firm economics.

Responsibilities

• Manage the firm’s master legal and non-legal headcount tracking models and maintain data accuracy for firm-wide performance metrics, including Revenue per Lawyer and annualized hours calculations.
• Track and calculate prorated target hours for timekeepers who change work schedules, take statutory leaves of absence, or transition between firm tiers.
• Maintain and develop attorney-facing financial dashboards, including front-end visualizations and back-end updates.
• Develop and optimize automated firm reporting notifications, and write and maintain SQL stored procedures that feed business triggers to firm leadership.
• Use multidimensional cubes and the SQL Server environment to investigate data discrepancies, answer operational questions, and fulfill data requests from firm administrative leaders.
• Work with internal IT teams and software vendors, including Elite 3E and BigHand, to troubleshoot application bugs, coordinate system upgrades, and test environment conversions.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level