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 sets IT strategy; enhances the design, development, and operations of our systems; optimizes the Wells Fargo infrastructure footprint; provides information security; and enables continuous banking access through in-store, online, ATM, and other channels to Wells Fargo's more than 70 million global customers.
We are seeking an Apps Systems Engineer 5 - 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.
7+ years of application development and implementation experience
7+ years of SQL experience
7+ years of business intelligence experience
7+ years of SDLC (System Development Life Cycle) 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
Good 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
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: 5549505
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