Valley Bank is looking to enhance its internal audit activities by leveraging data analytics to identify, design, and develop data analytic routines for continuous audit monitoring and automation of audit testing.
Requirements
- Strong quantitative, analytical, data-intuition, and problem-solving skills, and proficiency in data analytics techniques.
- Strong 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.
- Advanced aptitude in data analytics.
- Knowledge of latest trends in data analytics.
- Strong knowledge of internal controls and auditing techniques.
- Strong knowledge of general IT Controls.
- Strong PC skills (Excel and Word).
Responsibilities
- Work with Audit Managers and Audit Seniors 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.
- Interact with management and business partners to identify appropriate data sources and data elements required for analytics, applying professional skepticism when assessing data sources and validating the completeness and accuracy of data received.
- Work with the Audit Staff to encourage the use of data analytics.
- Support requests from external auditors related to data extracts for customer confirmations, completeness and accuracy assertions of financial reports, etc.
- 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.
Other
- Strong knowledge of business units, Valley and applicable industries, i.e. Banking.
- Strong communication and interpersonal skills - includes ability to interact with peers and clients with ease and to participate as part of the team. Effective in a variety of presentation settings such as face-to-face and in small groups with peers and In-charge
- Ability to train less experienced staff.
- Performance management skills - includes ability to provide timely and valuable feedback to team members (interns/data analysts)
- Bachelor's degree in Business Analytics or closely related field of study and minimum 2 years of relevant data analytics experience in Audit, Finance, Risk Management or Technology functions OR Master's degree in Business Analytics or closely related field of study and minimum of 1 year of relevant data analytics experience in Audit, Finance, Risk Management or Technology functions.
