Financial Analysis Manager - Pittsburgh, PA

VetJobs and Military Spouse Jobs; Pittsburgh (Allegheny County); Hybrid; USD 78,000 - 111,000; Full time

Job summary

The University of Pittsburgh seeks a Financial Reporting & Analytics leader to modernize and automate financial reporting. You will develop dashboards and self-service capabilities using Power BI, Excel, and SQL, and transform manual processes into scalable solutions. Collaborate with finance leadership to drive data-driven decisions.

You will guide analysts, establish standards, and ensure data quality across the finance function, in a hybrid on-campus/remote work arrangement.

Qualifications

• Bachelor's degree in Finance, Accounting, or related field.
• Minimum 5 years of experience in financial planning & analysis or FP&A.
• Strong knowledge of Power BI, Excel, SQL and other BI platforms.
• Experience identifying automation opportunities in financial reporting.

Responsibilities

• Lead the modernization of financial reporting with automated dashboards and self-service analytics.
• Design and maintain reporting solutions using Power BI, Excel, and SQL.
• Transform manual reporting into scalable automated processes.
• Develop standardized reporting packages, KPIs, and dashboards for decisions.
• Mentor analysts on best practices and data analysis methodologies.

Job description

Key Responsibilities

• Reporting Transformation & Business Intelligence
  • Lead the modernization of financial reporting through the development of automated dashboards, self-service reporting, and executive-level analytics.
  • Design, develop, and maintain reporting solutions using tools such as Power BI, Excel, SQL, and other business intelligence platforms.
  • Transform manual reporting processes into scalable, automated solutions that improve efficiency, accuracy, and accessibility.
  • Develop standardized reporting packages, KPIs, and dashboards to support strategic and operational decision-making.
• Process Automation & Operational Excellence
  • Identify opportunities to streamline financial processes through automation, workflow improvements, and technology solutions.
  • Design and implement automated processes utilizing VBA, Power Query, SQL, Power Automate, and other automation tools.
  • Reduce manual effort by eliminating repetitive tasks and improving process consistency across the finance organization.
  • Lead continuous improvement initiatives focused on increasing efficiency, strengthening internal controls, and enhancing data quality.
• Data Management & Analytics
  • Develop, maintain, and optimize financial data models to support budgeting, forecasting, and reporting activities.
  • Write and optimize SQL queries, data transformations, and data validation processes to ensure accurate and reliable financial information.
  • Collaborate with IT and data management teams to improve data governance, integration, and accessibility.
  • Perform complex financial and operational analyses to identify trends, risks, and opportunities.
• Technical Leadership & Collaboration
  • Serve as the team's subject matter expert for reporting technologies, automation tools, and financial data architecture.
  • Partner with finance leadership and business stakeholders to understand reporting needs and develop innovative analytical solutions.
  • Mentor financial analysts on reporting best practices, automation techniques, and data analysis methodologies.
  • Promote the adoption of standardized reporting tools, templates, and documentation across the finance organization.
• Governance & Documentation
  • Develop and maintain documentation for reporting solutions, automated processes, and data models.
  • Establish reporting standards and best practices to ensure consistency, accuracy, and sustainability.
  • Ensure compliance with organizational policies related to financial reporting, data governance, and internal controls.
• Innovation & Continuous Improvement
  • Evaluate emerging technologies and analytical tools that can enhance the finance function.
  • Lead initiatives to modernize financial systems, reporting capabilities, and business processes.
  • Recommend and implement innovative solutions that improve financial planning, forecasting, reporting, and decision support.
  • Foster a culture of continuous improvement by identifying opportunities to leverage technology and analytics to drive organizational performance.

Job Summary

Lead efforts to create multi-year plans and utilize university planning and modeling tools to support sound financial decision-making at the University.

Essential Functions

• Reporting Transformation & Business Intelligence.
• Process Automation & Operational Excellence.
• Technical Leadership & Collaboration.
• Governance & Documentation.
• Innovation & Continuous Improvement.

Physical Effort

Little physical effort required. Duties are primarily sedentary. May be required to move objects up to 25 pounds occasionally.

The University of Pittsburgh is an equal opportunity employer / disability / veteran.

• Assignment Category Full-time regular
• Job Classification Staff.Financial Analysis Manager
• Job Family Finance & Procurement
• Job Sub-Family Financial Planning & Analysis
• Campus Pittsburgh
• Minimum Education Level Required Bachelor's Degree
• Minimum Years of Experience Required 5
• Will this position accept substitution in lieu of education or experience? Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.
• Work Schedule Monday - Friday, 8:30 a.m. - 5:00 p.m.
• Work Arrangement Hybrid: Combination of On-Campus and Remote work as determined by the department.
• Hiring Range $78,501 to $111,209 annual
• Relocation Offered No
• Visa Sponsorship Provided No
• Background Check For position finalists, employment with the University will require successful completion of a background check
• Child Protection Clearances Not Applicable
• Required Documents Resume
• Optional Documents Cover Letter