Operational Analytics Analyst 2 at First National Bank Of Pennsylvania — Pittsburgh, PA

## Primary Office Location:

100 Federal Street. Pittsburgh, Pennsylvania. 15212.

Position Title: Operational Analytics Analyst 2

Business Unit: Operations

Reports to: Manager of Operational Analytics

Position Overview:

This position involves understanding business questions and data lineage to select applicable data sources and methods for reports and analytics. Working closely with FNB Operations Managers, the candidate should be able to demonstrate the skills needed to define and deliver small to medium sized analytics assignments independently. The primary objective involves developing data-driven insights using SQL/DAX and Power BI visualizations to deliver analytics projects that improve efficiency, communicate metrics, and enable senior management to understand the health of the organization.

Primary Responsibilities:

Performs analytics and reporting, relying heavily on SQL/DAX to source data and PowerBI to communicate data stories. Also uses additional tools and methodologies incorporating the latest technologies and modern techniques to measure and increase awareness of organizational performance and highlight business opportunities.

Develops and produces solutions that can include SharePoint, Power Automate, Microsoft Excel, and Power BI.

Supports and assists members of the Business Analytics team in completion of analytics projects. Provides technical, business intelligence, and analytical guidance to other members of the FNB Operations analytics community in support of their business objectives.

Demonstrates a proactive approach to data accuracy by creating an environment in which inconsistencies can be easily highlighted and corrected by the appropriate team.

Creates a technical environment in which data and solutions are documented properly.

BA or BS

5

MS Excel - Intermediate Level

MS PowerPoint - Intermediate Level

Detail-oriented

Experience with SQL or other data related languages in a professional setting is required

Experience with Microsoft PowerBI or similar is required

Familiarity with a financial organization is highly preferred

N/A

N/A

Equal Employment Opportunity (EEO):