Data Solution Designer - Application Systems Engineer 6

Wells Fargo   •  

Gastonia, NC

11 - 15 years

Posted 247 days ago

This job is no longer available.


Job Description


Enterprise Information Technology (EIT) Authorized Provisioning Point (APP) Application team is seeking an Application Systems Engineer. Enterprise Information Technology (EIT) Authorized Provisioning Point (APP) Application team is responsible for driving the design and development of the new EIT APP (Authorized Provisioning Point in collaboration and alignment with the Enterprise Data Blueprint architecture. The intention of the EIT 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 EIT 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 EIT APP.

This position will play a key technical leadership role and responsible for analyzing, designing, and implementing solutions specific to IT data. Will work directly with Enterprise Data Analytics (EDA) Data Architecture, Enterprise Information Technology (EIT) Systems Architects, and IT business partners to understand the requirements and partner with the development team to implement high performant database solutions of IT data within the Wells Fargo enterprise. 


  • Analyze incoming data requests and determine appropriate target solutions for specific requests.
  • Work very closely with business analysts, development teams and project managers for requirements and business rules.
  • Partner with source system Subject Matter Experts (SME)s, Architects, Data Analysts and Modelers to build scalable and performant data solutions. 
  • Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.
  • Plan, perform, and act as the escalation point for the most complex platform designs, coding, and testing
  • Work with DBAs in Enterprise Database Management  group to troubleshoot problems and optimize performance
  • Effectively work in an ETL framework driven environment
  • Support ongoing data management efforts for Development, QA and Production environments

Additional responsibilities:

  • Acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs.
  • Provides technical consultation and support in the development of computer applications and programs.
  • Develops original and/or highly complex code and provides coding guidance to less experienced staff.
  • Leads and/or performs modeling, simulations and analysis efforts.
  • Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.
  • Acts as an expert technical resource for modeling, simulation and analysis efforts.
  • Oversees overall systems testing and the migration of platforms and applications to production.
  • Develops new documentation, departmental technical procedures and user guides.
  • Leads projects, allocates and manages resources and manages the work of less experienced staff.
  • Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan.

The preferred work location is Fremont, CA.  Multiple locations are available for this position. Remote work may be an option for those candidates that have Telecommuting experience.

Required Qualifications

  • 10+ years of application development and implementation experience
  • 10+ years of experience with databases such as Oracle, DB2, SQL server, or Teradata
  • 10+ years of relational database experience
  • 10+ years of SQL experience
  • 10+ years of SDLC (System Development Life Cycle) experience
  • 10 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
  • 9+ years of PL/SQL experience
  • 7+ years of ETL (Extract, Transform, Load) Programming experience with Ab Initio products such as EME, Control Center, Metadata Hub, or Conduct IT

Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills
  • 10+ years of source or version control tools experience
  • 7+ years of Big Data experience
  • 7+ years of Metadata experience
  • 3+ years of Hadoop experience
  • Engineering and architecture experience with big data
  • Knowledge and understanding of database modeling techniques and theory
  • Knowledge and understanding of relational database concepts, querying, data warehousing, ETL process, requirements gathering and/or decision support tools
  • Ability to identify business needs and deliver solutions in close partnership with line of business and technology
  • Experience applying new technologies to business needs in a technologically innovative , change-driven organization
  • Excellent verbal, written, and interpersonal communication skills
  • A BS/BA degree or higher in information technology

Other Desired Qualifications

  • 7+ years of designing and implementing highly distributed, scalable, and performant back-end database processes -  Staging, Data Enrichments and Strong data delivery techniques.
  • 7+ years’ of overall Database information architecture (ETL Architecture and Design), design, development and implementation experience in Relational and Dimensional databases.
  • 7+ years of Oracle experience (Oracle 10/11G/12C).
  • 5+ years of experience as an Oracle Exadata Developer.
  • 3+ years of experience working with QA and other Technology teams within Wells Fargo.
  • 3+ years of agile software development techniques including designing software for unit testing and acceptance
  • Experience in business analysis techniques and data warehouse design techniques.
  • Experience deploying and supporting large, complex data warehouse/business intelligence solutions.
  • Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
  • Experience in Machine learning technologies.
  • testing, and the use of continuous integration.
  • Experience leading junior level team members in a lead role.
  • Wells Fargo development experience.