
Data Analyst – Data and Automation, SQL, Hadoop, Hive, Python
PNC
full-time
Posted on:
Location Type: Office
Location: Pittsburgh • Alabama • Ohio • United States
Visit company websiteExplore more
Salary
💰 $45,000 - $123,630 per year
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