Financial Systems & Analytics Analyst

Buchanan Ingersoll & Rooney Pc

Pittsburgh (Allegheny County)

On-site

USD 85,000 - 110,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Hybrid Financial Systems Analyst - Data & Automation
Hybrid Financial Systems Analyst - Data & Automation

Buchanan, Ingersoll & Rooney • Pittsburgh

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

Buchanan Ingersoll & Rooney Pc • Pittsburgh

On-site
USD 85,000 - 110,000
Financial Systems Analyst
Financial Systems Analyst

Buchanan, Ingersoll & Rooney • Pittsburgh

Hybrid
USD 90,000 - 140,000
Senior Financial Analyst - FP&A
Senior Financial Analyst - FP&A

| GrayMatter | • Pittsburgh

Hybrid
USD 110,000 - 150,000
Medical insurance
Short-term disability
Life insurance
+1
Financial Data Analyst: Investment Insights & Reporting
Financial Data Analyst: Investment Insights & Reporting

Vantage Atlantic • Pittsburgh

On-site
USD 38,000 - 50,000
Health insurance
Dental insurance
Vision insurance
+6
Financial Analyst: Data-Driven Forecasts & Reports
Financial Analyst: Data-Driven Forecasts & Reports

Maple Quartz Group • Pittsburgh

On-site
USD 83,000 - 95,000
Senior Associate, Investment Accounting & Reporting
Senior Associate, Investment Accounting & Reporting

BNY • Pittsburgh

On-site
USD 65,000 - 90,000
Finance Systems Analyst: BI & Sales Analytics
Finance Systems Analyst: BI & Sales Analytics

Codex • United States

On-site
USD 70,000 - 90,000
Financial Analyst
Financial Analyst

Maple Quartz Group • Pittsburgh

On-site
USD 83,000 - 95,000
Business Systems Analyst Consultant
Business Systems Analyst Consultant

Jobs via Dice • Pittsburgh

On-site
USD 77,000 - 105,000
Medical/prescription drug coverage
Dental and vision options
401(k) with match
+2