Software Engineer - Data Warehouse Developer - RWF

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 are looking for talented people who will put our customers at the center of everything we do. We are seeking candidates who embrace diversity, equity and inclusion in a workplace where everyone feels valued and inspired.

Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you.

Technology sets IT strategy; enhances the design, development, and operations of our systems; optimizes the Wells Fargo infrastructure; provides information security; and enables Wells Fargo global customers to have 24 hours a day, 7 days a week banking access through in-branch, online, ATMs, and other channels.

Our mission is to deliver stable, secure, scalable, and innovative services at speeds that delight and satisfy our customers and unleash the skills potential of our employees.

The Financial Accounting Control System (FACS) application supports multiple lines of business, primarily Wholesale banking, for their daily Profit and Loss and regulatory reporting needs.  The FACS platform uses MS SQL Server 2016 and SQL Server BI components.  The successful candidate must be client focused as a senior developer that will require the interpretation and analysis of the business requirements to assist with the design, development and delivery of a technology solution that meets the needs of the end users while maintaining compliance with Wells Fargo change management processes and procedures.  The developer will also have support duties for Level 3 or break/fix support.  After hours support may be required as needed.  

FACS application is in a hybrid transition state to big data.  Ideal candidate will be a subject matter expert in MS SQL Server data warehouse development and experience in big data solutions, i.e. Hadoop ecosystem, Apache Spark, Python/Scala.  Candidate must have pride in their own work, attention to detail, and strive to deliver a quality solution with minimal defects.

Responsibilities include:

• Act as lead change management/release coordinator for FACS and ensure entire application team is compliant with the Enterprise's SDLC policies and procedures.
• Act as lead facilitator regarding all of FACS Technology Compliance obligations and execution of policies and procedures.
• Develop and maintain documentation, departmental technical procedures and user guides. 
• Identify gaps in controls, policies or procedures within the application and remediate in a strategic fashion that aligns to the Enterprise's direction.
• Analyze highly complex business requirements, design and writes technical specifications to design or redesign complex computer platforms and applications.   FACS developers work closely with a business team of tech savvy business analysts to implement complex accounting solutions
• Lead projects, allocate and manage resources both onshore and offshore, and manage the work of less experienced staff
• Ability and desire to interact with business counterparts and represent own team well. 
• Act as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology (MS SQL Server 2016) tools (Visual Studio) and existing designs.
• Work with DBAs in Enterprise Database Management  group to troubleshoot problems and optimize performance
• Provide coding direction to less experienced staff or develop highly complex original code. 
• Act as an expert technical resource for modeling, simulation and analysis efforts. RWF – Please note that “RWF” is an identifier for internal recruiting purposes only and has no connection to the nature or responsibilities of the job.

• 5+ years of software engineering experience
• 5+ years of ETL (Extract, Transform, Load) Programming experience
• 5+ years of MS SQL server experience

• An industry-standard technology certification
• Strong verbal, written, and interpersonal communication skills
• 5+ years of SDLC (System Development Life Cycle) experience
• 3+ years of Apache Spark design and development experience using Scala, Java, Python or Data Frames with Resilient Distributed Datasets (RDDs)
• Knowledge and understanding of relational database concepts, querying, data warehousing, ETL process, requirements gathering and/or decision support tools
• 1 + year of SQL Server SSIS, SSRS and SSAS experience
• 1+ year of Autosys experience
• 1+ year of UNIX experience
• Experience designing and developing data warehouse or analytics applications using Apache Spark
• Experience Hadoop ecosystem tools relevant for real-time and batch data ingestion, processing and provisioning using tools such as Apache Flume, Apache Kafka, Apache Sqoop, Apache Flink, Apache Hive or Apache Storm
• Financial services industry experience
• Knowledge and understanding of project management and implementation in a technical environment
• Strong analytical skills with high attention to detail and accuracy
• Strong, clear and concise written and oral communication skills
• Microsoft Certified Solution Developer (MCMCSD, MCAD)
• A BS/BA degree or higher in information technology

• Kimball Data Warehousing Methodology

• Ability to work outside of regular business hours

NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC

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

Benefits
 

Visit https://www.wellsfargo.com/about/careers/benefits for benefits information.