Internal Audit Data Analyst
Company: BOK Financial
Posted on: January 17, 2020
Req ID: 53290
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
- 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 reports.
- 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 3 to 5 years 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
BOK Financial is an equal opportunity employer. We are committed to
providing equal employment opportunities for training,
compensation, transfer, promotion and other aspects of employment
for all qualified applicants and employees without regard to sex,
race, color, religion, national origin, age, disability, sexual
orientation, genetic information or veteran status.
Attention All Third Party Agencies, Headhunters, and Recruiters
BOK Financial and its Subsidiaries will not accept candidate
submission by unsolicited third parties through this site or any
company email address. All unsolicited candidates presented to BOK
Financial and its Subsidiaries will be considered the property of
BOK Financial. BOK Financial and its Subsidiaries will not be
responsible for any fees associated with unsolicited candidates,
nor will a contractual relationship be formed by the submission.
BOK Financial and its Subsidiaries are not obligated and will not
under any circumstances pay any fees to said third parties
submitting candidates in this manner. BOK Financial and its
Subsidiaries only forms contracts with recruiters with whom we have
an established business relationship and with whom we have in place
a signed agreement. All contact with BOK Financial and its
Subsidiaries from third parties must be through our Human Resources
Department. Any contact made outside of the BOK Financial Human
Resources Department by a third party will cancel any future
business relationships between the third party and BOK
Please contact firstname.lastname@example.org with any questions.
Keywords: BOK Financial, Tulsa , Internal Audit Data Analyst, Professions , Tulsa, Oklahoma
Didn't find what you're looking for? Search again!