Internal Audit Data Analyst

MidFirst Bank

Oklahoma City (OK)

On-site

USD 65,000 - 85,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

MidFirst Bank seeks an Internal Audit Data Analyst to aggregate data from core systems, analyze trends for compliance and process improvements, and support audit testing. The role emphasizes data interpretation, documentation, and proactive process enhancement within the Internal Audit department.

The candidate should have a Bachelor's degree in a related field and 1–3 years of relevant experience, with a willingness to learn SQL Server, Power BI, and Copilot for data analysis.

Qualifications

  • Bachelor's degree or higher in a business or tech field with 1–3 years related experience.
  • Proficiency with MS Office suite; familiarity with Excel data analysis and reporting.
  • CIA, CPA, or CISA is a plus but not required.

Responsibilities

  • Aggregate data from core systems and analyze trends to identify improvements.
  • Perform data-driven testing and assist with access testing for applications.
  • Develop reusable templates and documentation for audit data pulls and analyses.
  • Create departmental reports with trend data to highlight risks and opportunities.
  • Provide technical assistance and training on Excel, Copilot, and data tools.

Skills

Excel
Word
Outlook
Teams

Education

Bachelor's degree in Accounting, Finance, Statistics, or related field

Tools

Microsoft Access
Microsoft Copilot
SQL Server
PowerQuery
Power BI

Job description

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 relatedor 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.

#LI-DNI

Qualifications
Education
Required

Bachelors or better.

Experience
Required

Candidate should have a working knowledge of the Microsoft Office Suite (Excel, Word, Outlook, Teams).

5-7 years: 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.

2 years: Will consider a Bachelor's Degree in a non-business related field with a minimum GPA of 3.0 with relevant expereince in internal audit or in a related area, including banking, risk management, quality assurance, compliance, data or technical function.

Preferred

1 year: Related work experience in internal audit or in a related area, including banking, risk management, quality assurance, compliance, data or technical function.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Staff Internal Auditor
Staff Internal Auditor

Hancock Whitney Corp. • New Orleans (LA)

On-site
USD 65,000 - 95,000
ATG INTERNAL AUDITOR
ATG INTERNAL AUDITOR

ATSG • Wilmington (OH)

On-site
USD 65,000 - 90,000
Internal Auditor
Internal Auditor

FIRST ACCEPTANCE INSURANCE • Nashville (TN)

On-site
USD 70,000 - 100,000
Internal Control Auditor
Internal Control Auditor

First Bank & Trust Co. • Norman (OK), Oklahoma City (OK)

On-site
USD 55,000 - 85,000
Staff Internal Auditor
Staff Internal Auditor

Hancock Whitney Corp. • Gulfport (MS)

On-site
USD 60,000 - 95,000
IT Auditor Senior
IT Auditor Senior

City National Bank (CNB) • Coral Gables (FL)

On-site
USD 90,000 - 120,000
Strategic Internal Auditor
Strategic Internal Auditor

Air Transport Services Group Inc • Wilmington (OH)

On-site
USD 65,000 - 90,000
Senior Internal Audit-Data Analyst
Senior Internal Audit-Data Analyst

Saia Inc. • Johns Creek (GA)

On-site
USD 80,000 - 100,000
Senior Internal Auditor, Financial Operations & Controls
Senior Internal Auditor, Financial Operations & Controls

Associa Community Management Corp. • Richardson (TX)

On-site
USD 85,000 - 120,000
Internal Auditor - Compliance
Internal Auditor - Compliance

Farmers National Bank • Canfield (OH)

On-site
USD 75,000 - 110,000