Data Warehouse Architect

US Bank Hopkins , MN 55343

Posted 1 week ago

U.S. Bank is seeking a skilled Data Warehouse Architect with implementation, maintenance, and production support experience to contribute toward the success of our technology initiatives. Designs the information architecture for the data warehouse, including all information structures (i.e., staging area, data warehouse, data marts, and operational data stores). Inventories existing data architecture, including data flows and systems. Understands analytical reporting requirements. Designs data architecture that integrates new and existing Business Intelligence environments. Oversees the standardization of data definitions. Develops logical and physical data models. Defines subject areas. Creates procedures for maintaining models. Provides leadership to database group, IT, and the enterprise. Partners with IT and business customers to develop and design requirements to formulate technical design. Coordinates with technical, ETL, and Business Intelligence architects. Leads other data modelers. Provides technical consulting and guidance to development teams during project design and development. Assists with testing, as required.

Successful applicants will have excellent communication skills, be prepared to add immediate value, maintain flexibility, and exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

Basic Qualifications

  • Bachelor's degree or equivalent work experience

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

Preferred Skills/Experience

Extensive experience in:

  • Logical data modeling

  • Business assessment

  • Requirements analysis

  • System testing tools

  • System development life cycle

  • Modeling: data, process, events, objects

  • IT quality assurance

  • Technical troubleshooting

Subject matter expert in:

  • Data warehousing

  • Database structures

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
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 Analyst

US Bank

Posted 2 weeks ago

VIEW JOBS 3/6/2019 12:00:00 AM 2019-06-04T00:00 U. S. Bank has an immediate need for a Data Warehouse Analyst and is seeking junior candidates for an exciting Rare Opportunity, to work alongside senior resources that support the existing environment, while taking on future data warehouse and business intelligence efforts for the business. Expect to roll up your sleeves, gain experience quickly and ownership in the process. Look to contribute every day to the success of the group, grow with the team, and advance in your career! Successful applicants will have excellent communication skills, be prepared to add immediate value, maintain flexibility, and exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship. Interprets and writes business and functional requirements associated with the design, development, maintenance, and integrity of organizational data warehouse and data repository. Ensures data quality within the warehouse. Responsibilities: * Analyzes data from various systems of record as it pertains to data warehousing * Communicates with the business to understand and define their data requirements * Writes basic functional and non-functional requirements and other documentation required for metadata * Performs data validation * Works with data architect to define relationships in the data within the system of record and within the data warehouse * Defines business rules concerning the process of the data warehouse * Designs methods for data validation to ensure data quality * Develops and maintains metadata and data mapping documents * Communicates effectively with business lines and various technology groups * Leads reviews of functional and non-functional requirements with development teams and business lines * Provides consulting and guidance to other technical teams during requirements gathering and data discovery * Shares knowledge associated with tools for data analysis * Plans and conducts data warehouse and data repository system tests, monitors test results and takes required corrective action Successful applicants will exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship. Basic Qualifications * Bachelor's degree or equivalent work experience * At least 3 years experience with tools, facilities and techniques for managing and administering data. Preferred Skills/Experience Working experience in: * Accuracy and attention to detail * Problem solving and trouble shooting skills * Communication impact to engage with business and technical teams * Executional excellence * Teamwork and collaboration * Business assessment * Requirements gathering * Modeling: data, procedures, events, objects * Logical data modeling * System development life cycle * IT quality assurance * Technical troubleshooting * Database structures * Data warehousing * Data design tool * BI tools eg. SAP Business Objects * Design tools eg. SAP PowerDesigner * ETL tools eg. Informatica * SQL Server * Production Support Extensive experience in: * Information management US Bank Hopkins MN

Data Warehouse Architect

US Bank