Internal Audit Data Analyst

The overall purpose of the Internal Audit Data Analyst is to aggregate data for various purposes and analyze for trends to check for compliance or seek improvements in process management. This will be inward looking at the Internal Audit department and outward looking into the Bank's various business processes. The Analyst will be expected to interpret applicable policy or regulation and determine if the process under review is operating within the required expectations. The Analyst should have experience, or be willing to learn, how to successfully execute all components of an internal audit project.

The Analyst is responsible for completing the following types of processes:

• Understand the bank’s core data systems, how the data is used within the bank's business processes, and what tool(s) are best suited to extract, compile and analyze the data.
• Recognize trends or process changes, with supervisory guidance, that affect the makeup of the data and bring to the attention of the Project Lead for possible action.
• Perform testing for the Project Leads as requested and conduct bank application user access testing.
• Create well-documented test templates with easily repeatable data pulls and analysis to automate testing and reduce the time required each subsequent audit cycle.
• Develop and maintain documentation of bank data sources and contact information for subject matter experts.
• Actively seek process improvement opportunities, and recommend and implement continuous improvement in departmental reports and templates.
• Develop and maintain departmental reports including trending data to isolate and highlight potential areas of concern and identifying other processes within the Bank that may have a heightened risk of encountering similar issues.
• Provide staff with technical assistance in the use of Excel, Adobe Acrobat, Copilot and other software; and prepare and present formal training material from time to time as the need arises.

Position Requirements:

• Bachelor's degree in Accounting, Finance, Statistics, or other business related or technology related field and 1-3 years related work experience. CIA, CPA, CISA a plus. GPA of 3.0 or better.
• Will consider a Bachelor's Degree in a non-business related field with a minimum GPA of 3.0, if candidate has two years of relevant experience.
• In lieu of GPA will consider 5-7 years of commensurate experience in internal audit or in a related area, including banking, risk management, quality assurance, compliance, data or technical function.
• Candidate should have a working knowledge of the Microsoft Office Suite (Excel, Word, Outlook, Teams).
• Position requires a minimum of 3 years of relevant US based experience.
• Must reside in Oklahoma to be considered

Preferred Qualifications:

• Preference given for a background in Internal Audit or as a Banking Analyst or technology/quality assurance auditing.
• Understanding of technology related controls and application of data analysis within the audit program.
• Willingness to learn and engage with emerging technologies and data aggregation and analysis tools including Microsoft Access, Microsoft Copilot, SQL server, and/or PowerQuery/PowerBI.
• Professional certifications such as CIA, CISA, CFE, or CPA are a plus, but not required.