Data and Analytics Engineer 2

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

Job summary

First National Bank is seeking a Data and Analytics Engineer 2 based in Pittsburgh, PA. This position focuses on providing comprehensive data support for various business units and drives data modernization initiatives.

The ideal candidate will have 3+ years in data analysis, experience with Business Intelligence tools, and a BA or BS degree. The role is on-site and requires strong analytical skills to improve metrics and customer experiences.

Qualifications

• 3+ years of experience in data analysis or data mining.
• Experience supporting major Business Intelligence/Data Warehousing systems.
• Ability to work in a fast-paced environment.

Responsibilities

• Collaborate with analysts to understand customer needs and improve business metrics.
• Develop and test analytical solutions such as reports and dashboards.
• Support integration of analytical platforms with enterprise systems.

Skills

Data analysis

Customer service skills

Project management

Business Intelligence tools

Data warehousing

Detail-oriented

Education

BA or BS

Tools

SSIS

Microsoft T-SQL

AWS

Job description

Primary Office Location: 626 Washington Place. Pittsburgh, Pennsylvania 15219.

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

Please note the following:

This on‑site position is based at our Financial Center in Pittsburgh, PA. Candidates must be local or willing to relocate to the area.

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.

At First National Bank, we value relevant experience and the accomplishments you’ve achieved throughout your career. For this position, equivalent experience may be considered in lieu of the education requirements listed below. Specifically, we will accept two (2) years of commensurate experience with an associate degree, or four (4) years of commensurate experience without a bachelor's degree.

We are seeking a Data and Analytics Engineer with strong experience across modern and legacy data environments. This role requires hands‑on expertise in AI technologies such as MCP or RAG, along with Lakehouse architecture, cloud platforms (AWS preferred), APIs, SSIS, and Microsoft T‑SQL. The ideal candidate will be comfortable working with on‑premises legacy systems while helping design and implement forward‑looking data solutions. You will play a key role in driving data modernization initiatives and enabling scalable, future‑ready data platforms.

Position Title: Data and Analytics Engineer 2

Business Unit: Technology

Reports to: Manager of Data and Analytics Engineering

Position Overview

This position is primarily responsible for providing comprehensive data and analytics support for all business units across the corporation and works on low to medium complex and cross‑functional data centric solutions, works on multiple projects as a team member, works with BI and Data Analysts to understand customer need. The incumbent collects, analyzes and shares data to help business teams drive improvement in key business metrics, customer experience and business results and has a moderate impact on operations, resources and the corporation's reputation.

Primary Responsibilities

• Work with Business Information and Data Analysts to understand customer needs, collect, analyze and share data to drive improvement in key business metrics, customer experience and business results.
• Utilize database and web application technologies to develop and evaluate innovative business intelligence tools and automated reports.
• Develop and test analytical solutions such as databases, queries, views, reports and dashboards.
• Assist in data conversions, imports and exports of data within and between internal and external software systems, and document new and existing models, solutions and implementations.
• Design and build reporting and analysis tools that streamline the business and make reporting, analyzing, planning and forecasting more efficient.
• Support and assist with the integration of analytical platforms with enterprise systems and applications.
• Troubleshoot analytics tools, systems, and software, tracking performance and production issues.
• Assist in performance tuning of analytics applications and maintain the quality of the Metadata Repository by adding, modifying, and deleting data.
• Adhere to process, policies and standards; keep customers informed about business intelligence tool problems and resolutions; track and report on issues and enhancement requests for the business in a timely manner.
• Perform assignments using own judgement and following the corporation’s data policy, while keeping supervisor informed as necessary; use discretion to make decisions within scope of responsibilities and review complex assignments upon completion.
• Perform other related duties and projects as assigned.

Minimum Level of Education Required

BA or BS

Minimum Years of Job‑Related Experience Required

3

Skills Required

• Excellent customer service skills
• Ability to use general office equipment
• Ability to work and multi‑task in a fast paced environment
• Excellent organizational, analytical and interpersonal skills
• Detail‑oriented
• Minimum of 3 years of related technical experience
• Minimum of 3 years of experience supporting a major Business Intelligence/Data Warehousing system
• Expert skills in data analysis and data mining

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.