Senior Auditor or Audit Supervisor – Data Automation & Analytics Apply
OVERVIEW Position is posted as an Audit Supervisor position but is flexible to be filled at a junior level as a Senior Auditor. The Audit Supervisor – Data Automation and Analytics is an individual contributor role that conducts audit support functions by helping design various automation opportunities. Candidate will provide support to audit teams via a number of advanced automation tools to develop new testing methodologies that provide coverage for high risk areas. Support may be in the form of issue validation, point-in-time audits, dashboard development, or audit planning. Candidate will be given the opportunity to learn and make use of sophisticated tools (SQL, Alteryx, Informatica, SAS, Tableau, SSRS, DataRobot etc) and technologies (Big data like Hadoop, Python, AI/Data Science) to provide customized automated solutions across multiple business segments. Day-to-day activities will include data extraction from multiple sources, performing advanced data analytics, and building dashboards. Opportunity exists for candidate to expand into predictive modeling, NLP solutions, and advanced analytics to provide deeper insight into the audit objectives. RESPONSIBILITIES Independently develop automated testing solutions using a variety of technologies (SQL, Alteryx, SAS, Python, Tableau, etc.) Responsible for multiple projects simultaneously. Utilizes sound, seasoned analytical skills and possesses product, business, and technical expertise to execute assigned responsibilities. Coordinates, schedules, scopes, and leads data automation activities on audits (incl. large, cross-functional reviews). Leads data analysis of control deficiencies to drive actionable business impact, influences management on sufficiency of correctives actions, recommends audit rating. Implements risk-based audit strategy. Exercises judgment and critical thinking to influence business partners. Identifies control trends through data analysis in assigned business areas as well as assessing impact to the business and to the Bank overall by applying deep and broad business acumen. Coaches/trains team in execution of data automation activities to support the audit plan. Follow the lifecycle of our internal system for automation activities and ensure its data accuracy and completeness. Ensure timely delivery of automation activities as per the point-in-time audit and issue validation timelines. REQUIRED SKILLS AND EXPERIENCE Bachelor's degree OR 3 years minimum experience in data extraction with ability to write SQL queries. Skilled in the use of data wrangling and visualization tools such as Alteryx and Tableau. Understanding of Data Integration/ETL tools. Familiarity with DataRobot, Instabase, and UIPath are a plus. Proven experience coordinating 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) DESIRED SKILLS AND EXPERIENCE Advance SQL writing abilities Knowledge of how to connect to data sources and extract and analyze data Experience with Python is a plus AI/Data Science Experience Audit experience