Financial Systems Analyst

Pittsburgh • Pittsburgh, PA

7h • Hybrid

About The Position

Buchanan Ingersoll & Rooney is seeking a Financial Systems Analyst for its Pittsburgh, Pennsylvania office. The role is part of the Financial Analytics & Reporting team and supports the firm’s business intelligence ecosystem. Working 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.

The analyst is responsible for firmwide headcount data governance and timekeeper target calculations, maintaining and developing attorney-facing financial dashboards, and engineering automated reporting and SQL-based business triggers. The role also uses multidimensional cubes and SQL Server to investigate discrepancies and respond to operational data requests. The analyst collaborates with internal IT teams and software vendors to troubleshoot applications, coordinate upgrades, and test environment conversions.

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.
• Experience writing and modifying SQL queries and stored procedures and working 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, perform root-cause analysis, and resolve discrepancies independently.
• Ability to quickly learn complex enterprise systems, including Elite 3E, OLAP cubes, and MDX, under direct mentorship.
• Excellent communication skills and professional maturity when handling sensitive firm data and collaborating with cross-functional stakeholders.
• Baseline knowledge of financial concepts, including reading balance sheets and income statements.

Nice To Haves

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

Responsibilities

• Manage master legal and non-legal headcount tracking models and ensure the accuracy of data used in firmwide performance metrics, including Revenue per Lawyer and annualized hours.
• Track and calculate prorated target hours for timekeepers changing work schedules, taking statutory leaves of absence, or transitioning between firm tiers.
• Support attorney-facing financial dashboards by developing front-end visualizations and maintaining back-end updates.
• Develop and optimize automated firm reporting notifications.
• 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 high-priority 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