Analytics Consultant

WELLS FARGO BANK
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
- A BS/BA degree or higher with 5-8+ years of experience in one or a combination of the following: reporting, analytics, or modeling.
- Strong experience in SAS, SQL, Python, R programming, Visual Basic, Oracle SQL, SQL Server Management Studio, Microsoft SQL Server, Teradata, SQL Server Reporting Service including automation solutions of medium to high technical complexity.
- Advanced development of enhanced BI visualizations (Tableau, Qlikview, Power BI and Power Pivot).
- Audit experience at a financial institution or accounting firm.
- 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.
Desired Qualifications:
- 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.
- 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.
To apply for this job please visit www.wellsfargojobs.com.
