Senior Data Analyst - Oracle SQL & Tableau Expert

PNC; Pittsburgh (Allegheny County); On-site; USD 75,000 - 138,000; Full time

Benefits offered by this job

Medical and dental benefits

401(k) with match

Paid time off

Job summary

PNC is seeking a Senior Data Analyst within its Technology division, based in Pittsburgh, Strongsville, or Dallas. You will translate business requirements into data solutions, design database objects, and deliver dashboards with Tableau and Excel to improve processes and performance.

Required experience includes Oracle Database, Informatica ETL, Tableau, and SQL tools; MongoDB is a plus. The role emphasizes data accuracy, governance, and collaboration with cross-functional teams.

Qualifications

• Bachelor's degree required with at least 3 years of relevant experience.
• Proficient in Oracle Database, Informatica ETL, Tableau, JIRA and Confluence.
• Experience with SQL development tools and data visualization platforms.
• Knowledge of data governance and performance optimization best practices.

Responsibilities

• Partner with Product Owners and technical teams to understand business requirements and translate them into data solutions.
• Design and develop database objects including tables, views and stored procedures.
• Implement indexing strategies and performance optimizations for data systems.
• Develop dashboards and reports using Tableau, Excel, and similar platforms.
• Provide support during monthly release cycles and troubleshoot issues.

Skills

Analytical Thinking

Data Analytics

Data Mining

Data Science

Machine Learning

MongoDB

Education

Bachelor's

Tools

Oracle Database

Informatica ETL

Tableau

JIRA

Confluence

Visio

SQL Developer

TOAD

MongoDB

Job description

PNC is seeking a Senior Data Analyst within its Technology division, based in Pittsburgh, Strongsville, or Dallas. You will translate business requirements into data solutions, design database objects, and deliver dashboards with Tableau and Excel to improve processes and performance.

Required experience includes Oracle Database, Informatica ETL, Tableau, and SQL tools; MongoDB is a plus. The role emphasizes data accuracy, governance, and collaboration with cross-functional teams.