Skip to main content

Senior Data Analyst - SQL, Python

Senior Data Analyst - SQL, Python
PNC
9 months 2 weeks ago

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued, and have an opportunity to contribute to the company’s success. As a Data Analyst Senior - Hadoop, SQL, Python within PNC's Enterprise Data Management Analytics Competency Center, you will be based in Pittsburgh-PA, Cleveland-OH, and Chicago-IL.

Responsibilities include:

  • Must have experience with Hadoop, SQL, and Python
  • Collaborate and partner with technology to assess and establish processes to govern platform health and efficiency
  • Provide onboarding and user support for enterprise analytic and big data platforms, with a focus on supporting platform users
  • Monitor platform performance and provide analysis for optimization opportunities
  • Understand downstream implications of any platform, process, or governance changes and clearly communicate these to impacted partners
  • Monitor reporting on the performance of big data platforms and tools
  • Organize, prepare content, and present updates to leadership and/or business partners during ACC-owned working group meetings
  • Coding Languages: SQL, Python
  • Familiarity with Tableau and Spark
  • Exploratory data analysis
  • Understanding of Hadoop/HDFS
  • Understanding of data risk

Job Description

  • Manages and develops information systems for clients; conducts data information analysis for a variety of studies under the direction of organizational standards.
  • Advises end-users on data manipulation, end-user support systems, and statistical analysis.
  • Selects new information sources and acquires stock. Catalogs and indexes new materials.
  • Implements and supports technologies for managing and effectively utilizing multiple information sources, formats, and uses.
  • Researches customers' needs, conducts awareness, and promotional sessions for potential customers.

Competencies

  • Application Design, Architecture – Knowledge of application design activities, tools and techniques; ability to utilize these to convert business requirements and logical models into a technical application design.
  • Business Intelligence – Knowledge of and ability to utilize business processes and technologies for gathering, storing, analyzing, and providing access to data that helps the organization make better business decisions.
  • Data Architecture – Knowledge and ability to create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.
  • Data Mining – Knowledge of tools, techniques, and practices in data mining technologies used to acquire essential business information.
  • Emerging Technologies – Knowledge of and ability to design, apply, and evaluate new information technologies for business environments in order to improve work productivity and accuracy.
  • Informatics/Information Sciences – Knowledge of and the ability to gather, communicate and store useful information within and across organizations in order to enhance employee knowledge and improve organizational performance.

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job-specific certification(s), and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include 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; maternity and parental leave; paid holidays, vacation days, and occasional absence time; 401(k), pension, and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

Disability Accommodations Statement:

If an accommodation is required to participate in the application process, please contact us via email at ***************@pnc.com Click To Reveal Email. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call Click To Reveal Phone and select Option 4: Recruiting for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice (Click To Reveal Link) to gain an understanding of how PNC may use or disclose your personal information in our hiring practices.

Recommended Skills

  • Analytical
  • Apache Hadoop
  • Apache Spark
  • Application Design
  • Architecture
  • Big Data

Expertise level

Work arrangement

Key skills

Similar Jobs in United States

Similar Jobs in Pennsylvania

Similar Jobs in Pittsburgh