Geospatial Data Analyst

First National Bank Of Pennsylvania; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

First National Bank Of Pennsylvania is seeking a Geospatial Data Analyst in Pittsburgh to leverage geospatial and internal data for retail channel optimization and branch distribution strategy. You will extract, transform, and analyze data from Esri GIS, SQL, Python, and Excel to generate actionable insights for senior leadership.

The role emphasizes data visualization, dashboard development, and ongoing education in GIS, analytics, and regulatory matters, with collaboration across bank

Qualifications

• Experience with geospatial data analysis using Esri GIS tools.
• Strong programming skills in Python for data extraction and analysis.
• Proficiency in SQL for data querying and transformation.
• Advanced Excel skills for data manipulation and reporting.

Responsibilities

• Perform advanced geospatial and data analytics to support retail channel optimization.
• Build and maintain a library of data workflows and methodologies with change control.
• Maintain accurate geospatial data for retail locations and ensure cross-department consistency.
• Develop and optimize GIS dashboards and visualization tools for decision making.

Skills

Esri GIS Platform

Python

SQL

MS Excel

MS Word

MS PowerPoint

Education

BA or BS

Tools

Esri GIS Platform

Job description

Primary Office Location: 626 Washington Place. Pittsburgh, Pennsylvania. 15219. Join our team. Make a difference - for us and for your future.

Position Title: Geospatial Data Analyst

Business Unit: Retail

Reports to: Retail Channel Optimization Manager

Position Overview: An impactful position that leverages geospatial, internal, and external data to support retail channel optimization strategy and branch distribution. The position gathers and extracts data from various sources and transforms it to provide actionable insights for retail and support requests from other departments. Data and insights this position provides are extensively utilized by senior leadership for decision making around branch distribution strategy.

Primary Responsibilities

• Data Analytics: Performs advanced geospatial and data analytics utilizing the Esri platform, SQL, Python, Excel and other analysis tools to drive decision making around retail operations and optimization.
• Process Documentation: Build and maintain a process library for workflows and methodologies as it relates to Retail Channel data analysis and decision making. This person will be responsible for maintaining change control across RCO analytical processes.
• Data Management and Integrity: Maintains accurate and up to date geospatial data for retail locations and ensures consistency across departments.
• Data Visualization and Insight Tools: Continually provide improvement to data visualizations and information presentation. Build and maintain GIS tools and dashboards that can be used to understand and guide decision making of retail operations.
• Education: Continued education and skill development in geographic information systems, data analysis, business strategy, and regulatory matters.
• Support: Support requests from other departments within the bank. 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.
• Compliance with regulatory laws and company procedures is a required component of all position descriptions.

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

• Excellent communication skills, both written and verbal
• Detail-oriented
• Ability to work and multi-task in a fast paced environment
• Ability to use a personal computer and job-related software
• MS Word - Intermediate Level
• MS Excel - Intermediate LevelMS PowerPoint - Intermediate Level
• Excellent organizational, analytical and interpersonal skills
• Python - Intermediate Level
• SQL - Basic Level
• Esri GIS Platform - Intermediate level

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.

A culture of teamwork. A history of success. As a leading diversified financial services company, F.N.B. Corporation (FNB) offers a wide range of opportunities for individuals who want to grow their careers. The FNB team is a group of highly qualified professionals who work together to provide comprehensive financial solutions across our corporate footprint, which includes Pennsylvania, Ohio, Maryland, West Virginia, Virginia, North Carolina, and South Carolina. Our consistent recognition as a best place to work and top workplace by our own employees symbolizes the outstanding culture we represent.