Internal Audit Analytics Senior Specialist

Your opportunity

The Internal Audit Department (IAD) of The Charles Schwab Corporation provides independent and objective assessments to determine whether all significant risks are identified and appropriately reported by management and risk functions to the Board and Executive Management, to evaluate whether risks are adequately controlled, and to challenge Executive Management to improve the effectiveness of governance processes, risk management, and internal controls.

The Data Analytics team within Internal Audit’s Professional Practices Group (PPG) is seeking a Data Analytics Senior Specialist. The Data Analytics team is responsible for performing diverse analyses to gain additional insights into the business and to support increased levels of assurance in its support of internal audits, issue validation, and supervisory finding validation. Duties include working on advanced data analytics projects that gather and integrate large volumes of data, performs analysis, interprets results, develops actionable insights, and recommendations .

Reporting to the Senior Manager of Data Analytics, the Data Analytics Senior Specialist is responsible for supporting the independent and objective assurance activity designed to improve the firm’s operations by evaluating and improving the effectiveness of risk management, control, and governance processes, through the use of data analytics. This position is also responsible for liaising with the firm’s risk management functions, and data owners across technology and various lines of business.

What you’ll do:

• Support day-to-day audit data analytics projects including:
• Participate in the planning and execution of internal audit assignments, ensuring work is performed is risk-based and in accordance with IAD policies and procedures. Responsibilities include performing research to understand the business and the key systems and data used to support the business, participating in audit meetings and scoping discussions to identify key risks and controls and the most effective testing approach; designing and executing testing using appropriate analytics tools and techniques; documenting procedures performed with adequate detail to support re-performance; and drafting conclusions with appropriate rationale supported by evidence.
• Identify, design, and develop data analytics routines to support internal audits, issue validation, and supervisory finding validation.
• Manage data extraction, storage, transformation, and processing through data analytics routines, and generate output for analysis and discussion with the audit team.
• Use data analysis tools to automate audit testing and develop techniques for analyzing large volumes of data.
• Coordinate with data owners across the organization to identify appropriate data sources and data elements required for analytics, perform procedures to validate the completeness and accuracy of data.
• Collaborate with enterprise audit team members to identify opportunities to use data analytics to support data profiling to better understand distribution and determine analytics strategies.
• Build knowledge base and expertise in chosen functional area.
• Coordinate with audit team members to appropriately scope and execute data analytics focused on the most meaningful and relevant risks.
• Be aware of changes in the business that may affect the risk environment and, therefore, require possible changes to the audit plan or to the scope of planned audits, and associated analytics.
• Provide proactive consultation in identifying risk exposures and in evaluating solutions for internal control weaknesses and regulatory compliance issues, through the use of analytics.
• Maintain business relationships with peers across the organization ensuring Internal Audit is aware of key changes to business activities and objectives for appropriate response.
• Champion and promote the use of data analytics techniques to internal audit teams to evaluate large data sets for trends and anomalies within internal audit assurance and support activities.

What you have

• 3-5+ years of experience in performing the following tasks with increasing responsibility:
  • ETL (data extraction, transformation, loading),
  • Data analysis,
  • Reporting automation, and
  • Delivering visualization tools.
• Financial services and/or Big 4 Accounting experience a plus
• Comprehensive knowledge and experience performing data analytics of the following areas:
  • Data analytics and management technologies (Tableau, Alteryx, SAS, Python, R, Informatica, Power BI, etc.)
  • Database management systems (SQL, Oracle, Big Query, etc.).
  • Robotics process automation tools (Ui Path, Blue Prism, Automation Anywhere, etc.)
  • Knowledge of statistics and experience using statistical packages for analyzing large datasets
  • Queries, report writing and presenting findings
• CISA preferred. Other applicable certifications will be considered.
• Current knowledge of industry, regulatory issues and best practices; willingness to impart this knowledge to the team.
• Excellent analytical skills, with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Strong verbal and written communication skills with a demonstrated ability to articulate effectively and professionally.
• Strong time management skills and the ability to juggle and prioritize multiple assignments.
• Adaptable to change in a rapidly changing environment.
• Bachelor’s degree required.
• Ability to travel 5-10%