Data Analytics Audit Manager

Location: Chicago, IL, US, Evansville, IN, US, Lake Elmo, MN, US

Employment Type: FULL_TIME

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.

Responsibilities

We are currently seeking a Data Analytics (DA) Audit Manager that will provide support on audit projects as assigned, by leveraging computer programing skills and automation technologies (e.g., SQL, Alteryx, UIPATH, Power BI, Azur, 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 Manager 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.

Salary Range

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

Key Accountabilities

Operational Audits & Sarbanes-Oxley Support:

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

Automation:

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

Key Competencies for Position

Execution Leadership

Establish Plans & Priorities:

• Demonstrates the ability to determine a course of action and establish a timeframe to complete individual objectives and team goals.

Problem Solving: 

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

Drive and Execution: 

• Self-motivated and takes initiative; proactively 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. 

Culture Leadership

Communication:

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

Collaboration:

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

Qualifications and Education Requirements

• Bachelor’s degree in a field requiring computer programming, or 5 years minimum experience in data extraction and transformation, with the ability to write in SQL & Python queries.
• Proficient in the use of data wrangling and visualization tools such as SQL, Python, UIPATH and Power BI.
• Experience working on multiple projects/assignments simultaneously under minimal supervision and completing assigned tasks accurately and on a timely basis.
• Must demonstrate strong attention to detail with excellent organization skills.
• Excellent communication skills (verbal and written)
• Auditing and bank sector experience is a plus. 

 Old National is proud to be an equal opportunity employer focused on fostering an inclusive workplace and committed to hiring a workforce comprised of diverse backgrounds, cultures and thinking styles. 

As such, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as a qualified individual with disability, sexual orientation, gender identity or any other characteristic protected by law. 

We do not accept resumes from external staffing agencies or independent recruiters for any of our openings unless we have an agreement signed by the Director of Talent Acquisition, to fill a specific position

Our culture is firmly rooted in our core values.

We are optimistic. We are collaborative. We are inclusive. We are agile. We are ethical. 

We are Old National Bank. Join our team!