Audit Data Analytics Director

Overview

Old National Bank has been serving clients and communities since 1834. With $48 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. As a trusted partner, we thrive on helping our clients achieve their goals and dreams, and we are committed to social responsibility and investing in our communities through volunteering and charitable giving.

Our team members are our greatest asset, and we continually invest in their growth and development. We offer a variety of Impact Network Groups led by team members who are passionate about driving engagement, creating awareness of diverse backgrounds and experiences, and building inclusion across the organization.

Internal Audit is increasingly looking for ways to leverage data, analytics, and, more recently AI to drive efficiency and create new insights for our varied stakeholders. The Director of Data Analytics will be central to this effort and proactively lead the advancement of Internal Audit's data analytics program and drive continuous improvement of audits in the plan.

The Director of Data Analytics will lead, perform, and oversee advanced level data analytics. Work involves managing data-driven audits and conducting data analysis projects in support of all disciplines of internal audit; providing input to the development of the annual audit plan; and providing training, coaching, and supervision to internal audit staff on the use of audit analytics.

In addition to data analytics, the incumbent will also lead and participate in IT audit engagements, risk assessments, and continuous monitoring.

Key Accountabilities

Develop the Audit Data Analytics Strategy and Lead Program Execution

• Collaborates on the identification and leads the evaluations of opportunities to deploy data analytics to significantly expand internal audit coverage and enhance audit testing efficiencies.

• Manages the performance of audit analytics procedures, including identifying and defining issues, developing criteria, reviewing and analyzing evidence, and documenting Company activities.

• Creates and integrates the use of data analytics across the internal audit lifecycle: risk assessments, audit execution, reporting, and continuous auditing/monitoring.

• Communicates the results of audit analytics to internal audit staff and where appropriate to audit clients.

• Provides guidance to the audit staff in identifying opportunities to use data in internal audits and incorporating data techniques within internal audit testing procedures.

• Identifies opportunities for continuous monitoring and process automation for Internal Audit and potential use in controls activities performed by audit clients.

• Builds and develops an analytics catalogue that includes automated scripts that can be used for continuous auditing.

• Manages and trains others in the application data extraction and analysis tools.

• Network to cultivate strong relationships with Company-wide partners to ensure successful analytic activities such as retrieval of new data sets, learning technology architecture, and troubleshooting.

Planning and Completion of Audit Projects

• Serves as a subject matter expert with advanced organization, technical, and IT knowledge and auditing skills.

• Provides direct managerial oversight throughout the audit process to ensure the successful and timely execution of IT audits in accordance with the department's audit methodology and professional standards.

• Ensures audit reports are issued promptly and prepared in accordance with quality expectations.

• Anticipates challenges, assesses, and manages risks to the successful completion of audit projects.

• Oversees testing associated with the field work phase of the audit and ensures workpapers satisfy audit program steps and support the results of field work. Reviews evidence, root cause, and draft of proposed audit observations and recommendations for improvement. In addition, reviews follow- up testing on audit report findings to ascertain that management implemented their corrective action plan timely.

• Champions and implements data analytics within audit engagements.

Leads, coaches, and develops Internal Audit team

• Shares business expertise with audit team to ensure that decisions pertaining to the nature, timing and extent of audit work are appropriate and that the skill sets of the team are continually enhanced.

• Improves and reinforces the performance of others by providing timely, candid, and constructive performance feedback; facilitates skill development through coaching.

• Communicates clear expectations, monitors and measures progress and results, rewards and recognizes success, deals with problem performance; promotes a culture of mentoring and knowledge transfer to enhance the performance of the entire team.

• Drives a rewarding team member experience and facilitates the learning, growth and performance of each team member through effective on-going development discussions, support of individual development planning, and career exploration.

Special Projects

Participates in special projects as requested by management. Examples include participating in the annual risk assessment process, providing support to external auditors and/or regulators, and attending selected committee meetings.

Key Competencies for Position

Execution Leadership

Establish Plans & Priorities:

• Determines a course of action and establishes a timeframe to complete individual objectives and team goals.

Problem Solving:

• Identifies the root cause of identified issues by consulting with line of business personnel and subject matter experts. Demonstrates strong analytical and technical skills and manages complex tasks.

Drive and Execution:

• Self-motivated and takes initiative; proactively learns new skills and develops self for current performance and future growth; demonstrates a desire to learn and actively seeks ways to improve current methods, systems, processes, and procedures.

Culture Leadership

People Leadership:

• Coach & Empower Others-Provides timely feedback, support and guidance to encourage and support team members to accomplish tasks, solve problems, and enhance their professional development.

• Gaining Agreement-Uses appropriate interpersonal styles and techniques to gain acceptance of ideas or plans; modifies one's own behavior to accommodate tasks, situations and individuals involved.

Communication:

• Exhibits strong communication skills with the ability to clearly articulate and convey information and ideas to all levels of the organization.

• Demonstrates an understanding of who will be affected by an issue or change and ensures all stakeholders are kept informed.

Collaboration:

• Actively seeks, develops, and maintains trusted relationships with others in the department and external to the department to achieve corporate business goals and objectives.

• Effectively identifies solutions by engaging different ideas, perspectives, and line of business expertise when analyzing a situation or developing a solution.

• Provides knowledge, information, ideas, and suggestions to accomplish mutual goals within the department and those external to the department.

Qualifications and Education Requirements

• Bachelor's degree in MIS, Accounting, Computer Science or other IT-related field.

• Professional certification (CISA, CISSP, CISM, etc.) required.

• Minimum of 10 years of progressive management experience in an internal or external IT audit/data analytics function, preferably within the banking industry.

• Experience developing data analysis routines and documenting data extraction, transformation, and loading processes required.

• Strong working knowledge of data analytics and programming tools (for example: Alteryx, Excel, Access, SQL Developer, etc.).

• Knowledge of data analytics practices and concepts (for example, CAAT, trend analysis, data visualization, reasonability analysis, and regression analysis).

• Demonstrated experience in leading and executing all aspects of the audit lifecycle, including planning, risk assessment, scoping, detailed testing and reporting.

• Expert understanding of IT security, governance, network, and infrastructure processes and procedures.

• Advanced understanding of concepts related to information technology risk and control at all layers of the technology stack, including logical and physical security, change management, IT operations, business continuity management and network technologies.

• Strong knowledge of relevant industry frameworks and related regulatory guidance (e.g. COBIT, ITIL, NIST, FFIEC, ISO 27002, etc.) and applicable banking regulations, such as GLBA.

• Proficient in Microsoft Office products (Excel, Access, PowerPoint, Word, and Visio).

• Outstanding communication skills, both oral and written.

• Demonstrated ability to grasp, communicate and teach others how to identify underlying concepts in complex information.

• Strong project management and time management skills, ability to effectively balance competing priorities, and demonstrated success in delivering work on time and within budget.

• Ability to partner effectively with multiple business/functional groups/leaders.

• Knowledge of SOX 302/404, SSAE 18/SOC1/2/3.

Key Measures of Success/Key Deliverables:

• Works closely with the audit team to build innovative and reusable analytics tools that make audit testing more efficient and provide meaningful insights into the Company's control environment.

• Serves as a role model relative to project management by placing an appropriate emphasis around the timing of deliverables, anticipating resource/deadline challenges, and meeting personal deadlines in support of the team.

• Consistently demonstrates an advanced level of business (e.g., products, processes, services), technical, and organizational knowledge and takes steps to continuously update this understanding as it pertains to assigned business units.

• Provides strategic leadership to team through application of advanced competencies in technical skills, logical reasoning and overall audit proficiency.

• Champions continuous control monitoring/improvement and dynamic risk assessment through audit technologies, including audit process automation, and data analytics.

• Remains current on industry trends (via involvement with pertinent industry associations and other education/training) to stay apprised of emerging issues/risks and identifying/leveraging audit best practices.

• Builds and maintains strong cross-functional collaborative relationships with company IT leadership, including the CISO, CIO, and other product technology and functional business leaders.

Old National is proud to be an equal opportunity employer focused on fostering an inclusive workplace and committed to hiring a workforce comprised of diverse backgrounds, cultures and thinking styles.

As such, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as a qualified individual with disability, sexual orientation, gender identity or any other characteristic protected by law.

We do not accept resumes from external staffing agencies or independent recruiters for any of our openings unless we have an agreement signed by the Director of Talent Acquisition, SVP, to fill a specific position.

Our culture is firmly rooted in our core values. We are optimistic. We are collaborative. We are inclusive. We are agile. We are ethical.

We are Old National Bank. Join our team!