Job Directory Data Warehouse Analyst

Data Warehouse Analyst
Chicago, IL

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.


Job Description

Please make sure to read the job posting in its entirety as it reflects both the University roles and responsibilities, followed by the specific description.

Department30344 Bus-Information Technology

About the UnitThe University of Chicago Booth School of Business is the second-oldest school in the U.S. and second to none when it comes to influencing business education and business practices. Since 1898, the school has produced ideas and leaders that shape the world of business. Their rigorous, discipline-based approach to business education transforms students into confident, effective, respected business leaders prepared to face the toughest challenges. Chicago Booth has the finest set of facilities of any business school in the world. Each of the four campuses (two in Chicago, one in London, and one in Hong Kong) reflects the architectural traditions of its environs while offering a state-of-the-art learning environment. Chicago Booth is proud to claim: -an unmatched faculty. -degree and open enrollment programs offered on three continents. -a global body of nearly 50,000 accomplished alumni. - strong and growing corporate relationships that provide a wealth of lifelong career opportunities. As part of the world-renowned University of Chicago, Chicago Booth shares the University's core values that shape the distinctive intellectual culture. At Booth, they constantly question and test ideas, and seek proof. This extraordinarily effective approach to business leads to new ideas and innovative solutions. Seven of the Booth faculty members have won Nobel Prizes for these ideas - the first business school to achieve this accomplishment. For more information about the University of Chicago Booth School of Business, please visit:

Job FamilyInformation Technology

Responsible for the design, implementation, and maintenance of new and existing applications, systems architecture, and network infrastructure. Ensures operation and security of all servers and networks. Configures, installs, maintains and upgrades applications and hardware for the organization's infrastructure and for end-user devices.

Career Track and Job LevelDatabase Administration

Administers database utilities, monitors the relationships between the database users and applications, and maintains the University's databases across multiple platforms and computing environments. Maintains database support tools, database tables and dictionaries and recovery and back-up procedures. Provides training to end users.

P4: Requires specialized depth and/or breadth of expertise. Interprets internal or external University issues and recommends best practices. Solves complex problems; takes a broad perspective to identify innovative solutions. Works independently, with guidance in only the most complex situations. May lead cross-functional or divisional teams or projects.

Role ImpactIndividual Contributor

ResponsibilitiesThe job leads teams to solve complex problems related to the maintenance of the University's databases across multiple platforms and computing environments. Uses specialized knowledge of database support tools, database tables and dictionaries, and recovery and back-up procedures to evolve University databases.

1) Leads teams to execute procedures related to server installation, performance monitoring, database maintenance, and data backup and recovery., 2) Provides expertise to user community on various report writer access, database views, and storage procedures related to all databases. Interprets database issues and establishes optimum values for physical database parameters such as amount of computer memory to be used., 3) Researches and analyzes database computer products and systems available in the marketplace, determines appropriate IT solutions, and makes recommendations based on the core business function of the end-users., 4) Uses specialized breadth and depth of database expertise to assess the costs and impact of database changes. Anticipates risks when making plans to coordinate implementation of database changes., 5) Performs other related work as needed.

Unit-Specific Responsibilities

1) The Data Warehouse Analyst is responsible for developing and maintaining reporting solutions. They will participate in all phases of data warehouse and business intelligence solution design and development, including requirements gathering, database design, dimensional modeling, source to target mapping, ETL development, testing and documentation.

2) Design, build and support data warehouse components including: the database, ETL processes, reporting environment and reports.

3) Design dimensional models with conformed dimensions based on business processes.

4) Build and automate ETL processes that include reconciliation and error handling using Microsoft SQL Server Integration Services (SSIS).

5) Design and build the reporting environment utilizing SAP Business Objects.

6) Enhance existing data warehouses by adding new fields, writing reports, creating dashboards and creating Business Objects filters, measures and objects.

7) Develop processes for capturing and/or maintaining metadata.

8) Gain an in-depth understanding of the Booth business processes and applications and how they affect data and reporting and use this knowledge in the design of the data warehouse and reports.

9) Work with end users to define and document requirements for new and existing data warehouse components and reports.

10) Assist clients with the data warehouse and the creation of Business Objects reports.

11) Perform ETL performance tuning, troubleshooting, support, and capacity planning.

12) Gather and analyze performance statistics and recommend options for improvements.

13) Create and maintain system documentation.

Unit-Preferred Competencies

1) A solid understanding of data warehouse fundamentals and experience building and supporting data warehouses.

2) Excellent oral and written communications skills.

3) Must be able to work both independently and in a team environment.

Education, Experience, and CertificationsMinimum requirements include a college or university degree in related field.

Minimum requirements include knowledge and skills developed through 7+ years of work experience in a related job discipline.

Preferred Qualifications


1) At least five years of experience developing and supporting data warehouses.

2) At least three years of work experience with SAP Business Objects is required.

3) At least five years of work experience with Microsoft SQL Server, SQL Server Integration Service (SSIS).

4) Experience developing ETL processes, data cleansing, creation of metadata and the use of various reporting tools.

Required Documents

1) Resume

2) Cover letter

NOTE: When applying, all required documents MUST be uploaded under the Resume/CV section of the application.

FLSA StatusExempt

Pay FrequencyMonthly

Pay GradeDepends on Qualifications

Scheduled Weekly Hours37.5

Benefits EligibleYes

Drug Test RequiredNo

Health Screen RequiredNo

Motor Vehicle Record Inquiry RequiredNo

Posting Date2019-05-02-07:00

Remove from Posting On or Before2019-11-02-07:00

Posting Statement

The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.

Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via Applicant Inquiry Form.

The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.