Job Description
Important Note: During the application process, ensure your contact information (email and phone number) is up to date and upload your current resume when submitting your application for consideration. To participate in some selection activities you will need to respond to an invitation. The invitation can be sent by both email and text message. In order to receive text message invitations, your profile must include a mobile phone number designated as 'Personal Cell' or 'Cellular' in the contact information of your application. 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. Wholesale Banking provides financial solutions to businesses across the United States and globally. Our four major business lines include Corporate & Investment Banking, Commercial Banking, Commercial Real Estate, and Wells Fargo Commercial Capital. We also have groups in credit risk, group risk, finance, marketing, human relations, and the Wholesale Chief Operating Office that support our businesses. The AC5 will be responsible for data analytics processes and results for Wholesale Financial Crimes Risk and Compliance. This position will be a contributor on the team with the following responsibilities: Write / code SQL (Oracle, SQL , Teradata) and use advanced MS Excel capabilities to identify customer populations and key data elements in support of data enrichment and document remediation efforts in a highly complex environment
Define and build data repositories to support long-term analytics needs and centralize commonly referenced data, leveraging prior database development background (in SQL, Oracle, or Teradata)
Identify data sources and data gaps, perform data compares by writing / coding SQL (Oracle, SQL , Teradata), import temporary datasets, and use advanced MS Excel capabilities
Perform analytics required to support various projects or information requests
Identify requirement for and work with teams to build reports to support ongoing information needs relative to WFCRC processes and controls
Write / code SQL (Oracle, SQL , Teradata) and use advanced excel capabilities to define and execute queries or logic to retrieve data from various sources within and possibly outside of Wells Fargo
Analyze data and create summaries in MS Excel, MS Word, MS Visio or PowerPoint for management review and communication Team members support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit's risk appetite and all risk and compliance program requirements. As a Team Member Manager, you are expected to achieve success by leading yourself, your team, and the business. Specifically you will:
Lead your team with integrity and create an environment where your team members feel included, valued, and supported to do work that energizes them.
Accomplish management responsibilities which include sourcing and hiring talented team members, providing ongoing coaching and feedback, recognizing and developing team members, identifying and managing risks, and completing daily management tasks.
Required Qualifications
- 8+ years of experience in one or a combination of the following: reporting, analytics, or modeling; or a Masters degree or higher in a quantitative field such as applied math, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis and 5+ years of experience in one or a combination of the following: reporting, analytics, or modeling
- 3+ years of SQL experience
Desired Qualifications
- Extensive knowledge and understanding of research and analysis
- Strong analytical skills with high attention to detail and accuracy
- Excellent verbal, written, and interpersonal communication skills
- SQL Server Reporting Services (SSRS) experience
- SQL Server Integration Services (SSIS) experience
- Knowledge and understanding of database querying and creating ad hoc reporting results using TSQL or similar querying methods
- Teradata experience
- Knowledge and understanding of database analysis and development
- Knowledge and understanding of database querying and creating ad hoc reporting results using SQL or similar querying methods
- Financial crimes experience
- Wholesale banking experience
- Audit or internal controls testing experience
- A BS/BA degree or higher
- Experience using business knowledge and critical thinking
- Risk and regulatory compliance experience
- Ability to proactively manage and mitigate issues
- Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
- Ability to exercise independent judgment and creative problem solving techniques
- Ability to summarize and recommend new strategies/solutions
- Ability to articulate complex concepts in a clear manner
Job Expectations
- Ability to travel up to 25% of the time
Street Address
MN-Minneapolis: 600 S 4th St - Minneapolis, MN
AZ-PHX-Central Phoenix: 100 W Washington St - Phoenix, AZ
GA-Atlanta: 1100 Abernathy Road - Atlanta, GA
CO-Denver: 1700 Lincoln St - Denver, CO
NC-Charlotte: 8505 Ibm Drive - Charlotte, NC
TX-DAL-Downtown Dallas: 1445 Ross Ave - Dallas, TX
Disclaimer
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.
|
