Data Analyst - Internal Audit Services

At Valley Bank, we believe in people's growth potential. We invest in it. We protect it. We focus it. For nearly 100 years, we've been the Bank that clients from every industry turn to for our expertise, strategies, and advice--building the kind of trust that can fuel every goal. We are the leading relationship bank built for growth--with over $60 billion in assets, 3,800 experts, and more than 200 consumer branches and commercial banking offices in communities across the US.

At Valley, we're all driven by an ambition that goes deeper than just having a job. That's why when you work for us, we make it our goal to help you focus on what drives you--working to turn your passions and strengths into assets you can use to propel your ambitions and build the professional legacy you want. Because when we say we're a relationship bank built for growth, that's not just reserved for our clients--that includes all our associates as well.

The primary role of Data Analyst is to identify, design, and develop data analytics routines to support audit activities performed by the Internal Audit Team. The analyst creates repeatable data analytics to support continuous audit monitoring programs. The analyst also partners with audit team members and business clients to design and deliver data-driven solutions that advance their digital capabilities.

,

Responsibilities Include But Are Not Limited To

• 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.
  
  

,

Required Skills

• 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.
  
  

Required Experience

• 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).
  
  

Preferred Experience

• 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)