Intern- Enterprise Data Warehouse

Zions Bancorporation•Salt Lake, UT

About The Position

Zions Bancorporation is seeking an Enterprise Data Warehouse Intern to join Enterprise Data and Analytics for a paid Summer 2027 internship running from mid-May through mid-August. The position is not eligible for relocation assistance, and local candidates are preferred. Internship and Banker Development Program positions are not eligible for employment visa sponsorship, including sponsorship that may be needed after a period of temporary student work authorization. The role involves working with relational databases, data models, data pipelines, SQL, and business intelligence or analytical tools. Candidates should be able to catalog historical data-pipeline bugs and propose or develop test suites to reduce risk when code is released. Applicants must submit a cover letter listing their degree and describing relevant skills and experience with relational database platforms, data modeling, and/or business intelligence tools.

Requirements

Pursuing a bachelor's or master's degree in information systems, computer science, mathematics, statistics, science, business, or a related field.
Experience using one or more relational database platforms, such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
Understanding of relational and/or dimensional data models, particularly with large data sets.
Ability to construct simple to moderate SQL statements to query and access data.
Strong interpersonal, presentation, and verbal and written communication skills.
Ability to gather and communicate business requirements to technical teams and bridge business users and IT developers.
Submit a cover letter listing the degree being pursued and describing relevant skills and experience with relational database platforms, data modeling, and/or business intelligence tools.

Nice To Haves

Knowledge of or aptitude for business intelligence reporting and analytical tools, such as BusinessObjects, Crystal Reports, QlikView, Cognos, Tableau, or MicroStrategy.
Familiarity with tools and techniques for constructing and evaluating mathematical or statistical models using a variety of approaches or algorithms.

Responsibilities

Catalog historical bugs in data pipelines and propose or develop test suites to reduce risk during code releases.
Construct simple to moderate SQL statements to query and access data.
Gather and communicate business requirements to technical teams, bridging business users and IT developers.
Present results and findings across multiple levels of management.