U.S. Bank Data Warehouse Architect - CDC in SAINT LOUIS, Missouri

U.S. Bancorp Community Development Corporation (USBCDC) is seeking a skilled Data Warehouse Architect with data warehousing implementation and data architecture experience to join its growing technology team. This individual will help advance USBCDC’s business intelligence (BI) capabilities and transform the way that the company aggregates, stores, transforms, analyzes, and leverages its data. The Data Warehouse Architect will partner closely in an Agile, Scrum environment with a team of application developers, system administrators, quality assurance analysts, business analysts, data analysts and report writers who support a custom-built .NET web application. Working with the team to unleash the power of the information that underpins that application – and driving the architectural changes required to create a new data warehouse – will be the Architect’s most important tasks.

In addition to designing the information architecture for the data warehouse (e.g., staging area, data warehouse, data marts, data cubes, and other operational data stores), the ideal candidate will take an active role in the technical work needed to achieve these goals. The Architect also will: design and implement architecture that successfully integrates new and existing BI environments; inventory existing data architecture; develop and apply a working knowledge of USBCDC’s business lines and data analysis needs; oversee the standardization of data definitions; develop data models and provide leadership to other data modelers; and provide technical expertise to development teams.

The most successful applicants will be self-organizing, team-oriented, demonstrate exemplary written and verbal communication skills, and be able to thrive as a founding member of USBCDC’s new data warehouse team. They also will exemplify U.S. Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

Members of USBCDC’s technology team have year-round access to training opportunities and attend both local and national conferences each year. Other benefits for which this position is eligible include a 401(k) retirement savings plan with company match, a cash balance pension benefit, and a short-term cash incentive bonus program.


Basic Qualifications

-Bachelor's degree or equivalent work experience

-At least 5 years experience with tools, facilities and techniques for managing and administering data.

Required Skills/Experience

• Prior experience designing and implementing data warehouse solutions

• Subject matter expertise in data warehousing and database structures

• Experience with SQL, T-SQL, and SQL Server

• Experience working in an Agile, Scrum environment

Preferred Skills/Experience

• Design, implementation and troubleshooting of data cubes and ETL processes

• Experience using Tableau and Tableau Data Prep

• Familiarity with Microsoft Team Foundation Server (TFS), and Visual Studio 2017

• Extensive experience with logical data modeling, business intelligence, requirements analysis, system testing tools, and system development life cycle

• Prior work experience in banking, finance, and/or tax credit investments

Job: Information Technology

Primary Location: Missouri-MO-Saint Louis

Shift: 1st - Daytime

Average Hours Per Week: 40

Requisition ID: 180036497

Other Locations: CA-CA-San Francisco, Minnesota-MN-Minneapolis

U.S. Bank is an Equal Opportunity Employer committed to creating a diverse workforce.

U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.