Data Analytics Audit Supervisor

Overview

Old National Bank has been serving clients and communities since 1834. With over $70 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. As a trusted partner, we thrive on helping our clients achieve their goals and dreams, and we are committed to social responsibility and investing in our communities through volunteering and charitable giving.

We continually seek highly motivated and talented individuals as our people are critical to our success. In return, we offer competitive compensation with our salary and incentive program, in addition to medical, dental, and vision insurance. 401K, continuing education opportunities and an employee assistance program are also included in our benefit suite. Old National also offers a variety of Impact Network Groups led by team members who are passionate about driving engagement, creating awareness of diverse backgrounds and experiences, and building inclusion across the organization.

We offer a unique opportunity to join a growing, community and client-focused company that is firmly rooted in its core values.

We are currently seeking a Data Analytics (DA) Audit Supervisor that will provide support on audit projects as assigned, by leveraging computer programming skills and automation technologies (e.g., SQL, Alteryx, UIPATH, Power BI, Azure, Python/R Programming, Data Science techniques). The candidate will develop new testing methodologies that expand audit testing coverage and/or produce continuous auditing scripts. The DA Audit Supervisor will support risk identification, data acquisition, controls testing, dashboard development and other ad hoc assignments.

The candidate will provide customized automated solutions that support Sarbanes-Oxley (SOX) testing, operational audits and assigned administrative tasks. Day-to-day activities will include data extraction from multiple sources, business data transformation, dashboards development, and meetings with audit and non-audit stakeholders.

The salary range for this position is $60,000 - $121,300 per year. Final salary will be determined based on factors such as location, experience, skills and qualifications.

• Leverage existing enterprise infrastructure & tools for data storage and computer programming to extract, cleanse, transform, and report on business transactions, in support of audit objectives.
• Develop & document quantitative results to support the execution of audit test plans.
• Develop trend analysis and other anomalies detection deliverables to support audit planning.
• Assist in the digitalization of SOX data acquisition and SOX controls testing.
• Create Power BI dashboards as required by audit team members or management.

• With limited supervision, develop automated audit solutions using a variety of technologies (e.g., SQL, UIPATH, Alteryx, Python, Power BI)
• Ensure timely delivery of automation tasks and execution of continuous auditing scripts.
• Coordinate, schedule, and lead requirements gathering sessions and data source discussions with audit team members and external technology stakeholders.
• Get involved in various enterprise users group sessions on automation or data analytics.
• Coordinate and help assist in the development of DA training material.

• Establish Plans & Priorities:
  Demonstrates the ability to determine a course of action and establish a timeframe to complete individual objectives and team goals.

• Seeks to identify the root cause of the issue by consulting with lines of business and subject matter experts. Demonstrates strong analytical and technical skills while working towards the ability to manage complex tasks.

• Self-motivated and takes initiative; pro actively learns new skills and develops self for current performance and future growth; demonstrates a desire to learn and actively seeks ways to improve current methods, systems, processes, and procedures.

• Develop effective communication skills with the ability to clearly articulate and convey information and ideas at all levels of the organization.
• Develop an understanding of who will be affected by an issue or change and ensure all stakeholders are kept informed.

• Learn to actively seek, develop, and maintain trusted relationships with others in the department and external to the department to achieve corporate business goals and objectives.
• Develop the ability to find effective solutions by engaging in different ideas, perspectives, and line of business expertise when analyzing a situation or developing a solution.
• Learn to share knowledge, information, ideas, and suggestions to accomplish mutual goals within the department and those external to the department.

• Bachelor’s degree in a field requiring computer programming, or 5 years minimum…