Job Description

About the Role: The Audit Innovation Team has an opening for a Senior Lead Analytics Consultant. This role will be responsible for supporting audit work through advanced analytics. The candidate will develop expertise in navigating the extensive production and analytical data environments within Wells Fargo and apply that expertise to provide value-added data analysis solutions. We are looking for a candidate with the proven ability to utilize data analysis methodologies and tools to increase the efficiency and effectiveness of the audit process. This includes partnering with internal auditors to identify opportunities to utilize data analysis in evaluating the adequacy and effectiveness of internal controls on a continuous basis.

Responsibilities:

Facilitating the identification of opportunities to utilize data analysis in the assessment of risk and controls.
Navigating within large complex technology environments to locate, validate, extract, and format data for data analysis testing.
Effectively documenting the analysis in accordance with audit policy.
Training and mentoring audit teams in the use of data analysis and data analysis tools.
Partnering with assigned audit teams to build expertise in the use of data analysis within the internal audit function.

Essential Qualifications:

10 years of experience in one or a combination of the following: reporting, analytics, or modeling
Audit experience at a financial institution or accounting firm.
A BS/BA degree or higher.
Ability to obtain or currently hold one or more of the following certifications: CIA, CISA, CPA, CAMS, or CRCM.
Solid knowledge and understanding of audit methodologies and processes.
Excellent verbal, written, and interpersonal communication skills.
Strong organizational, multitasking, and prioritizing skills.
Ability to work effectively in a team environment and across all organizational levels, where flexibility, collaboration, and adaptability are important.
Ability to execute in a fast paced, high demand, environment while balancing multiple priorities.
Solid problem solving skills.
Good analytical skills with high attention to detail and accuracy.
Proficiency with other software and/or programming languages and tools (Python, Visual Basic, Oracle SQL, SQL Server Management Studio, Microsoft SQL Server, Teradata, SQL Server Reporting Service, etc.).
Advanced development of enhanced BI visualizations (Tableau, Qlikview, Power BI, Power Pivot).

DESIRED QUALIFICATION:

Extensive knowledge and understanding of research and analysis
Strong analytical skills with high attention to detail and accuracy
Outstanding problem solving and analytical skills with ability to turn findings into strategic imperatives
Ability to develop operational reporting and perform complex data analysis
Computer Science (B.A.) [Concentration in Financial Services Informatics, AI, Robotics, Data Science, Software, Systems]
Management Information Systems [Concentration in Management Information Systems; Business Intelligence and Analytics; Systems Analysis]
Degree in Economics, Mathematics and Statistics
Certifications in analytics space: SAS Certified Big Data Professional
SAS Certified Data Scientist
Certification of Professional Achievement in Data Sciences
Certified Analytics Professional
Data Mining and Applications Graduate Certificate (university specific)

Experience in data processing, database programming, and/or data analytics.
Python, SQL, SAS, or ACL programming experience including automation solutions of medium to high technical complexity.
Proficiency with other software and/or programming languages and tools (Python, Visual Basic, Oracle SQL, SQL Server Management Studio, Microsoft SQL Server, Teradata, SQL Server Reporting Service, etc.)
Advanced experience with data management including data modeling, data integrity and data quality
Advanced experience creating executive level dashboards, analytics, and reports using advanced visualization tools
Advanced experience gathering business requirements from various sources including end-users and stakeholders
Advanced business intelligence experience
Network Data Mover (NDM) experience
Experience in audit or risk functions covering risk identification, analysis, mitigation, and management
Knowledge of Wells Fargo businesses, systems of record, and data warehouses
Education: BA (Arts)
Industry: Financial Services/Stockbroking, Banking

Skills Required