• Internal Audit Senior Data Analyst

    ID
    2019-7329
    Job Locations
    US-CA-San Francisco
    Category
    Audit
  • Overview

    As a member of our Internal Audit Team, the Internal Audit – Senior Data Analyst will assume a lead role in maturing Internal Audit’s data analytics program. The role will focus on meeting the data analytics needs for the Internal Audit department including internal audit planning, fieldwork, and reporting, review of the Bank’s key risk indicators, and monitoring of new and emerging risks. The role will be working closely with the Bank’s Information Technology groups, Enterprise Data and Client Insights group, and other lines of business to identify systems of record and data sources, extract data into staging tables, and present the data in the format needed for analysis.

    Responsibilities

    1. Execute on Internal Audit’s data analytics strategy, program, and projects.
    2. Pull and analyze data using SQL out of various database sources. Extract, transform and load data and prepare data for analytics by cleansing, wrangling, and formatting data.
    3. Build Internal Audit data dictionary by mapping audit engagement driven data requirements to independent data sources that have been certified by the Bank’s Enterprise Data Management.
    4. Prepare the necessary documentation and visualization to increase clarity in data lineage and firm understanding of developed data solutions in support of internal audit engagements, continuous monitoring activities, and risk management.
    5. Provide support in building the infrastructure for data analytics, including developing ETL processes and creating or modifying data marts
    6. Be recognized as a data management consultant, and data analytics expert, while developing and maintaining collaborative working relationships with various teams within the Bank, learning and understanding the business to better provide value-added services, helping management achieve objectives, and enhancing customer satisfaction.
    7. Maintain professional certification(s) and continue to develop and expand knowledge of data analytics, the audit profession, Information Technology, bank regulatory issuances, the financial industry, and Company products and information through self-study, research, and continuing education efforts.
    8. Perform duties and responsibilities specific to department functions and activities.
    9. Perform other duties and responsibilities as required or assigned by supervisor.
    10. Responsiblities include the following: 1) adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.), 2) adhering to Bank policies and procedures, 3) completing required training, 4) identifying and reporting potential suspicious activity to the BSA/AML Officer, and 5) knowing and verifying the identity of any customer(s) that enters into a relationship with the Bank

    Qualifications

    Key Skills, Knowledge and Abilities:

     

    Required:

    • 3-5 years of demonstrated data analytics-related experience
    • BA/BS in Information Systems Administration, Computer Science, Statistics, Mathematics, or related field
    • Advanced proficiency in SQL and relational database concepts
    • Advanced proficiency in scripting languages, such as Python
    • Advanced proficiency with data visualization tools, such as Tableau
    • Strong report writing and presentation skills
    • Strong analytical and problem-solving skills
    • Strong interpersonal and communication skills

    Preferred:

    • Exposure to statistical methods and analysis tools, such as R
    • Demonstrated experience in machine learning models such as Natural Language Processing, Clustering, and Random Forest
    • Professional certification, such as certifications in SQL, CIA, CISSP, CISA, CPA, or relevant technical certification
    • Strong background in auditing techniques and/or computer control environments
    • “Big 4” public accounting or consulting experience
    • Banking or finance experience
    • Internal audit, risk management, or compliance experience

    Other Expectations:

    • Ability to critically analyze and assess the adequacy of internal controls and opportunities for process improvements and efficiency gains
    • Self-starter who excels at learning new processes and business functions.
    • Excellent written and verbal communication skills with ability to work and communicate with IT and business process owners.
    • Demonstrated integrity within a professional environment.
    • Ability to work effectively as part of a team environment and independently as an individual contributor, demonstrating a continuous commitment to improvement.
    • Advanced level of PC skills with Microsoft Office applications.
    • Provides extraordinary service.
    • Furthers the First Republic Bank culture and values.

    Mental/Physical Requirements:

    • The ability to learn and comprehend basic instructions; understand the meanings of words and respond effectively; and perform basic arithmetic accurately and quickly.
    • Vision must be sufficient to read data reports, manuals and computer screens.
    • Hearing must be sufficient to understand a conversation at a normal volume, including telephone calls and in person.
    • Speech must be coherent to clearly convey or exchange information, including the giving and receiving of assignments and/or directions.
    • Position involves sitting most of the time, but may involve walking or standing for brief periods of time.
    • Must be able to travel as position requires.
    • May be required to lift 25-50lbs.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed