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.
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
4+ years of ETL (Extract, Transform, Load) Programming experience
4+ years of data modeling experience
4+ years of experience with data analysis and documentation
2+ years experience designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables
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
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
5+ years of RESTful or SOAP web services
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.
NC-Charlotte: 128 South Tryon Street - 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.
Internal Number: 5552385
About Wells Fargo
Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $1.9 trillion in assets. Wells Fargo’s vision is to satisfy our customers’ financial needs and help them succeed financially. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, investment and mortgage products and services, as well as consumer and commercial finance, through 7,400 locations, more than 13,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in 32 countries and territories to support customers who conduct business in the global economy. With approximately 260,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 29 on Fortune’s 2019 rankings of America’s largest corporations. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories.
www.wellsfargo.com | Twitter: @WellsFargo