18 days old

Database Analyst 5 - Sr. Data Analyst

Charlotte, NC
  • Job Code
Job Description

At Wells Fargo, we have one goal: to satisfy our customers financial needs and help them achieve their dreams. Were looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where youll 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.

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.

Leads the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases. Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or

physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development. Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities. Leads complex projects.

Responsibilities include:

  • 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

Required Qualifications

  • 7+ years of database design and administration experience
  • 7+ years of data analysis experience

Desired Qualifications

  • Strong analytical skills with high attention to detail and accuracy
  • Excellent verbal, written, and interpersonal communication skills
  • 5+ years of data collection and reporting experience
  • Knowledge and understanding of SQL
  • Knowledge and understanding of data warehouse analysis
  • Knowledge and understanding of data: importing, exporting, and report generation
  • Knowledge and understanding of data modeling tools, such as Power Designer
  • Knowledge and understanding of automated data quality program execution
  • Knowledge and understanding of SOA (Services Oriented Architecture)
  • Good analytical skills with high attention to detail and accuracy
  • A BS/BA degree or higher
  • Strong time management skills and ability to meet deadlines
  • Financial industry experience

Other Desired Qualifications
  • Experience delivering in a multi-tiered data warehousing environment.
  • Experience in Financial Services (brokerage, investment preferable)
  • Familiarity with ETL solutions using tools such as Informatica (or equivalent)
  • Familiarity with Oracle and DB2
  • Familiarity with Unix
  • Demonstrated ability to interface with all organizational level
  • Ability to present technical information intra/inter-departmentally
  • Meeting and project facilitation skills
  • Demonstrated time management skills


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.



Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Database Analyst 5 - Sr. Data Analyst

Wells Fargo
Charlotte, NC

Share this job

Database Analyst 5 - Sr. Data Analyst

Wells Fargo
Charlotte, NC

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast