Lead Financial Analyst - 26004927

Lead Financial Analyst Office of Administration-Health Sciences - Pennsylvania-Pittsburgh - (26004927) Position Summary: The Lead Financial Analyst 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 View the full job description on the employer's website. Equal employment opportunity, including veterans and individuals with disabilities. PI286350262 / 13-2041.00 Credit Analysts