Financial Systems Analyst

Buchanan Ingersoll & Rooney Pc

Pittsburgh (Allegheny County)

On-site

USD 85,000 - 110,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Buchanan Ingersoll & Rooney Pc in Pittsburgh, PA is seeking a Financial Systems Analyst to join the Financial Analytics & Reporting team. The role focuses on managing core financial data pipelines, delivering routine reporting, and automating processes with SQL and BI tooling.

The ideal candidate will have 3–5 years in finance, strong SQL and Excel skills, and the ability to analyze data to drive performance insights while collaborating with cross-functional teams and external vendors.

Qualifications

  • 3–5 years of progressive experience in corporate finance, financial systems, business intelligence, or data analytics.
  • Strong SQL capabilities: writing and modifying SQL queries, stored procedures, and working with relational databases.
  • Advanced MS Excel: multi-tab workbooks with nested logic, lookups, and data validation.
  • Analytical curiosity: ability to perform root-cause analysis and investigate data anomalies.
  • High learning agility: quickly learn complex, enterprise systems (Elite 3E, OLAP cubes, MDX).
  • Excellent communication skills with the maturity to handle sensitive firm data and collaborate with stakeholders.
  • Baseline knowledge of financial concepts including balance sheets and income statements.

Responsibilities

  • Master Headcount Data Governance: ensure data accuracy for headcount variables used in performance metrics.
  • Timekeeper & Target Management: track prorated target hours for timekeepers across schedules and leaves.
  • Dashboard Maintenance and Development: create and maintain front-end visualizations for attorney-facing financial dashboards.
  • SQL & Automation Engineering: develop automated reporting notifications and maintain SQL stored procedures.
  • Ad-Hoc Cube & SSRS Analytics: investigate data discrepancies using multidimensional cubes and SQL Server.
  • System Maintenance & Vendor Support: collaborate with IT and vendors to troubleshoot, upgrade, and test environments.

Skills

SQL
Advanced Excel
Analytical thinking
Learning agility
Communication skills
Financial concepts
Problem solving

Tools

Elite 3E
MDX
OLAP cubes

Job description

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, PAoffice. 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.

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:
  • 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Financial Systems Analyst
Financial Systems Analyst

Buchanan, Ingersoll & Rooney • Pittsburgh

Hybrid
USD 90,000 - 140,000
Financial Systems & Analytics Analyst
Financial Systems & Analytics Analyst

Buchanan Ingersoll & Rooney Pc • Pittsburgh

On-site
USD 85,000 - 110,000
Accounting Analyst
Accounting Analyst

Rust Belt Resources, LLC. • Pittsburgh

On-site
USD 54,000 - 66,000
Health insurance
Vision insurance
Dental insurance
+3
Legal Practice Assistant
Legal Practice Assistant

Buchanan Ingersoll & Rooney Pc • Pittsburgh

On-site
USD 38,000 - 54,000
Paid Time Off
Paid Holidays (floating)
Caregiving assistance (Bright Horizons
+2
Strategic Analyst
Strategic Analyst

Digitailor • Louisville (KY), Indianapolis (IN), Cincinnati (OH), Lexington (VA)

On-site
USD 90,000 - 120,000
Financial Reporting Analyst
Financial Reporting Analyst

ADP, Inc. • New York (NY)

On-site
USD 120,000 - 145,000
Senior Financial Reporting Analyst
Senior Financial Reporting Analyst

Friedman Williams • New York (NY)

Hybrid
USD 120,000 - 180,000
Sr Financial Data Analyst
Sr Financial Data Analyst

DLA Piper LLP • Short Hills (NJ)

Hybrid
USD 99,000 - 137,000
Medical/Dental/Vision Insurance
401(k)
Financial Analyst, Legal Services
Financial Analyst, Legal Services

Addition Management • New York (NY)

On-site
USD 100,000 - 110,000
Director of Financial Planning, Analysis and Data Analytics
Director of Financial Planning, Analysis and Data Analytics

Liberty Personnel Services, Inc. • Washington

Hybrid
USD 170,000 - 215,000