Apply on Employer Site

Randolph Brooks Federal Credit Union · 8 hours ago

Internal Audit Data Analyst

San Antonio, TX

Full-time

Onsite

Entry, Mid Level

2+ years exp

Randolph-Brooks Federal Credit Union is seeking an Internal Audit Data Analyst who will serve as the subject matter expert for the Audit Management Solution and computer assisted audit techniques. The role involves incorporating advanced data analytics into audit engagements, automating procedures, and enhancing internal controls to ensure compliance and improve risk management processes.

BankingFinancial Services

H1B Sponsor Likely

Responsibilities

Perform basic administration tasks for the AMS and maintain strong Excel skills, as well as foundational knowledge of other CAATs such as Datawatch, Power BI, Power Query, Python and/or Structured Query Language (SQL); identify and continuously implement opportunities to incorporate software into audit procedures to improve efficiencies and effectiveness

Utilize available resources to research, learn, and ultimately apply software features not previously utilized to maximize system functionality

Identify and continuously implement opportunities to incorporate software into audit procedures to improve efficiencies and effectiveness

Build basic scripts and data visuals, as well as display proficiency in Microsoft Excel including formulas, subtotals, data validation rules, text to columns, advanced pivot tables, and macros to create continuous auditing reports and automate recurring audit procedures to assist audit leadership in meeting the overall audit plan

Conduct data analytics engagements and internal audits in accordance with IIA Global Internal Audit Standards and established department procedures and guidelines

Review user access requests using least privilege principles and segregation of duties concepts

Train and assist staff auditors on utilizing data analytics to identify unusual relationships across entire population sets, select random samples, and understand existing scripts

Create detailed written user manuals as well as provide ongoing training and guidance to the department and business units surrounding audit systems

Synthesize complex or diverse information and use intuition and experience to complement data as well as regularly exercise advanced judgment and critical thinking including making informed decisions through independent verification

Apply intellectual abilities necessary to probe for answers in an effort to solve problems, develop effective audit procedures, as well as absorb and apply new information to assigned tasks with limited supervisory assistance

Display conflict resolution and negotiation skills through appropriate persuasion and genuine empathy

All other duties as assigned (note: essential functions and responsibilities may change or new ones may be assigned at any time with or without notice)

Qualification

Data analyticsPythonStructured Query Language (SQL)Power BIMicrosoft ExcelAudit Management Solution (AMS)Training skillsConflict resolutionCritical thinkingCommunication skills

Required

Minimum of 2 years experience in public accounting, internal audit, accounting, financial analyst, technology, or similar role

Data analytics skills to utilize CAATs such as, Datawatch, Power BI, Python, Power Automate, Power Apps, Power Query, or Structured Query Language (SQL) to select samples, analyze information, or obtain data directly through a database connection

Proficiency in utilizing Microsoft Office products and Adobe Professional; including ability to research, learn, and apply features not previously utilized

Demonstrate the ability to utilize more complex Microsoft Excel features, such as, complex formulas and advanced pivot tables

Preferred

Bachelor's Degree (Accounting, Finance, Technology preferred)

The Google Data Analytics (GDA), CompTIA Data+, Microsoft Certified Azure Data Scientist Associate (MCDAA), Certified Information Systems Auditor (CISA), Certified Information Systems Security Professional (CISSP), Certified Data Privacy Solution Engineer (CDPSC), or equivalent certification is required within six months in this role

Company

Randolph Brooks Federal Credit Union

Glassdoor3.9

Randolph-Brooks Federal Credit Union is focused on helping members save time, save money and earn money.

Founded in 1952

Austin, Texas, USA

1001-5000 employees

https://www.rbfcu.org/

H1B Sponsorship

Randolph Brooks Federal Credit Union has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2024 (1)

2021 (1)