6 days old

BI ETL Developer

Charlotte, NC 28202
  • Job Code
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. Were looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where youll 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 Fargos 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 persons 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 warehouses 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# experience3+ years of MS SQL server experience3+ years of SharePoint experience4+ years of Object Oriented experience7+ years of .net experience4 + years of PowerShell scripting experience7+ years of application development and implementation experience

Desired Qualifications

A BS/BA degree or higher in information technologyExcellent verbal, written, and interpersonal communication skills1+ year of JavaScript development experience2+ years of ASP.Net experience3+ years of Tableau experience4+ years of relational database experience4+ years of MS Visual Studio experienceKnowledge and understanding of DevOps principlesExperience with Agile Scrum (Daily Standup, Sprint Planning and Sprint Retrospective meetings) and KanbanGood 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 systemsJob Expectations

Ability to work nights, weekends, and/or holidays as needed or scheduledAbility to travel up to 10% of the timeAbility 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.



Posted: 2020-05-19 Expires: 2020-06-18

Featured Jobs

Sponsored by:
ADP Logo

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

BI ETL Developer

Wells Fargo
Charlotte, NC 28202

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast