Senior Data Warehouse Analyst - CDC

US Bank Saint Louis , MO 63150

Posted 1 week ago

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.

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

  • 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

Preferred Skills/Experience

  • 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

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Warehouse Architect CDC

US Bank

Posted 1 week ago

VIEW JOBS 11/11/2018 12:00:00 AM 2019-02-09T00:00 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 US Bank Saint Louis MO

Senior Data Warehouse Analyst - CDC

US Bank