Senior Analytical Consultant

The Audit Innovation and Analytics team has an opening for a Senior 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 by creating analytics and other innovation solutions in evaluating the adequacy and effectiveness of internal controls on a continuous basis.

About this role:

Wells Fargo is seeking a Senior Analytics Consultant.

In this role, you will:

• Consult, review and research moderately complex business, operational, and technical challenges that require an in-depth evaluation of variable data factors

• Perform moderately complex data analysis to support and drive strategic initiatives and business needs

• Develop a deep understanding of technical systems and business processes to extract data driven insights while identifying opportunities for engineering enhancements

• Lead or participate on large cross group projects

• Mentor less experienced staff

• Collaborate and consult with peers, colleagues, external contractors, and mid-level managers to resolve issues and achieve goals

• Leverage a solid understanding of compliance and risk management requirements for supported area

• 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.

Required Qualifications:

• 4+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

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

• Alteryx Core Designer/Advanced

• 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, Tableau, Alteryx, 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

• Experience in audit or risk functions covering risk identification, analysis, mitigation, and management

• Knowledge of Wells Fargo businesses, systems of record, and data warehouses

Job Expectations:

• Ability to travel up to 10% of the time.

• 8-10 years of experience in a combination of the two or more of the following: reporting, analytics, auditing, continuous controls monitoring, risk monitoring, 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).

• Alteryx, SAS, and similar other tools.