Internal Audit Data Analyst
Company: BOK Financial
Posted on: February 16, 2020
Areas of Interest:Audit
BOK Financial (BOKF), Headquartered in Tulsa, Oklahoma, BOK
Financial Corporation (NASDAQ: BOKF) is a top 25 U.S.-based
financial services holding company with operations in ten states -
Oklahoma, Texas, Arkansas, Arizona, Colorado, Kansas/Missouri, New
Mexico, Nebraska and Wisconsin. The company began more than 100
years ago in Tulsa and has successfully diversified into a variety
of industries, businesses and geographies. .
The Internal Audit Data Analyst is responsible for extracting and
aggregating the critical data and data insights (i.e., trends,
patterns, outliers) to support BOKF's internal audit teams in the
identification of business process risks and control weaknesses. In
executing the responsibilities of this position, the incumbent
collaborates with Director, IA Data Analytics and assigned audit
team to identify the audit objective of the analytic; determine the
approach; identify the data elements required. In partnership with
IT and line of business personnel, the incumbent identifies
systems, data format and file requirements; and utilizes
computer-assisted audit techniques (CAATs) to access and aggregate
data in addition to providing technical expertise on data
validation, data cleansing and analysis.
PRINCIPAL DUTIES AND RESPONSIBILITIES
- Supports BOKF's Audit team in all phases of the audit process.
Works independently with moderate guidance from Director, IA Data
Analytics on audits which vary in degree of complexity and require
a high order of analytical, interpretative, and/or constructive
thinking in varied situations.
- Planning - In collaboration with the assigned audit team,
identifies the audit objective of the analytic. Determines the
approach to achieve the objective. Identifies the data elements
required. Discusses approach with IT and line of business personnel
and identifies systems; data owners; data format and file
- Obtain & Validate Data - Develops and modifies existing scripts
and queries in ACL, or similar software, to access data as required
by audit plan. Retrieves and aggregates data into data sets on
which statistical/data analyses can be performed. Verifies
completeness and accuracy of data. Identifies any gaps in required
data. Identifies opportunities to make testing more efficient and
effective using CAATs.
- Documentation - Develops and maintains documentation of data
sources, scripts and queries.
- Post Audit Follow-up - Develops recommendations for changes to
data-related processes and systems that will mitigate risk, improve
performance and ensure the organization complies with all relevant
- Responsible for creating, maintaining, and continually
improving reports. This includes but is not limited to: a) Creating
simple and complex reports from database repositories, including
writing functional requirements and definitions b) Performing
simple and complex queries.
- Develops, executes and maintains data analytics framework as
part of the automated continuous audit program targeting fraud,
errors, and other risks. Conducts continuous audit protocols to
assess the need for audit teams to perform further testing, as
required. This position will provide technical, quantitative and
qualitative analysis, including benchmarking and industry best
practices studies, as well as the periodic review and tuning of
- In collaboration with assigned audit team(s), performs
comprehensive analyses and testing to identify errors and
irregularities on a targeted basis as a result of an audit finding,
special project, or review. Provides technical expertise on data
validation, data cleansing and analysis.
- Performs special projects as directed by management and
researches CAATs methodology to build upon knowledge base in order
to enhance capabilities for identifying trends and creating data
KNOWLEDGE, SKILLS and ABILITIES:
- Programming/scripting experience with strong background in
retrieving and analyzing data using data analytical tools,
specifically advanced SQL/Oracle, ACL, COGNOS, Excel, Data Sorting,
Data Mining PC and software skills;
- Strong understanding of database design and application;
- Fundamental understanding of relational databases, programming
concepts, and script structure;
- Ability to understand business risks, how to measure risk
exposure,and how to leverage data to identify and mitigate these
- Proven and determined problem solver with a high degree of
analytical and technical data skills;
- Core competency in performing root cause analysis;
- Strong ability to effectively communicate (verbally and in
writing) technical information to a variety of audiences with
varying degree of technical understanding;
- Ability to effectively plan time, method, manner and sequence
of own work assignments.
- Outstanding decision making, problem solving and organizational
- Demonstrated ability to detect patterns, trends and unusual
account activity by conducting extensive research while utilizing
various banks' and external sources.
This level of knowledge is normally acquired through a Bachelor's
degree in a related field of study (such as MIS/AIS, Data
Analytics, or Computer Science) and 3to 5years' experience
performing analytics or continuous auditing, risk/business
analysis, or other investigations.
BOK Financial is a stable and financially strong organization that
provides excellent training and development to support building the
long term careers of our employees. With passion, skill and
partnership you can make an impact on the success of the bank, our
customers and your own career!
Apply today and take the first step towards your next career
Please contact email@example.com with any
Keywords: BOK Financial, Tulsa , Internal Audit Data Analyst, Accounting, Auditing , Tulsa, Oklahoma
Didn't find what you're looking for? Search again!