Senior Internal Auditor - Audit Analytics

J  o  b    D  e  s  c  r  i  p  t  i  o  n

Job Information

Title:

Senior Internal Auditor - Audit Analytics

Market Range:

MR21

Approved Date:

7/28/2023 10:32:56 AM

FLSA:

Exempt

EEO Code:

PROFESSIONALS

Career Level:

P4

Career Level Description:

Professional Level 4

Job Code:

100989

Job Family:

Fiscal and Business Management

Sub Family:

Audit

Primary Purpose

Develops effective and sustainable data analytics to extract relevant data from disparate systems to summarize data in a useful and reportable format for County management;  Provides custom data and reports needed to identify potential issues within County programs and departments;  Understands data analytics standards and can create moderate to complex data analytics using computer assisted audit techniques (CAATs) on large and complex datasets;  Independently examine and analyze risk, internal controls, complex source record and reports, programmatic data, and financial information for accuracy, completeness, and conformance to guidelines, regulations, and best practices. 

•

Apply data analytics and computer assisted audit techniques (CAATs) such as Microsoft Power BI, Structured Query Language (SQL), and Audit Command Language (ACL) to meet Internal Audit objectives.  Execute repeatable data analytics processes to provide audit assurance and improve efficiency and effectiveness. 

1

30%

•

Collect, process, and analyze large data sets and translate the data from disparate systems into relevant information that assists the Internal Audit team in audits, reviews, and other internal audit projects.  Create reports in a format that is useful for County management in making decisions.

2

40%

•

Work with all departments to identify appropriate data sources and develop custom data views and reports to achieve audit objectives. 

3

20%

•

Support the audit team and County departments by identifying new strategies for report design, automated and continuous data analysis, and data extraction. 

4

10%

Position(s) may perform other duties in addition to the above as assigned by management.

*IMPORTANT* In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.

Career Level Dimensions

Career Level:

P4

Career Level Description:

Professional Level 4

•

Plans and manages execution of large projects that span a Division or multiple Work Groups OR works as an independent technical expert within a Medical or Scientific Discipline.

•

Works independently with minimal direction. Viewed as subject matter expert within discipline.

•

Provides measurable input into new processes, standards and/or operational plans that impact Division results.

•

Responsible for making moderate to significant improvements of processes, systems or standards to enhance performance of the Work Group.

•

Propose new ideas and creative solutions to existing problems and/or work areas.

•

Works to influence parties within and outside of the Work Group and Division regarding projects and procedures.  May have responsibility for communicating with external parties and senior leaders.

•

Typically responsible for providing guidance, coaching and training to other employees within Division or the Work Group.

•

May manage projects at this level, requiring responsibility for the delegation of work and the review of others' work products

•

Requires deep knowledge of discipline typically obtained through advanced education combined with extensive experience. Typically viewed as having a specialty within a discipline. May have broad knowledge of project management.

•

Within Medical or Scientific Disciplines, typically requires a doctoral degree and post-doctoral training.

Qualifications

•

Bachelor's degree in Accounting, Finance or a related technical field

•

Six years of experience in governmental auditing and analytics

•

Equivalent education and experience are accepted

•

Ability to design and develop complex Computer Assisted Audit Techniques (CAATs) using tools such as Audit Command Language, Microsoft Power BI, or other business intelligence tools

•

Ability to independently execute highly complex automated data retrieval and analyses tasks with large data sets and sources, including relational databases, flat files, and unstructured data

•

Ability to write scripts, develop SQL inquiries, and analyze data from disparate systems to summarize data in a useful and reportable format for County management

•

Advanced Microsoft Office (Excel, Access, Word, and PowerPoint) skills and use of data analysis tools and techniques to support audit recommendations

•

Knowledge of accounting concepts and the ability to apply this knowledge in developing County data analytics

•

Ability to interpret data and apply considerable knowledge of data analytics, CAATs, robotics, and data retrieval techniques, and convey results to enhance the effectiveness for all types of audits

•

Ability to work independently and manage multiple projects/engagements/responsibilities at the same time and ensure deliverables meet work plan specifications and deadlines

•

Ability to communicate complex issues in writing and verbally in a clear, concise, and organized manner that non-technical people may understand

•

Strong problem-solving, analytical, organizational and presentation skills

•

Ability to process and handle confidential matters with tact and discretion

An individual must be able to perform each essential duty satisfactorily to perform this job successfully. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Competencies

Adaptability & Flexibility

Changes behavioral style or method of approach when necessary to achieve a goal; adjusts style as appropriate to the needs of the situation. Responds to change with a positive attitude and a willingness to learn new ways to accomplish work activities and objectives.

Analysis

Examines data to grasp issues, draw conclusions, and solve problems.

Attention to Detail

Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently.

Mathematical Reasoning

Uses mathematical techniques to calculate data or solve practical problems.

Problem Solving

Builds a logical approach to address problems or opportunities or manage the situation at hand by drawing on one's knowledge and experience base, and calling on other references and resources as necessary.

Quality Assurance

Produces results or provides service that meets or exceeds organizational standards. May audit the work of others to ensure quality standards are met.

Fiscal Accountability

Follows fiscal guidelines, regulations, principles, and standards when committing fiscal resources or processing financial transactions. Understands the organization's financial processes.  Prepares, justifies, and administers the program or project budget. Oversees procurement and contracting to achieve desired results. Monitors expenditures and uses cost-benefit thinking to set priorities. 

Relationship Building

Builds constructive working relationships characterized by a high level of acceptance, cooperation, and mutual respect.

Technology Management

Keeps up-to-date on technological developments. Makes effective use of technology to achieve results. Ensures access to and security of technology systems.

Integrity

Act with honesty, transparency and respect in our interactions with co-workers and those we serve. Adhere, without exception, to laws, policies, procedures and professional standards.

Accountability

Establish high-quality standards for work. Add value. Measure results and hold self and others accountable for making progress toward desired outcomes. Take a logical and data-driven approach to decision-making.

Diversity

Believe that different backgrounds and experiences strengthen the organization and produce better results. Value inclusion across race, gender, age, religion, identity and experience, and strive to reflect in our workforce the diversity of our community.

Collaboration

Foster a work culture in which different ideas and opinions are encouraged and expected. Listen carefully and speak thoughtfully. Work together toward shared goals with mutual respect and cooperation.

Continuous Improvement

Continuously improve work processes and products. Provide a safe environment to be innovative and creative and try new things. When things don't go as planned, use it as an opportunity to learn, regroup and begin again. Provide time and resources for individuals to grow and develop both personally and professionally.

Wellness

Take proactive steps to be physically fit and healthy, emotionally strong, financially secure and socially fulfilled, while inspiring and empowering others to do the same.

Service Orientation

Commit to making a difference within the community. Actively engage in and enjoy our work. Deliver services that exceed expectations, with courtesy, politeness and sensitivity to the experiences, concerns and feelings of all co-workers and customers.

ADA Checklist

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Standard ADA Selection:

Office Environment

Standing

X

Walking

X

Sitting

X

Lifting/Carrying 0-10 pounds

X

Lifting/Carrying 10-20 pounds

X

Lifting/Carrying 20-50 pounds

X

Lifting/Carrying 50-100 pounds

X

Pushing

X

Pulling

X

Climbing

X

Balancing

X

Stooping

X

Kneeling

X

Crouching

X

Crawling

X

Reaching

X

Handling

X

Grasping

X

Fingering

X

Feeling

X

Talking

X

Hearing

X

Visual Perception

X

Repetitive Motions

X

Eye/Hand/Foot Coordination

X

Memorization/Concentration

X

Learning/Knowledge Retention

X

Preparing/Analyzing Numerical Figures

X

Use of Interfaced Commmunication Devices (Phone, Computer, Radio etc.)

X

Analyzing/Examining/Testing Data

X

Emotional/Behavioral Self-Regulation

X

Interacting with Others

X

Comprehension

X

Organization

X

Decision Making

X

Comprehension

Organization

Decision Making

Communication

Extreme cold

X

Extreme heat

X

Humid

X

Wet

X

Noise

X

Hazards

X

Temperature Change

X

Atmospheric Conditions

X

Vibration

X

Computers/Monitors

X