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.
As a Senior Data Analyst you will be responsible for understanding and analyzing complex business & data requirements. Prepare detailed functional specifications that drive the overall design of the data environment. This includes developing a broad understanding of the upstream and downstream systems and processes, including impact and map & gap analysis of current databases and reporting systems. This person will perform data analysis using a variety of SQL tools to query major databases and provide technical assistance as subject matter expert in identifying, evaluating and developing data models and solutions that meet business requirements. It will review and advise data validation and testing approach, systems testing, and support data quality processes. Provide training, resolve questions, and give direction to less experienced staff and contractors. Provide support to the leadership team on achieving strategic and tactical goals. This is not a Data Administration position.
Understanding complex business processes and relationships to existing data. Working with business contacts, analysts and other subject matter experts to identify, understand and document business needs for data
Creating source-target mapping document and functional data specifications
Designing conceptual, logical and physical data models for highly complex data environments to support data integration efforts
Understanding upstream and downstream process, the impact of change to database and communicate, educate team members and partners
Working closely with the architecture community to provide strategic solutions, influencing long-range internal and enterprise-level data architecture and data management strategies.
Developing and creating data modeling patterns that support enterprise and line of business data strategy and data architecture vision
Reviewing data modeling artifacts of other team members to ensure compliance with standards, policies and procedures and data management best practices promoting proper data sharing, consistency and reuse
Providing data consulting services to application teams utilizing supported data environments
Providing expert-level consulting services in the identification and resolution of highly complex data challenges and issues
Serving as subject matter expert and steward for the architecture and content for assigned projects, systems and data
7+ years of database design and administration experience
A BS/BA degree or higher
5+ years of financial services industry experience
7+ years of data warehouse experience
4+ years of SOA (Services Oriented Architecture) experience
5+ years of UNIX experience
7+ years of experience with SAS or SQL, or other data management, reporting and query tools
7+ years of SQL experience
5+ years of experience with databases such as Oracle, DB2, SQL server, or Teradata
5 + years of experience supporting or designing complex ETL production environments
7+ years of experience with data analysis and documentation
5+ years of PL/SQL experience
Strong analytical skills with high attention to detail and accuracy
Excellent verbal, written, and interpersonal communication skills
Ability to interact with all levels of an organization
Knowledge and understanding of data modeling tools, such as Power Designer
Strong time management skills and ability to meet deadlines
Other Desired Qualifications
Ability to present technical information intra/inter-departmentally
Meeting and project facilitation skills
MO-Saint Louis: 1 N Jefferson Ave - Saint Louis, MO
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.
Internal Number: 5547828-1
About Wells Fargo
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