Senior Data Analyst: Oracle SQL & Tableau Expert

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

Benefits offered by this job

Comprehensive benefits package

401(k) with company match

Pension and stock purchase plans

Wellness program

Job summary

PNC is seeking a Sr Data Analyst in Pittsburgh, Strongsville, or Dallas to turn business needs into robust data solutions. You will design database objects, optimize performance, and deliver actionable insights.

You will build dashboards with Tableau and Excel and maintain SQL scripts for release cycles. Preferred candidates bring MongoDB experience and strong data analytics, mining, and science fundamentals; Oracle/ETL tooling proficiency is expected.

Qualifications

• Bachelor's degree in a related field with 3+ years of experience.
• Strong analytical and data modeling capabilities are required.
• Proficiency with Tableau, Excel, SQL and ETL tools is expected.
• Experience with MongoDB and ML concepts is a plus.

Responsibilities

• Partner with Product Owners and technical teams to translate business requirements into data solutions.
• Design and develop database objects, including tables, views, and stored procedures.
• Implement constraints, indexing, and performance optimization for data systems.
• Deliver insights to improve processes, products and performance.
• Develop dashboards and reports using Tableau and Excel.
• Develop and maintain SQL scripts and stored procedures; ensure test coverage.
• Support monthly release cycles with troubleshooting and issue resolution.

Skills

Analytical Thinking

Data Analytics

Data Mining

Data Science

Machine Learning

MongoDB

Education

Bachelor's degree

Tools

Tableau

Excel

SQL Developer

TOAD

JIRA

Confluence

Visio

Informatica ETL

Oracle Database

Job description

PNC is seeking a Sr Data Analyst in Pittsburgh, Strongsville, or Dallas to turn business needs into robust data solutions. You will design database objects, optimize performance, and deliver actionable insights.

You will build dashboards with Tableau and Excel and maintain SQL scripts for release cycles. Preferred candidates bring MongoDB experience and strong data analytics, mining, and science fundamentals; Oracle/ETL tooling proficiency is expected.