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.
Wells Fargo Technology is a team of more than 40,000 information technology and security professionals who help keep Wells Fargo at the forefront of America's diversified financial services companies. Employees execute an engineering-led IT strategy to deliver stable, secure, scalable and innovative services that provide Wells Fargo global customers 'round-the-clock' banking access through in-store, online, ATM, and other channels. Wells Fargo Technology plays a critical role in the company's customer and employee experience, business and risk management transformation, and growth agenda.
This position will be part of the Enterprise Application Lifecycle Management (ALM) organization within Enterprise Application Portfolio Management under the CTO. The Enterprise Application Portfolio Management group ensures that processes are defined and matured, managing consistency across Technology according to strategic priorities and the Target Operating Model. The Enterprise ALM group is responsible for providing a common and consistent framework for the ALM discipline to increase efficiency, effectiveness and policy standards and controls adherence across the Wells Fargo enterprise.
The Senior ETL Analyst will drive and support the ongoing maturation of the ALM Target Operating Model and process improvement pipeline through data integration, data modeling and new ETL processes. This role is posted as a Senior ETL Analyst; however, the Wells Fargo job title is Technology Business Systems Senior Associate.
Key Responsibilities Include:
Create effective strategies to streamline and automate data collection and reporting; analyze information, identify trends/insights, and implement analytics solutions for application portfolio data
Create data models, data integration design, and ETL processes
Identify and drive initiatives to enhance data integration, data model, data architecture for risk metrics/data analytics, improve data quality, create compliance analytics and test data management
Identify operational, performance and risk metrics that measure process and controls effectiveness
Create reports and dashboards using Tableau and SSRS
Create executive level presentations, data insights and story boards
Selected candidate will be required to work within one of the following Wells Fargo locations: Charlotte, NC; Minneapolis, MN; Des Moines, IA; or Phoenix, AZ. Preference will be given to those candidates that either currently live in or are willing to relocate to one of these locations. Relocation assistance is not available for this position.
7+ years of experience in business systems analysis or design as demonstrated through work, military, or education
3+ years of ETL (Extract, Transform, Load) Programming experience
3+ years of data modeling experience
3+ years of experience with data manipulation, cleansing, and transformation
2+ years of Tableau experience
Deep knowledge and understanding of operation work flows/processes
Deep knowledge and understanding of governance and compliance expected from providing solutions in systems and technology domains
Ability to determine and report priorities/metrics to senior management
SQL Server Reporting Services (SSRS) experience
Experience in data architecture and strategy
Knowledge and understanding of application lifecycle, from design and development to testing, implementation and production support
Strong relationship management skills
Willingness to work on-site at stated location on the job opening
Ability to provide and work from a home office
NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC AZ-Chandler: 2700 S Price Rd - Chandler, AZ MN-Minneapolis: 255 2nd Ave S - Minneapolis, MN IA-Des Moines: 800 Walnut St - Des Moines, IA
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.
Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $1.9 trillion in assets. Wells Fargo’s vision is to satisfy our customers’ financial needs and help them succeed financially. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, investment and mortgage products and services, as well as consumer and commercial finance, through 7,400 locations, more than 13,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in 32 countries and territories to support customers who conduct business in the global economy. With approximately 260,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 29 on Fortune’s 2019 rankings of America’s largest corporations. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories.
www.wellsfargo.com | Twitter: @WellsFargo