Hybrid Financial Systems Analyst - Data & Automation

Buchanan, Ingersoll & Rooney

Pittsburgh (Allegheny County)

Hybrid

USD 90,000 - 140,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 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.

Responsibilities

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

Skills

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

Education

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

Tools

Elite 3E
SQL Server
MDX / OLAP cubes
SSRS
BigHand

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Financial Systems & Analytics Analyst
Financial Systems & Analytics 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
Financial Systems Analyst
Financial Systems Analyst

Buchanan Ingersoll & Rooney Pc • Pittsburgh

On-site
USD 85,000 - 110,000
Hybrid Financial Reporting Analyst - Budget & Insights
Hybrid Financial Reporting Analyst - Budget & Insights

Aston Carter • United States

Hybrid
USD 39,000 - 45,000
Medical, dental & vision
401(k) Retirement Plan
Long-term disability
+1
Financial Analyst: Data-Driven Reporting & Insights (Hybrid)
Financial Analyst: Data-Driven Reporting & Insights (Hybrid)

Buckingham Search • Chicago (IL)

Hybrid
USD 60,000 - 80,000
Hybrid Financial Data & Automation Analyst
Hybrid Financial Data & Automation Analyst

Lenmar Consulting Inc • Baltimore (MD)

Hybrid
USD 70,000 - 90,000
Hybrid Financial Applications Analyst: Data, ERP & BI
Hybrid Financial Applications Analyst: Data, ERP & BI

CBTS • Columbus (OH)

Hybrid
USD 99,000 - 121,000
FP&A Manager - hybrid in Pittsburgh, PA
FP&A Manager - hybrid in Pittsburgh, PA

A.C. Coy • United States

Hybrid
USD 110,000 - 170,000
Hybrid Financial Aid Systems Analyst | Data & Reports
Hybrid Financial Aid Systems Analyst | Data & Reports

The University of Pittsburgh • Pittsburgh

Hybrid
USD 70,000 - 93,000
Director of Accounting & Financial Reporting (Hybrid)
Director of Accounting & Financial Reporting (Hybrid)

BNY • Pittsburgh

Hybrid
USD 150,000 - 210,000
401(k) plan
Medical insurance
Dental insurance
+3