External Financial Reporting Sr. Consultant in San Francisco, California | DiversityInc Careers
This job has expired and you can't apply for it anymore. Start a new search.

External Financial Reporting Sr. Consultant

Job Description

At Wells Fargo, we want to satisfy our customers’ financial needs and help them succeed financially. We’re looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where you’ll feel valued and inspired to contribute your unique skills and experience.

Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you.

Enterprise Finance & Information Technology offers technology and services that exceed Wells Fargo customers’ expectations and directly enable them to succeed financially. We interact with customers more than 12 billion times a year through in-store, online, ATM, and telephone transactions. We impact customers directly, through systems availability and security, as well as indirectly, through our business partners who offer and deliver a myriad of products and services that meet customers’ financial needs. We provide a competitive advantage for the company through excellence in fundamentals, integrated partnerships, and our talented and engaged team members.

Regulatory & Basel Reporting is part of the Controller’s Division of Wells Fargo. The team is responsible for producing monthly /quarterly regulatory reports - Y-9C/Call Reports, FFIEC 009, Y14 M/Q, FFIEC 101 per Basel III and other disclosures per Basel. The team is also responsible for providing responses to regulatory inquiries, studies and surveys proposed by the agencies, ad-hoc analysis for Basel/Capital initiatives, and participates in regulatory and audit reviews impacting the regulatory reports.

The External Financial Reporting Senior Consultant position will support the Data Collection and Management Team in support of the Data Issues team which is responsible for managing the process used to identify data issues impacting regulatory reporting. In this role, the person would also be responsible in identifying critical data issues that could lead to errors in regulatory reporting.

The responsibilities may include the following:

  • Develop and implementing policies/procedures/controls to effectively manage the scope of the Data Issue Identification Framework;
  • Responsible for analyzing complex reporting data to identify and report data issues that could lead to reporting errors;
  • Understand the capital infrastructure tool OFSAA (Oracle Financial Services Analytical Applications Infrastructure - OFSAAI) and its data model and be able to extract information necessary for analytics;
  • Query/Extract, analyze, organize, and report data sets from multiple databases in order to support and validate Data Issues reporting while ensuring adherence to data management regulations and policies. Analyses may include but not limited to predictive modeling, regression/multivariate, financial, and/or comparative analysis;
  • Working with multiple stakeholders to identify data issues impacting Basel and Y14M/Q reports and the assignment of these data issues to work streams / data issue owners;
  • Partner with other data issue management teams across finance to ensure consistency with data issue prioritization and reporting ;
  • Understand root cause analysis performed for high priority issues and involve in critical Risk Acceptance decisions;
  • Develop quarterly work stream level reporting containing complete list of all opened / reopened data issues with severity assignment changes and closed issues;
  • Develop senior management reporting that includes a summary of all open data issues across work streams, target remediation dates for high priority issues and escalation of data issues requiring senior management attention;
  • Review and understand new regulatory reports/instructions to design analytics to support verification of data issues

Required Qualifications

  • 6+ years of experience in one or a combination of the following: finance, accounting, analytics and reporting; or a BS/BA degree or higher in Finance, Accounting, Statistics, Economics, Business and 4+ years of experience in one or a combination of the following: finance, accounting, analytics or reporting
  • 4+ years of consultative business analysis experience

Desired Qualifications

  • Advanced Microsoft Office (Word, Excel, Outlook, PowerPoint, Access, and Project) skills
  • Extensive knowledge and understanding of research and analysis
  • Strong analytical skills with high attention to detail and accuracy
  • 3+ years of risk and regulatory compliance experience
  • PL/SQL experience
  • 3+ years of SDLC (System Development Life Cycle) experience
  • Knowledge and understanding of accounting principles and policies
  • Hyperion Essbase experience
  • Knowledge and understanding of OBIEE (Oracle Business Intelligence Enterprise Edition)

Other Desired Qualifications
  • Working knowledge of Generally Accepted Accounting Principles (GAAP), Dodd-Frank, Act Stress Testing, and bank accounting/regulatory reporting requirements.
  • Detailed knowledge of one of the following regulatory reporting schedule
  • FFIEC 101 – Basel III
  • FR Y-9C /Call Reports
  • Y14 M/Q
  • FRY15
  • FFIEC 009
  • Ability to create and maintain basic VBA macros
  • Experience with bank management reporting
  • Foundational understanding of BCBS 239 Principles
  • Ability to work effectively in a global team environment and across all organizational levels, where flexibility, collaboration, and adaptability are important


All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act.

Relevant military experience is considered for veterans and transitioning service men and women.

Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.