Operational Analytics Analyst 2

First National Bank; Pittsburgh (Allegheny County); On-site; USD 70,000 - 90,000; Full time

Job summary

First National Bank in Pittsburgh is hiring an Operational Analytics Analyst 2 to drive data-driven insights and improve operational efficiency. This role requires proficiency in SQL and Power BI, with a focus on developing analytics projects that aid in understanding organizational performance.

Candidates should have a BA or BS degree and at least 5 years of experience in analytics. Strong communication and organizational skills are essential, along with the ability to handle multiple tasks in a fast-paced environment.

Qualifications

• 5+ years of related experience in analytics and reporting.
• Proven experience in SQL or data-related languages.
• Familiarity with financial organizations is highly preferred.

Responsibilities

• Perform analytics and reporting using SQL/DAX and Power BI.
• Support and assist team members in completing analytics projects.
• Ensure data accuracy and documentation of solutions.

Skills

MS Excel - Intermediate Level

MS PowerPoint - Intermediate Level

Detail-oriented

Excellent communication skills, both written and verbal

Ability to work and multi-task in a fast paced environment

Excellent organizational, analytical and interpersonal skills

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

Experience with Microsoft PowerBI or similar

Education

BA or BS

Job description

Primary Office Location: 100 Federal Street. Pittsburgh, Pennsylvania. 15212.

Join our team. Make a difference - for us and for your future.

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.
• Performs other related duties and projects as assigned.
• All employees have the responsibility and the accountability to serve as risk managers for their businesses by understanding, reporting, responding to, managing and monitoring the risk they encounter daily as required by F.N.B. Corporation's risk management program. F.N.B. Corporation is committed to achieving superior levels of compliance by adhering to regulatory laws and guidelines.

Minimum Level of Education Required to Perform the Primary Responsibilities of this Position

BA or BS

Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position

5

Skills Required to Perform the Primary Responsibilities of this Position

• MS Excel - Intermediate Level
• MS PowerPoint - Intermediate Level
• Detail-oriented
• Excellent communication skills, both written and verbal
• Ability to work and multi-task in a fast paced environment
• Excellent organizational, analytical and interpersonal skills
• 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

Licensures/Certifications Required to Perform the Primary Responsibilities of this Position

N/A

Physical Requirements or Work Conditions Beyond Traditional Office Work

N/A

Equal Employment Opportunity (EEO)

It is the policy of F.N.B. Corporation (FNB) and its affiliates not to discriminate against any employee or applicant for employment because of age, race, color, religion, sex, national origin, disability, veteran status or any other category protected by law. It is also the policy of FNB and its affiliates to employ and advance in employment all persons regardless of their status as individuals with disabilities or veterans, and to base all employment decisions only on valid job requirements. FNB provides all applicants and employees a discrimination and harassment free workplace.

FNB will not provide sponsorship for employment-based visas for this position; only candidates who are legally authorized to work in the U.S. will be considered.