U.S. Bank Senior Data Warehouse Analyst - CDC in SAINT LOUIS, Missouri
U.S. Bancorp Community Development Corporation (USBCDC) is seeking an ccomplished Senior Data Warehouse Analyst with database analysis and design 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 analyzes, cleanses, transforms, reports and leverages its data. The Analyst 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 web application that serves as USBCDC’s primary system of record. Working with the team to unleash the power of the information that underpins that system – and powering data-driven decision making through the creation of robust reporting tools – will be the Analyst’s most important tasks.
The Analyst also will: lead collaboration with USBCDC’s business lines to understand and define the company’s data needs; analyze data from various systems of record as it pertains to data warehousing; model data conceptually and logically; work closely with a data architect to define relationships in data; interpret and write business and functional requirements associated with the design, development, maintenance and integrity of the organization’s data repositories and reports; design methods for data validation to ensure quality; provide consulting and guidance to other data analysts and report writers; advise on the buildout of a new data warehouse; and share knowledge associated with tools for data analysis across the company.
The ability to develop a working knowledge of USBCDC’s tax equity and community lending business lines – and apply that knowledge to fundamentally change how the company utilizes its data – is essential to success in this position. The strongest applicants will be self-organizing, team-oriented, exhibit 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. Extensive experience using Tableau and Tableau Data Prep – or other similar tools – is required.
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 cash incentive bonus program.
-Bachelor's degree or equivalent work experience
-At least 5 years experience with tools, facilities and techniques for managing and administering data.
• Subject matter expertise in data warehousing, database structures and data analysis
• Extensive experience using Tableau and Tableau Data Prep or other similar tools
• Experience working in an Agile, Scrum environment
• Extensive experience with logical data modeling, business intelligence, requirements analysis, system testing tools, and system development life cycle
• Experience with data cubes and ETL processes
• Familiarity with SQL, T-SQL, and SQL Server
• Familiarity with Microsoft Team Foundation Server (TFS)
• 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: 180036495
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.