Audit Reporting and Analytics Analyst

About this Opportunity n

The role's primary responsibilities align with Internal Audit's Data Analytics and Continuous Monitoring Program which has the broad objective of developing and managing the use of technology and tools to provide automated solutions to enhance the efficiency and effectiveness of the audit execution, while building broad functional knowledge of DTCC processes and related risks and controls.

n

Your Responsibilities:

n

n- Develop and execute processes within the Audit Reporting and Automation (ARA) function including, but not limited to, the Data Analytics and Continuous Monitoring Programs and assisting with the management of tickets for IAD tooling support n- Assist the team in executing on a multi-year strategy to elevate the use of data and analytics within the Internal Audit function n- Use data analysis methods and technologies to automate audit testing and develop techniques for continuous auditing and analyzing large volumes of data n- Retrieve, manipulate and analyze structured and unstructured data from a variety of sources that can then be transformed into relevant business information used to support audit testing and conclusions regarding enterprise risks and controls n- Build queries and tools to increase efficiencies and to support Internal Audit processes/decisions n- Build and maintain analytical tools and applications used to collect, process, and present data across the department for use in audit testing n- Develop routine data validation checks to increase accuracy and integrity of data and output produced n- Collaborate with stakeholders to review and validate business requirements; develop and execute on plans to implement requirements while keeping stakeholders apprised of progress at regular intervals n- Design and execute data extract routines to support selected audits within the annual audit plan n- Create and maintain documentation of all work products n- Adhere to the team’s project and release management standards and provide effective challenge to facilitate continuous improvement n

n

Talents Needed For Success:

n

n- Minimum of 1 year related experience with databases/reporting, ETL, data analysis, reporting automation and visualization tools (e.g. SQL, Microsoft Power BI, Tableau) n- Experience in data cleansing and preparation methods and technologies for analysis (e.g. Talend, Alteryx, Informatica) n- Strong knowledge of working with and manipulating a variety of data types (e.g. structured, unstructured, hierarchical) from a variety of sources (e.g. relational databases, system logs, SharePoint) to produce meaningful analyses n- Ability to communicate findings from data to non-technical individuals n- Working knowledge of data science and machine learning principles and technologies (e.g. Python, R, KNIME) along with real world applications is a plus n- Experience in Internal Audit, first or second line risk functions, financial services, and/or Big 4 Accounting is a plus n- Ability to identify, prioritize and manage your book of work, and keep stakeholders continuously informed on progress and roadblocks along the way n