Missouri Veterans Jobs

Jobs.mo.gov mobile logo

Job Information

Wells Fargo Software Senior Engineer (Data Modeling, Reporting & Analytics) in Saint Louis, Missouri

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.

The Application Products Center of Excellence (APCoE) is responsible for programs, initiatives and efforts related to the product lifecycle, security/non-security patching and configuration management for all third party products aligned to the Application, Asset Class Owner (ACO). Our goals include developing and maintaining sustainable processes that align to the Corporate Policies and Control Standards. Related programs include, but are not limited to, the Configuration Management Program (CMP), Enterprise Technology Currency Practice (ETCP) and the Enterprise Patch Program (EPP).

The Software Engineer Sr, will be the team's lead developer. This person will be responsible for delegating work, building and designing reporting, metrics and visualizations that support, measure and identify improvement opportunities relevant to the APCoE business processes. The candidate will support and maintain the APCoE portfolio reporting system, produce quantifiable reporting solutions, develop solutions for forecasting, predictive modeling, KPIs, KRIs, OPIs, metrics, trending controls and other.

The position also requires a strong attention to detail, the ability to design quality solutions, in a fast paced environment, with limited requirements while working in an Agile environment. As well as, the ability to create strong, easy to read reporting visualizations, from the aggregate level to drill down data is essential for this role.

The ideal candidate for this position:

  • Knowledge and understanding of the Corporate Policies and Control Standards

  • Experience in reporting, metrics and reporting visualizations

  • Strong background with SQL, Excel, Tableau and other BI reporting and analytical tools

  • Data modeling, dimensional modeling and database design with SQL implementation

  • Experience creating, supporting and maintaining a database and/or data-mart

  • Experience creating operational databases and data models

  • Experience using query tools, reporting tools, BI tools to create reports, metrics, dashboards, storyboards and other data visualizations.

  • Ability to build, support and implement database solutions using Team Foundation Server (TFS) and query tools

Required Qualifications

  • 7+ years of software engineering experience

  • 6+ years of experience writing Microsoft SQL Server relational database queries, stored procedures, query optimization and performance tuning

  • 5+ years of T-SQL (Transact-SQ) experience

  • 5+ years of experience with end-to-end design and delivery of ETL (Extract, Transform, Load) applications

  • 2+ years of SDLC (System Development Life Cycle) experience

Desired Qualifications

  • An industry-standard technology certification

  • Strong verbal, written, and interpersonal communication skills

  • 5+ years of reporting experience, analytics experience or a combination of both

  • 3+ years of data modeling experience

  • 2+ years of Tableau experience

  • ETL, data warehouse and data analytics delivery experience on internal or external cloud platforms

  • Advanced problem solving and technical troubleshooting capabilities

  • Experience with one or more Agile tools used for tracking user stories or backlogs, such as VersionOne and Team Foundation Server (TFS)

  • Autosys experience

  • Knowledge and understanding of Python, Ruby, PowerShell, and Shell scripting

  • API programming experience with Perl, XML, REST or JSON

  • Experience with RESTful API calls

  • Exposure to Wells Fargo's Remedy Asset Management (PAC2000) application

  • Ability to produce high level summary analysis reports in a meaningful and understandable format

  • Knowledge and understanding of analytical methods used to: develop interactive dashboards and scorecards

  • Strong analytical skills with high attention to detail and accuracy

  • Knowledge and understanding of business requirements analysis including: identification of alternative solutions and associated tradeoffs

  • Ability to take initiative and work independently with minimal supervision in a structured environment

Job Expectations

  • Flexibility to address incidents as needed 24 hours a day

  • Ability to travel up to 10% of the time

Street Address

MO-Saint Louis: 1 N Jefferson Ave - Saint Louis, MO

NC-Charlotte: 401 S Tryon St - Charlotte, NC

NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC

TX-Irving: 2975 Regent Blvd - Irving, TX

TX-DAL-Downtown Dallas: 1445 Ross Ave - Dallas, TX

TX-Irving: 6051/6061 N State Hwy 161 - Irving, TX

AZ-Chandler: 2600 S Price Rd - Chandler, AZ

AZ-Chandler: 2700 S Price Rd - Chandler, AZ

AZ-PHX-Northwest Phoenix: 2222 W Rose Garden Ln - Phoenix, AZ

MN-Minneapolis: 255 2nd Ave S - Minneapolis, MN

MN-Minneapolis: 550 South 4th St - Minneapolis, MN

MN-Minneapolis: 600 S 4th St - Minneapolis, MN

MN-Minneapolis: 425 E Hennepin Ave - Minneapolis, MN

MN-Shoreview: 1801 Parkview Dr - Shoreview, MN

CA-SF-Financial District: 333 Market St - San Francisco, CA

CA-SF-South Of Market Area: 45 Fremont Street - San Francisco, CA

NY-New York: 150 E 42nd St - New York, NY

TX-Arlington: 2221 E Lamar Blvd - Arlington, TX

NY-New York: 30 Hudson Yards - New York, NY

NJ-Summit: 190 River Rd - Summit, NJ

NY-New York: 100 Park Ave - New York, NY


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.

Company: Wells Fargo

Req Number: 5561036-20

Updated: 2021-01-16 22:22:22.157 UTC

Location: Saint Louis,MO