Data Engineer - Software Engineer

Location
Charlotte, North Carolina
Posted
September 16 2020
Ref
5551210
Industry
Banking
Position
Retail Banking
Job Description

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

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

Wells Fargo Technology is a team of more than 40,000 information technology and security professionals who help keep Wells Fargo at the forefront of America's diversified financial services companies. Employees execute an engineering-led IT strategy to deliver stable, secure, scalable and innovative services that provide Wells Fargo global customers 'round-the-clock' banking access through in-store, online, ATM, and other channels. Wells Fargo Technology plays a critical role in the company's customer and employee experience, business and risk management transformation, and growth agenda.

Corporate Risk helps all Wells Fargo businesses identify and manage risk. We focus on three key risk areas: credit risk, operational risk and market risk. We help our management and Board of Directors identify and monitor risks that may affect multiple lines of business, and take appropriate action when business activities exceed the risk tolerance of the company.

We are seeking an Software Engineer - Data Engineer to be part of a team that provides reporting for Risk and Compliance across all levels of the organization. This position will use their strong understanding of risk systems, end to end data flow, data integration and enterprise risk data to assist in the development of the Enterprise Risk reporting and analytics application. This position will partner with Data Modelers, QA Testers, ETL developers, and Business Intelligence Analysts to design/develop/deploy Business Intelligence based solutions in the enterprise risk domain. This position requires hands-on experience in coding, debugging, troubleshooting and performance tuning data warehouse based applications using SQL and SQL Server.

Key responsibilities include, but not limited to:
  • Work with Data Modeler to understand and define Source to Target mapping, ensuring changes/impacts to existing designs don't change the fundamental metrics
  • Provide Data Profiling and Data analysis support for Data Modeler and Report Developers
  • Help load or create mockup data as needed to ensure development team can continue building when lack of data is present
  • Ensure Data Quality standards are met, and suggest Data Quality checks for ETL
  • Assist Technical Analyst in defining data needs and identifying data gaps, as well as, breaking down complex data issues to help resolve them
  • Work with technical teams to deliver on commitments within time and scope
  • Collaborate with source system and Authorized provisioning point (APP) teams, Data Analysts and Modelers to build scalable data solutions.
  • Understand business requirements with respects to data and reporting needs
  • Work closely with QA testers to review and assist in testing script creation, as well as, the execution of testing scripts in relation to data validation
  • Performance tuning and designing high performance applications involving huge data processing. The successful candidate will need to have advanced information delivery and development skills in order to create effective data solutions that can be easily maintained and extended to meet the growing demands.

As a Team Member Manager, you are expected to achieve success by leading yourself, your team, and the business. Specifically you will:
  • Lead your team with integrity and create an environment where your team members feel included, valued, and supported to do work that energizes them.
  • Accomplish management responsibilities which include sourcing and hiring talented team members, providing ongoing coaching and feedback, recognizing and developing team members, identifying and managing risks, and completing daily management tasks.


Required Qualifications

  • 5+ years of software engineering experience
  • 7+ years of SQL experience
  • 7+ years of business intelligence experience
  • 5+ years of MS SQL server experience
  • 5+ years of experience writing Microsoft SQL Server relational database queries, stored procedures, query optimization and performance tuning
  • 5+ years of RESTful or SOAP web services
  • 4+ years of ETL (Extract, Transform, Load) Programming experience
  • 4+ years of data modeling experience
  • 4+ years of experience with data analysis and documentation
  • 4+ years of experience in Hadoop ecosystem tools for real-time batch data ingestion, processing and provisioning such as Apache Flume, Apache Kafka, Apache Sqoop, Apache Flink, Apache Spark or Apache Storm
  • 2+ years experience designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables


Desired Qualifications

  • An industry-standard technology certification
  • Strong verbal, written, and interpersonal communication skills
  • 6+ years of experience with end-to-end design and delivery of data warehouse applications
  • Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
  • Experience applying new technologies to business needs in a technologically innovative , change-driven organization
  • Advanced Microsoft Office (Word, Excel, Outlook and PowerPoint) skills
  • Ability to articulate complex concepts in a clear manner
  • Strong analytical skills with high attention to detail and accuracy
  • Outstanding problem solving skills
  • Strong organizational, multi-tasking, and prioritizing skills
  • A BS/BA degree or higher


Other Desired Qualifications
  • Experience introducing improvements in his or her workplace through effective analysis, critical thinking, and innovation, including demonstrated ability to present complex concepts, options and recommendations in a manner that supports quality decision making.


Street Address

NC-Charlotte: 128 South Tryon Street - Charlotte, NC

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.

Similar jobs

Similar jobs