Manager - Analytics

Life in Pittsburgh; Pittsburgh (Allegheny County); On-site; USD 79,000 - 111,000; Full time

Job summary

The University of Pittsburgh seeks a Financial Analysis Manager to lead the FP&A team in transforming reporting, analytics, and processes across the organization. You will design automated dashboards, build data models, and partner with IT and operations to drive scalable, accurate financial insights.

You will mentor analysts, promote standardized reporting, and ensure data governance and internal controls while pursuing continuous improvement and innovative analytics solutions.

Qualifications

• Bachelor's degree required; 3+ years in analytics/finance.
• Experience with data modeling and financial reporting.
• Strong proficiency with Power BI, Excel, and SQL preferred.

Responsibilities

• Lead automated dashboards and executive analytics to transform financial reporting.
• Develop and maintain BI reports using Power BI, Excel, and SQL.
• Automate financial processes to improve efficiency and accuracy.
• Build and optimize financial data models for budgeting and forecasting.
• Mentor analysts and promote standardized reporting practices.
• Document processes and enforce data governance and controls.
• Identify opportunities to modernize systems and analytics.

Skills

Financial analysis

Data analytics

Team leadership

Power BI

Education

Bachelor's Degree

Tools

Power BI

Excel

SQL

Power Query

VBA

Power Automate

Job description

Position Summary:

The Financial Analysis Manager serves as a key technical leader within the Financial Planning & Analysis team, driving the transformation of financial reporting, data analytics, and business processes across the organization. This role is responsible for developing automated reporting solutions, improving data integrity, optimizing financial processes, and leveraging modern reporting tools to enhance decision-making. The position partners closely with finance leadership, IT, and operational stakeholders to create scalable solutions that reduce manual effort, improve reporting accuracy, and establish best practices for financial analytics.

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.

Manages team and oversees the entire analytics lifecycle, including data collection, preparation, advanced analysis, and modeling. Leads the design, deployment, and maintenance of data models, dashboards, and visualizations. Identifies analytical strategies, cost reduction opportunities, and performance enhancements. Serves as a point of contact for customers and staff. Assists in establishing best practice standards, monitors data quality, and prepares complex reports for senior leadership.

Reporting Transformation & Business Intelligence.

Process Automation & Operational Excellence.

Technical Leadership & Collaboration.

Governance & Documentation.

Innovation & Continuous Improvement.

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.

Job Details

• Assignment Category: Full-time regular
• Job Classification: Staff.Manager - Analytics
• Job Family: Information Technology
• Job Sub-Family: Analytics
• Campus: Pittsburgh
• Minimum Education Level Required: Bachelor's Degree
• Minimum Years of Experience Required: 3
• 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: On-Campus: Teams that work on campus, in an office, or in a lab.
• 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