Address
Form of work
SalarySUMMARY: The purpose of this position is to help the Internal Audit Department (IAD) become more data driven in the delivery of its services by consulting with IAD team members to develop and apply data analysis strategies to enhance audits and ongoing monitoring activities. The Data Analytics Program Manager will become the point person for the IAD's use of various data marts and reporting tools, including Oracle Business Intelligence Enterprise Edition (OBIEE), Microsoft Sequel Server Reporting (SSRS) and Tableau.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned.
- Develop and maintain Internal Audit's Data Analytics Program and Methodology.
- Develop the framework and procedures of the department's Data Analytics Program.
- Write complex programs and ad hoc queries by utilizing enterprise data to fulfill audit data analysis requirements.
- Ensure that all code is developed in a well-structured manner, functions as required, is validated, includes sufficient comments, and is easy to maintain and reuse.
- Bring structure to each data analytic request and translate requirements into an investigative approach to probe for hidden questions and trends within the data.
- Maintain and execute the inventory of Data Analytics routines for continuous monitoring of other defined activities, including the development and ongoing management of data models as needed.
- Participate in the planning of audits and provide support to Internal Auditors in the execution of audits requiring Data Analytics.
- Provide support to model risk management and validation review activities conducted by the IAD such as data quality assessments and associated reconciliation(s). Prepare clear and concise work papers documenting the Data Analytics supporting audit procedures.
- Discuss results from the Data Analytics Program with the audit team and business line stakeholders.
- Maintain positive team relationship by demonstrating and supporting initiative, willingness to learn, flexibility, respect, cooperation and commitment to the success of the internal audit process.
- Stay abreast of new trends and developments in Data Analytics by leading and/or attending seminars, training sessions, and workshops, as necessary to develop and ensure success of the department's Data Analytics Program.
- Keeps abreast of regulations, industry, and information technology changes.
- Serve in a consultative capacity (Subject Matter Expert) to business units on Data Analytics techniques, tools, and other technical matters.
- Ensure department team members are aware of the Data Analytics framework and its application and relevance to their audit projects.
- Conducts training sessions to audit team members on tools and data sources used to perform data analytic routines.
- Acts as the liaison between the Internal Audit and IT Departments.
- Ensures adherence to professional audit standards.
- Work with the Internal Audit Management on special projects as assigned.
- Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
- Adheres to Bank policies and procedures and completes required training.
- Identifies and reports suspicious activity.
SUPERVISORY RESPONSIBILITIES:
- Supervises function, projects or services and/or one or more employees, as applicable.
- Carries out supervisory responsibilities in accordance with the organization's policies and applicable laws.
- Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance coaching; rewarding and disciplining employees; addressing complaints and resolving problems.
