BI ETL Developer


: $89,120.00 - $130,400.00 /year *

Employment Type

: Full-Time


: Information Technology

Loading some great jobs for you...

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

The Enterprise SharePoint Services group, a team within Wells Fargo Technology is looking for an Application Programmer Analyst to join our team and contribute to business intelligence reporting and dashboard projects and also with production support for our existing BI applications and systems.

The Enterprise SharePoint services team operates several very large SharePoint farms that host intranet sites which numerous lines-of-business within the Bank use for publishing content, sharing information for internal team collaboration, and for light business process applications and workflows. Our BI applications extract data from SharePoint sites and from other data sources that relate to the management/operation of SharePoint sites. That information is stored in a data warehouse, and presented in various reports and dashboards to site owners and business partners to help them manage the sites according to Wells Fargo governance policies.

The intended role for this new position will be to act as a lead developer for the scripts and/or applications that perform data extraction and loading processes, the ETL operations. This developer is responsible for supporting the existing products, for making enhancements to them, and for creating new ones when additional data sources are added to the data warehouse. Part of this person's role is to insure that ETL operations are fast, efficient, and reliable, and are built according to Wells Fargo data security and secure coding standards

This position will be responsible for working with the owners of new data sources to establish how we can connect to their system and data and best load what we need into the data warehouse.

Responsibilities may include but are not limited to:

  • Finding/fixing errors and bugs in the existing Powershell ETL scripts
  • Designing, implementing, and stewarding database cube structures
  • Creating new Powershell ETL scripts when new data elements or new data source are added
  • Maintaining a list of Support and Enhancement tasks and a work backlog in TFS
  • Participating in sprint planning and project meetings to keep track of work that is underway, and insuring that project milestones and release dates are met
  • Researching and repairing any vulnerabilities that found in the data warehouse's data security or its ETL processes.
  • Helping report and dashboard developers, as needed, to properly query the stored data
  • Design and implement processes to help track on report on the performance, usage, and availability of the ETL processes and the data warehouse
  • Create and implement health monitoring, logging, diagnostic, and alerting capabilities where existing BI services and applications are at risk of having errors and outages occur undetected
  • Coordinate code testing efforts with multiple testing teams; coordinate with other groups to plan and schedule code releases

This may occasionally require work to take place after normal business hours or more rarely, on weekends.

Required Qualifications

  • 3+ years of C# experience
  • 3+ years of MS SQL server experience
  • 3+ years of SharePoint experience
  • 4+ years of Object Oriented experience
  • 7+ years of .net experience
  • 4 + years of PowerShell scripting experience
  • 7+ years of application development and implementation experience

Desired Qualifications

  • A BS/BA degree or higher in information technology
  • Excellent verbal, written, and interpersonal communication skills
  • 1+ year of JavaScript development experience
  • 2+ years of ASP.Net experience
  • 3+ years of Tableau experience
  • 4+ years of relational database experience
  • 4+ years of MS Visual Studio experience
  • Knowledge and understanding of DevOps principles
  • Experience with Agile Scrum (Daily Standup, Sprint Planning and Sprint Retrospective meetings) and Kanban
  • Good verbal, written, and interpersonal communication skills

Other Desired Qualifications
  • SharePoint Online Experience
  • Powershell v5 Experience
  • 3+ Years of Power BI Experience
  • 2+ Years of User Centered Design Experience
  • 4+ years of using TFS, Git ,SVN or other enterprise source control systems

Job Expectations

  • Ability to work nights, weekends, and/or holidays as needed or scheduled
  • Ability to travel up to 10% of the time
  • Ability to work outside of regular business hours

Street Address

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.

Job Requirements:

Associated topics: data administrator, data analytic, data architect, data center, data integration, data quality, data warehouse, data warehousing, database administrator, teradata * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...