Wells Fargo

Job Category:



Winston Salem, California


United States

Approximate Salary:

Not Specified

Position Type:

Full Time


415) 820-7800

This job has expired and you can't apply for it anymore. Start a new search.

Data Modeler (Analytic Consultant 4)

Wells Fargo - Winston Salem, California

Posted: 07/5/2018

Job Description

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.

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.

IT for IT Authorized Provisioning Point (APP) Application team is seeking a Data Modeler . IT for IT Authorized Provisioning Point (APP) Application team is responsible for driving the design and development of the new IT for IT APP in collaboration and alignment with the Enterprise Data Blueprint architecture. The intention of the IT for IT APP is to provide increased consistency, quality, and insight in the information available to manage the business of IT. Through the Enterprise Blueprint architecture, the APP is implementing leading tools and principles in data warehousing to deliver an effective and efficient solution that simplifies the data environment. The IT for IT APP Application team is part of IT for IT Data Services team which is responsible for driving both near-term data to satisfy regulatory requirements while strategically creating the IT for IT APP.

The person that fills this position will be a vital part of our team and will be responsible for translating complex business and data requirements into logical data models adhering to defined data Modeling standards and industry best practice.

This position will:

  • Translate business and data requirements into logical data models adhering to defined data Modelling standards and industry best practices.
  • Consult with Database Administrators to translate Logical Models into a performant Physical models
  • Consult with other Modelers to rapidly integrate complex data sources into existing and new data models. Ensuring proper implementation and utilization of the data structures.
  • Provide guidance to data analysts in performance of analytic and data quality functions. Support analysis and profiling of the most complex data needs.
  • Consult with our Business Partners to understanding their business needs and recommend solutions. Translate complex technical concepts into something digestible by our business partners.
  • Build relationships with Subject Matter Expert (SME)s of the respective source system development teams.
  • Assist in defining strategy in areas such as Data Integration, Architecture, Data Quality, Meta data Management and Master Data Management.
  • Act in a consulting capacity to the development team. Utilizing their extensive knowledge of the application they will understand functional enhancements, consider all potential impact and provide advice on the most appropriate solutions & potential problems.
  • Responsible for very complex partner assignments to identify and define strategic business issues that require analyses and translates this information into insight, knowledge and understanding of the business and the industry.
  • Consults and performs very complex analyses/ analysis design involving data mining from multiple sources and/or predictive modeling, regression/multivariate, financial, comparative analysis, customer/demographic analysis, etc.
  • Analytics involved generally span multiple functional areas/business lines/data sources.
  • Responsibilities also include:
    • identifying opportunities for additional statistical models and/or creating sophisticated computer modeling approaches to analyze and forecast business performance;
    • participating in and/or leading management information capabilities development work;
    • Interpreting and presenting results of analyses and recommendations to senior management.
  • Ensures adherence to data management/data governance regulations and policies.
  • Data involved may be very large, structured or unstructured, and from multiple sources.
  • To a certain degree, may be involved directly or indirectly in the technical build-out and/or support of databases, query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, modeling, and/or data visualization.
  • Leads project/virtual teams & mentors lower level staff.

Multiple locations are available for this position. Remote work may be an option for those candidates that have Telecommuting experience.

Required Qualifications

  • 6+ years of experience in one or a combination of the following: reporting, analytics, or modeling; or a Masters degree or higher in a quantitative field such as applied math, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis and 4+ years of experience in one or a combination of the following: reporting, analytics, or modeling
  • 3 + years of experience working with large data sets
  • 6+ years of analytics experience
  • 6+ years of data modeling experience
  • 6+ years of SQL experience
  • 5+ years of Big Data experience
  • 5+ years of experience one or a combination of the following: reporting, analytics, or modeling in an information security environment, information technology environment, or a combination of both
  • 5+ years of Metadata experience
  • 5+ years of source/version control tools experience
  • 5+ years of SDLC (System Development Life Cycle) experience
  • 5 + years of experience troubleshooting environments across the entire architecture (i.e. applications to infrastructure)
Desired Qualifications

  • Extensive knowledge and understanding of research and analysis
  • Strong analytical skills with high attention to detail and accuracy
  • Excellent verbal, written, and interpersonal communication skills
  • 5+ years of data analysis experience
  • 5+ years of data management experience
  • 5+ years of ETL (Extract, Transform, Load) Programming experience
  • 3+ years of Ab Initio experience
  • 3+ years of Hadoop experience
  • Ability to develop operational reporting and performing complex data analysis
  • Knowledge and understanding of conversions, system analysis, data mapping, conversion reconcilement, validation and implementations
  • Ability to independently provide summary and recommendations on operational data
  • Knowledge and understanding of technical leadership including operations projects for complex development or high architectural impact projects
  • Knowledge and understanding of data modeling tools, such as Power Designer
  • Knowledge and understanding of data organizing or structuring complex data across varied data sources
  • Knowledge and understanding of data requirements management, modeling, or analysis
  • Knowledge and understanding of data warehouse analysis
  • Knowledge and understanding of data warehouse application design and development
  • Knowledge and understanding of database architecture, design, and support
  • Knowledge and understanding of database design/modeling logical and physical
  • Knowledge and understanding of database management, reporting, and analysis functions
  • Knowledge and understanding of database troubleshooting
  • Knowledge and understanding of database views design and use
  • Knowledge and understanding of databases and data mining techniques
  • Experience conducting root cause analysis for data-driven process-related improvements
  • Knowledge and understanding of asset management function support
  • Ability to negotiate, influence, and collaborate to build successful relationships
  • A BS/BA degree or higher in information technology
  • A Master's degree or higher in a quantitative discipline
Other Desired Qualifications
  • 6+ years of Oracle experience (Oracle 10/11G/12C)
  • 5+ years of experience with Oracle Exadata
  • 3+ years of agile software development techniques
  • Wells Fargo analytic consultant experience.

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

Apply Now
This job has expired and you can't apply for it anymore