Audit Reporting and Data Analytics Specialist
DTCC
Are you ready to make an impact at DTCC?
Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We're committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.
The Internal Audit Department's (IAD) mission is to deliver independent assessments of the organization’s overall control environment and to promote proactive risk identification and mitigation.
Pay and Benefits:
- Competitive compensation, including base pay and annual incentive.
- Comprehensive health and life insurance and well-being benefits, based on location.
- Pension / Retirement benefits
- Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
- DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).
The Impact you will have in this role:
The Internal Audit Department's (IAD) mission is to deliver independent assessments of the organization’s overall control environment and to promote proactive risk identification and mitigation.
Your Primary Responsibilities:
- Develop and execute processes within the team including, but not limited to, the Data Analytics and Continuous Monitoring Programs
- Assist the team in executing on a multi-year strategy to elevate the use of data and analytics within the Internal Audit function
- Use data analysis methods and technologies to automate audit testing and develop techniques for continuous auditing and analyzing large volumes of data
- 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 and conclusions regarding enterprise risks and controls
- Build queries and tools to increase efficiencies and to support Internal Audit processes/decisions
- Build and maintain analytical tools and applications used to collect, process, and present data across the department for use in audit testing
- Develop routine data validation checks to increase accuracy and integrity of output produced
- Collaborate with stakeholders to review and validate business requirements and keep them apprised of progress at regular intervals
- Design and execute data extract routines to support selected audits within the annual audit plan
- Create and maintain documentation of all work products
- Adhere to the team’s project and release management standards and provide effective challenge to facilitate continuous improvement
Qualifications:
- Minimum of 4 years of related experience
- Bachelor's degree preferred or equivalent experience
Talents Needed for Success:
- Related experience with databases/reporting, ETL, data analysis, reporting automation and visualization tools (e.g. SQL, Snowflake, Databricks, Microsoft Power Platform, Tableau, Power BI, Microsoft Fabric)
- Experience in data cleansing and for analysis (e.g. Talend, KNIME, Alteryx, Informatica, SIGMA Computing)
- Strong knowledge of working with and manipulating data types (e.g. structured, unstructured, hierarchical) from various sources (e.g. relational databases, system logs, SharePoint) to produce meaningful analyses
- Solid understanding of data science and machine learning principles and technologies (e.g. Python, R, KNIME) along with real world applications is a added advantage.
- Strong analytical and problem-solving skills
- Experience in Internal Audit, first or second line risk functions, financial services, and/or Big 4 Accounting is a plus
- Ability to identify, prioritize and manage your book of work, and keep collaborators continuously advised on progress and roadblocks along the way
Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
The role's primary responsibilities align with Internal Audit's STRIDE function that supports technology, reporting, innovation and data enablement. STRIDE has the broad objective of identifying, developing, and managing the use of technology to provide solutions to enhance the efficiency and effectiveness of audit assurance activities.