Job Description and Requirements
The Internal Audit Data Analyst will serve as the subject matter expert for the Audit Management Solution (AMS) as well as computer assisted audit techniques (CAATs). The Analyst will incorporate advanced data analytics procedures into audit engagements to automate recurring procedures and identify unusual relationships across large data sets, recommend automated enhancements to internal controls to ensure credit union compliance with all applicable rules and guidelines as well as improve the effectiveness and efficiency of risk management, control, and governance processes. In addition, the Internal Audit Data Analyst will perform duties in a manner which enhances the image and promotes the growth of the Credit Union and department.
Essential Functions and 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).
Requirements:
- Bachelor's Degree (Accounting, Finance, Technology preferred)
- 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.
- 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
All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status, or other legally protected status.