Data & Analytics Engineer II — Lakehouse & AI Focus

FNB Corporation; Pittsburgh, Northern (Allegheny County, KY); Hybrid; USD 85,000 - 125,000; Full time

Job summary

FNB Corporation is seeking a Data and Analytics Engineer 2 to design, implement, and optimize data and analytics solutions in a primarily on-site environment in Pittsburgh, PA. The role focuses on data modernization across legacy and modern environments, leveraging AI tech (MCP or RAG), Lakehouse architecture, AWS, APIs, SSIS, and T-SQL to deliver scalable data platforms.

You will work with BI/Data Analysts to collect, analyze, and share data to improve customer experience and business metrics,

Qualifications

• BA or BS degree required or equivalent experience
• 3+ years in data/analytics roles or BI/DW support
• Experience with data integration, databases, and dashboards
• Experience supporting data modernization initiatives and analytics platforms

Responsibilities

• Develop and test analytical solutions including databases, queries, views, reports and dashboards
• Assist in data conversions and data exchanges between systems
• Document data models, solutions and implementations
• Support integration of analytics platforms with enterprise systems and troubleshoot tools

Skills

Data environments

AI technologies

Lakehouse architecture

AWS cloud

APIs

SSIS

T-SQL

Data modernization

Education

Bachelor's degree

Tools

SSIS

T-SQL

Job description

FNB Corporation is seeking a Data and Analytics Engineer 2 to design, implement, and optimize data and analytics solutions in a primarily on-site environment in Pittsburgh, PA. The role focuses on data modernization across legacy and modern environments, leveraging AI tech (MCP or RAG), Lakehouse architecture, AWS, APIs, SSIS, and T-SQL to deliver scalable data platforms.

You will work with BI/Data Analysts to collect, analyze, and share data to improve customer experience and business metrics,