Senior Data Analyst

Key Skills

ipad, Java Programming, Python Programming, Database, SQL, Tableau, SAS, Qlik Sense, ETL frameworks

Job Description

Gather, analyze, document and maintain all data requirements related to the business applications, interfaces and reporting environments. Apply standards and best practices to ensure the Bank’s data is accurate, complete, current, understandable and accessible. Work closely with internal clients, business analysts and development project teams to resolve information flow and content issues.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

Required Qualifications:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree in information technology, information systems, computer science or business-related field, eight years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and/or sophisticated data presentation or equivalent education and related training or experience
• Experience in ETL Development using standard tools
• Understanding of Enterprise Data Warehouse concepts and prior experience applying that understanding to query data in a Very Large Database (VLDB) environment
• Familiarity in using a query analysis tool

Additional Required Qualifications:

• 7+ years of experience working as a Data/Data Quality Analyst
• 7+ years of experience working as a Business Analyst
• Working knowledge of Data Management principles
• Ability to create complex data flows – from interviews with stakeholders
• Ability to do SQL queries across multiple systems
• Experience with Informatica Data Quality
• Experience working with SAS, Tableau, Qlik Sense, Data Wrangling Tools (e.g. Trifacta or Alteryx) is an advantage
• Experience with Powerpoint Presentations

Preferred Qualifications:

• Experience working with ETL tools (e.g. Informatica)
• Knowledge of FRY 14Q and/other regulatory reports
• Project/Program Management Experience
• Experience working with client data
• Experience performing statistical analysis of data and using data to predict trends
• Excellent verbal and written skills
• Good presentation and reporting skills
• Ability to work and thrive in a dynamic and political environment
• Master’s degree or MBA and three years of related experience
• Previous experience in the banking or financial services industry

OTHER JOB REQUIREMENTS / WORKING CONDITIONS

Sitting

• Constantly (More than 50% of the time)

Visual / Audio / Speaking

• Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone.

Manual Dexterity / Keyboarding

• Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.

Availability

• Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.

Travel

• Minimal and up to 10%