Data & Analytics Engineer II — Lakehouse & AI Solutions

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

Job summary

F.N.B. Corporation is seeking a Data and Analytics Engineer 2 in Pittsburgh, PA. You will provide data and analytics support across business units, building BI tools, dashboards and automated reports while collaborating with Data Analysts to understand needs.

The role requires hands-on experience with modern and legacy data environments, cloud platforms (AWS preferred), APIs, SSIS, and MS T-SQL. You will work on data modernization and scalable data platforms within a primarily on-site setting.

Qualifications

• BA or BS degree (or equivalent experience) required.
• 3+ years of experience with BI/DW systems.
• Strong data analysis and data mining skills.

Responsibilities

• Develop and test analytical solutions, dashboards and reports.
• Assist in data conversions, imports and exports between systems.
• Design and build reporting tools to streamline planning and forecasting.
• Troubleshoot analytics tools and monitor performance.
• Ensure data quality and metadata management.

Skills

Data Analytics

BI / DWH

SQL / T-SQL

Cloud AWS

ETL / SSIS

Data Mining

AI / RAG

Stakeholder mgmt

Education

BA or BS

Tools

AWS

Job description

F.N.B. Corporation is seeking a Data and Analytics Engineer 2 in Pittsburgh, PA. You will provide data and analytics support across business units, building BI tools, dashboards and automated reports while collaborating with Data Analysts to understand needs.

The role requires hands-on experience with modern and legacy data environments, cloud platforms (AWS preferred), APIs, SSIS, and MS T-SQL. You will work on data modernization and scalable data platforms within a primarily on-site setting.