Financial Systems Analyst

Buchanan, Ingersoll & Rooney

Pittsburgh (Allegheny County)

Hybride

USD 90 000 - 140 000

Plein temps

Il y a 6 jours
Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

Buchanan, Ingersoll & Rooney is seeking a Financial Systems Analyst in Pittsburgh, PA. You will join the Financial Analytics & Reporting team to manage core financial data pipelines, deliver routine reporting, and automate processes while growing into a subject matter expert.

The role emphasizes data governance, complex SQL, and dashboard development within a hybrid work schedule. Strong analytical skills and MS Excel mastery are essential.

Qualifications

  • Bachelor's degree in a quantitative discipline (Finance, MIS, Business Analytics, CS, or equivalent).
  • 35 years of progressive experience in corporate finance, financial systems, BI, or data analytics.
  • Strong SQL capabilities: writing and modifying SQL queries, stored procedures, relational databases.
  • Advanced MS Excel: complex multi-tab workbooks, nested logic, data validation for integrity.
  • Excellent communication and learning agility to master enterprise systems like Elite 3E.

Responsabilités

  • Master Headcount Data Governance: ensure absolute data accuracy for headcount metrics.
  • Timekeeper & Target Management: track prorated target hours across schedules and leaves.
  • Dashboard Maintenance and Development: create front-end dashboards and back-end updates.
  • SQL & Automation Engineering: develop automated reporting and write SQL procedures.
  • Ad-Hoc Cube & SSRS Analytics: investigate data discrepancies using cubes and SSRS.

Connaissances

SQL queries
Advanced Excel
Analytical thinking
Data governance
Communication skills
Learning agility

Formation

Bachelor's degree in Finance/MIS/CS
Bachelor's degree in a quantitative discipline

Outils

Elite 3E
SQL Server
MDX / OLAP cubes
SSRS
BigHand

Description du poste

Job Category: Accounting

Risquisition Number: FINAN001250

Posted: November 13, 2026

Full-Time

Pittsburgh, PA 15219, USA

Job Details
Description

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).
  • 35 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.

PI288413857

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Financial Systems Analyst
Financial Systems Analyst

Buchanan Ingersoll & Rooney Pc • Pittsburgh

Sur place
USD 85 000 - 110 000
Accounting Analyst
Accounting Analyst

Rust Belt Resources, LLC. • Pittsburgh

Sur place
USD 54 000 - 66 000
Health insurance
Vision insurance
Dental insurance
+3
Financial Reporting Analyst
Financial Reporting Analyst

ADP, Inc. • New York (NY)

Sur place
USD 120 000 - 145 000
Legal Financial Systems Analyst
Legal Financial Systems Analyst

Ledgent Technology • Denver (CO)

Hybride
USD 85 000 - 105 000
Medical
Dental
Vision
+7
Hybrid Financial Systems Analyst - Data & Automation
Hybrid Financial Systems Analyst - Data & Automation

Buchanan, Ingersoll & Rooney • Pittsburgh

Hybride
USD 90 000 - 140 000
Financial Reporting Analyst
Financial Reporting Analyst

Pryor Cashman • New York (NY)

Sur place
USD 120 000 - 145 000
Financial Analyst, Legal Services
Financial Analyst, Legal Services

Addition Management • New York (NY)

Sur place
USD 100 000 - 110 000
Sr Financial Data Analyst
Sr Financial Data Analyst

DLA Piper LLP • Short Hills (NJ)

Hybride
USD 99 000 - 137 000
Medical/Dental/Vision Insurance
401(k)
Financial Systems Analyst
Financial Systems Analyst

Ledgent Technology • Denver (CO)

Hybride
USD 95 000 - 105 000
Comprehensive medical, dental, and vision coverage
401(k) with company match
Generous PTO and holidays
+2
Strategic Analyst
Strategic Analyst

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

Sur place
USD 90 000 - 120 000