PNC

Data Analyst – Data and Automation, SQL, Hadoop, Hive, Python

PNC

full-time

Posted on:

Location Type: Office

Location: PittsburghAlabamaOhioUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $45,000 - $123,630 per year

Tech Stack

About the role

  • Provide support to the business and other internal IT organizations regarding data definition standards, architectures, and policies
  • Provide support to business users for mining and interpretation of warehoused and operational data
  • Plan and perform activities regarding designed data models for systems development
  • Resolve metadata and data sourcing problems
  • Maintain metadata and data dictionaries
  • Manage data definitions and data traceability within data repository to improve documentation and coordination

Requirements

  • 2+ years of relevant professional experience
  • Strong problem-solving skills
  • Ability to analyze, model and interpret data
  • Experience in analytics
  • Proficiency in programming languages (SQL)
  • Knowledge of Hadoop, Hive and Impala
  • Skilled in Python
  • Ability to document data requirements
  • Ability to perform data analysis for downstream demand
Benefits
  • medical/prescription drug coverage (with a Health Savings Account feature)
  • dental and vision options
  • employee and spouse/child life insurance
  • short and long-term disability protection
  • 401(k) with PNC match
  • pension and stock purchase plans
  • dependent care reimbursement account
  • back-up child/elder care
  • adoption, surrogacy, and doula reimbursement
  • educational assistance, including select programs fully paid
  • a robust wellness program with financial incentives
  • maternity and/or parental leave
  • up to 11 paid holidays each year
  • 9 occasional absence days each year, unless otherwise required by law
  • between 15 to 25 vacation days each year, depending on career level; and years of service
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLHadoopHiveImpalaPythondata analysisdata modelingdata interpretationmetadata managementdata documentation
Soft Skills
problem-solvinganalytical skills