Audit Data Analyst

• Assists in identifying processes to be included in a continuous analytics program, based on risk assessment results, client requests, research, and previous audit or advisory projects
• Identifies, obtains, verifies, and cleans relevant data and ensures data appropriately populate related dashboards on a periodic and ongoing basis; coordinates this with Information Technology or other relevant business units as applicable
• Uses creativity and critical thinking to develop analytics dashboards, utilizing data mapping, mining, conversion, integration and statistical data analysis; coordinates with the client, OIA&IG management, IT, or Power BI support staff as applicable
• Prepare, clean, transform, and validate datasets within Snowflake using SQL to ensure accuracy, quality, and readiness for visualization tools such as Power BI or Tableau
• Generates accurate periodic reports and dashboards for OIA&IG or business units
• Interprets analytics to determine whether potential exceptions exist; follows-up on exceptions on a periodic and ongoing basis; and documents and communicates results in an organized and clear manner
• Coordinates with supervisors of projects to ensure all review notes are thoroughly addressed and deadlines are met
• Assists with maintaining and updating data analytics and data management procedures by helping manage data connections, supporting appropriate data security and availability tasks, and working with a supervisor to identify and resolve data issues
• Keeps abreast of analytical tools and methodologies used within OIA&IG, provides input on possible enhancements to current data analytics processes, and helps train other OIA&IG staff on data analytics tasks and related procedures

25% - Assists with data analytics for assurance and advisory projects according to the internal audit plan, or as assigned

• Assists the audit team in determining the types of data analytics that may be performed on various audit and consulting projects
• Identifies, obtains, verifies, and cleans relevant data, effectively communicating with clients as needed
• Uses creativity and critical thinking to develop analytics dashboards, utilizing data mapping, mining, conversion, integration and statistical data analysis; coordinates with OIA&IG management or Power BI support staff as applicable
• Interprets analytics to determine whether potential exceptions exist and communicates the results to the audit team
• Coordinates with managers of the projects to ensure deadlines are met and review notes are adequately addressed
• Assists in the preparation of the reports when requested

10% - Assists in the performance of audit procedures when requested

• Performs tests of controls, substantive testing, and/or research depending on the type of project, in accordance with The IIA Global Internal Audit Standards
• Interprets and evaluates internal controls, policies, and procedures
• Ensures that procedures and findings are documented with sufficient detail in working papers
• Communicates effectively with the client in writing and verbally during the project
• Coordinates with managers of the projects to ensure deadlines are met and review notes are adequately addressed
• Assists in the execution of Information Technology-related audits including reviewing and evaluating the adequacy and effectiveness of the company’s technology related controls

05% - Performs necessary administrative tasks required by the department

• Records time in AuditBoard on at least a weekly basis
• Prepares status reports for active projects
• Assists with coordination of quarterly Audit Committee meetings, including preparation of reports and taking notes
• Performs research over areas that are impactful to the State Board of Administration (SBA) or to the audit profession and shares knowledge with the department
• Completes mandatory training and other trainings

• A bachelor's degree from an accredited college or university in finance, accounting, statistics, business, computer science, management information systems, or a related field
• Masters of Business Administration or master’s degree in finance, accounting, statistics, business, computer science, management information systems, or a related field
• Possession of a Certified Internal Auditor (CIA), Certified Investments and Derivatives Auditor (CIDA), Certified Public Accountant (CPA), Certified Information Systems Auditor (CISA), Certified Information Security Manager (CISM), Certified Information Systems Security Professional (CISSP), Certified Fraud Examiner (CFE)
• Experience in public accounting or auditing, SQL or other programming languages, Snowflake, Power BI, Python and the financial services industry

Knowledge, Skills and Abilities:

• Knowledge of relevant audit industry standards, including The IIA Global Internal Audit Standards and Committee of Sponsoring Organizations (COSO) framework and related principles
• Knowledge of finance (i.e., investing), governance, risk and controls concepts
• Extensive data analytics skills, including the use of data analytics tools
• Extensive Microsoft Office skills (Excel, Word, Visio, Access and Project)
• Strong time management, organizational, and leadership skills
• Excellent written and verbal communication and presentation skills
• Strong attention to detail
• Ability to conduct research, compile data, and present results in an effective manner
• Ability to solve complex problems, primarily related to large data sets and related queries and calculations
• Ability to think critically and creatively
• Ability to work independently and exercise initiative, but also an effective team player
• Ability to manage multiple projects simultaneously and prioritize work assignments to meet deadlines

Hiring Range: $64,155 - $80,220

The State Board of Administration is an Equal Opportunity Employer

Successful completion of a pre-employment background check is a condition of employment with the State Board of Administration