13 days old

Database Analyst 4 - Enterprise Data & Analytics

West Des Moines, IA
  • Job Code
    5343029-2
Job Description

This position is within our Enterprise Data & Analytics/Credit Risk Management Data Quality and Metrics team and provides support of critical data quality initiatives that support a data mart, which is used by the Credit Risk Management business unit for CAR, CCAR (Comprehensive Capital Analysis Review) and BASEL regulatory reporting, as well as other business critical reporting needs.

This position will play a senior role ensuring proper implementation of data quality during the creation and modification of data, according to data quality standards, guidelines, metrics and quality-expectations. Defines rules to evaluate data quality and creates effective test plans. Ensures accuracy, completeness, integrity, consistency, uniqueness and timeliness of data. Executes Data Quality and Metrics team tests/assessments and data cleansing activities. Serves as a liaison between the business and internal clients.

Key Responsibilities Include:

  • Reviews data loaded into the data mart for accuracy
  • Recommends maintenance enhancements and data quality metric requirements for data processes to improve the accuracy of the data mart data
  • Reviews referential integrity and historical integrity of data mart data
  • Assist in determining root cause of data quality issues and recommending short term and long term solutions
  • Perform in depth testing and validation of key data quality issues identified by business partners and other users of the data mart
  • Investigate, troubleshoot and document source-to-target and other data issues from internal and external customers
  • Resolves data quality problems
  • Actively communicate data quality issues with multiple internal and external customers
  • Performs complex server- testing activities across various platforms and environments including one or more of the following:

  • Business requirement identification and analysis.
  • Perform and create SQL queries to identify data issues.
  • Data mapping analysis.
  • Moderate to complex SQL query creation and testing.
  • Analyze, query and manipulate data according to defined business rules and procedures
  • Evaluate large datasets for quality and accuracy
  • Work with programmers to correct data quality errors
  • Determine root cause for data quality errors and make recommendations for long-term solutions
  • Research and determine scope and complexity of issue so as to identify steps to fix issue
  • Analyzing data quality metrics and assisting with data quality dashboard output and review.
  • Ensure adherence to data quality standards
  • Identify areas of improvement
  • Planning, testing, and execution of SQL queries associated with key data issues found by customers.

  • Leads mentors and/or provides guidance to less experienced database analysts, including guidance for troubleshooting escalated issues.
  • Participate in the development of data/database architectures and management policies, procedures and standards.
  • May lead moderately complex projects.

Divisional Information

Enterprise Data & Analytics (EDA), which offers Chief Data Office capabilities to Wells Fargo, focuses on leveraging data as a strategic asset. Data is critical to Wells Fargos continued success, deepening relationships with our customers, creating a seamless and convenient multi-channel experience, and meeting our commitment to satisfy our customers financial needs. EDA defines how we use information across the company, align our business practices and support our continued focus on great customer experience

Who We Are:



Required Qualifications

  • 5+ years of database design and administration experience
  • 2+ years of data warehouse experience
  • 5+ years of ETL (Extract, Transform, Load) Programming experience
  • 5+ years of MS SQL server experience
  • 5 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning



Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills
  • 3+ years of financial services industry experience
  • Knowledge and understanding of Agile
  • Knowledge and understanding of credit risk management
  • Knowledge and understanding of database troubleshooting
  • Knowledge and understanding of SQL Server Reporting Services (SSRS)
  • 1+ year of experience with SAS or SQL, or other data management, reporting and query tools
  • 5+ years of SQL Server Integration Services (SSIS) experience



Other Desired Qualifications
  • Experience with Visual Basic script and SSIS expressions.
  • Strong working knowledge and ability to use SAS, Excel, Microsoft office products and other tools to support report generation and on-going maintenance.
  • Knowledge of Ab Initio, ETL and Data Quality tools
  • Knowledge of QA practices and Data Quality process improvements




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.

Advertisement

Categories

  • Financial Services
  • Legal
  • Transportation / Warehouse

Featured Jobs

Career News

Share this job:

Database Analyst 4 - Enterprise Data & Analytics

Wells Fargo
West Des Moines, IA

Share this job

Database Analyst 4 - Enterprise Data & Analytics

Wells Fargo
West Des Moines, IA
US

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