Senior ETL Analyst

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

Benefits
 

Visit https://www.wellsfargo.com/about/careers/benefits for benefits information.