Financial Systems Analyst

Financial Systems 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 Financial Systems Analyst for our Pittsburgh, PA office. This role is designed for a highly analytical, technically skilled problem-solver who will participate within the firm’s business intelligence ecosystem. Sitting within the Financial Analytics & Reporting team, the ideal candidate will partner directly with the Financial Business Manager to manage our core financial data pipelines, participate in the delivery of routine financial reporting, drive automation of reporting when possible, and grow into a subject matter expert.

Hybrid work schedule.

Essential Duties and Responsibilities:

• Master Headcount Data Governance: Manage the firm’s master legal and non-legal headcount tracking models. Ensure absolute data accuracy for variables that serve as the critical denominator for all firm-wide performance metrics, including Revenue per Lawyer (RPL) and annualized hours calculations.
• Timekeeper & Target Management: Systematically track and calculate complex, prorated target hours for timekeepers moving to and from alternate work schedules, taking statutory leaves of absence, or transitioning between firm tiers (e.g., Shareholder to Of Counsel).
• Dashboard Maintenance and Development: Serve as a resource for the firm’s attorney-facing financial dashboards, developing front-end visualizations and maintaining back-end updates to optimize shareholder visibility into key metrics.
• SQL & Automation Engineering: Own the continued development and optimization of automated firm reporting notification; write and maintain the SQL stored procedures required to feed complex business triggers to firm leadership.
• Ad-Hoc Cube & SSRS Analytics: Utilize the firm’s multidimensional cubes and SQL Server environment to independently investigate data discrepancies, answer complex operational questions, and fulfill high-priority data requests from firm administrative leaders.
• System Maintenance & Vendor Support: Collaborate closely with internal IT teams and software vendors (Elite 3E, BigHand) to troubleshoot application bugs, coordinate system upgrades, and test environment conversions.

Required Qualifications & Hard Skills:

• Bachelor’s degree in a quantitative discipline (Finance, Management Information Systems (MIS), Business Analytics, Computer Science, or equivalent).
• 3–5 years of progressive experience in corporate finance, financial systems, business intelligence, or data analytics. Experience in professional services or a legal environment is highly valued, but raw technical capability and problem-solving drive are prioritized
• Strong SQL Capabilities: Proven experience writing and modifying SQL queries, stored procedures, and working confidently with relational databases.
• Advanced MS Excel: Absolute comfort managing complex, multi-tab workbooks utilizing nested logic, lookup functions, and data validation rules where data integrity is paramount.
• Analytical Curiosity: A demonstrated ability to move beyond passive data entry into active root-cause analysis—someone capable of investigating data anomalies and piecing together discrepancies independently.
• High Learning Agility: The capacity to quickly learn complex, industry-specific enterprise systems (Elite 3E, OLAP cubes, MDX) under direct mentorship.
• Excellent communication skills with the professional maturity to handle sensitive firm data and collaborate with cross-functional stakeholders.
• Baseline knowledge of financial concepts including how to read a balance sheet and income statements. Knowledge of law firm economics a plus.