Data Analyst - Internal Audit Services

Valley Bank•Morristown, NJ

15h

About The Position

This role involves working with the Internal Audit Services team to leverage data analytics for audit assignments. The Data Analyst will be responsible for identifying, designing, and developing data extraction routines, managing data processes, and automating audit testing. A key aspect of the role is maintaining and enhancing PowerBI dashboards, developing advanced data analytics tools, and exploring the use of Artificial Intelligence (AI) within Internal Audit. The position also supports external auditor requests and involves performing control tests, analyzing evidence, and documenting workpapers. The goal is to enhance the control environment for audit clients and streamline reporting through technical configurations and data analysis.

Requirements

Solid knowledge and proficiency in extraction and analysis of data from financial systems, leveraging data analysis tools (Excel, Access, Power BI and/or Microsoft SQL) and developing and running scripts.
Strong Aptitude in data analytics.
Strong communication and relationship building skills.
Demonstrates reliability and dependability.
Awareness of the latest trends in data analytics.
Knowledge and experience in the banking industry and banking systems.
Have a desire to generate ideas for the use of data analytics and encourage others to achieve their audit objectives.
Working knowledge of internal controls and auditing techniques.
Knowledge of general IT Controls.
Demonstrates appropriate and effective business writing, e.g. e-mail.
Bachelor's degree in business, mathematics, computer science, or management information systems.
Minimum of 3 years of relevant/recent data analytics experience in audit, financial, risk management or technology functions.
Strong PC Skills (Excel and Word).

Nice To Haves

Experience building and supporting continuous audit monitoring programs within Internal Audit.
Certified Internal Auditor (CIA), Certified Information Systems Auditor (CISA), or Certified Fraud Examiner (CFE)

Responsibilities

Work with Audit team members to identify, design, and develop data analytics extract routines to support audit assignments.
Manage data extraction, storage, transformation, and processing through data analytics, and generate output for visualization/analysis by the Internal Audit Team.
Use data analysis tools to automate audit testing and develop techniques for continuous auditing and analyzing large volumes of data.
Maintain, enhance, and develop new PowerBI dashboards to support internal audit operations and reporting.
Develop advanced data analytics tools for audit clients to enhance their control environment.
Perform audit software technical configurations that enable streamlined reporting.
Prepare metrics and visualizations for various management reporting.
Help expand the use of Artificial Intelligence (AI) in Internal Audit.
Support requests from external auditors related to data extracts for customer confirmations, completeness and accuracy assertions of financial reports, etc.
Periodically perform audit tests of controls by obtaining and analyzing audit evidence, preparing audit workpapers, evaluating test results, and drawing conclusions on the adequacy and effectiveness of controls.