Business Intelligence & Analytics, Specialist

Department ​
 
BSD BIS - Business Intelligence Services

About the Department

​

The Business Intelligence & Analytics team provides solutions for presenting and distributing academic and administrative data from myriad sources related to the Biological Sciences Division of the University of Chicago.

Job Information ​
 

Job Summary:

Business Intelligence & Analytics, Specialists for Chicago, IL location. Develop and implement analytic programs and support the use of analytic platforms and administrative data across the University. Review administrative data for joint analyses across multiple domains. Partner with functional stewards, business units, and user partners to develop reporting and analytic solutions with appropriate data governance and secure access. Design, develop and implement Business Intelligence (BI) and other analytical applications, ETL and data warehouse. Guides requirements analysis, translating requirements into a scope document and developing reporting deliverables based on design. Plan, test and guide roll-out of patches and upgrades to the BI and analytic software. Perform dimensional data modeling and build, implement and maintain data dictionary, data cubes and data marts. Technology environment: Power BI; Tableau; SSRS; SSIS; Azure DevOps; MS PowerBuilder.

Responsibilities:

• Maintain an enterprise-level data dictionary.
• Designs, creates, and supports dimensional data models for academic.
• Administrative, and clinical functions.
• Gather vet data definitions for new solution implementation.
• Ensures security and compliance.
• Implement changes that lead to continuous improvement in customer service.

Competencies:

• Applicant should be proficient in Microsoft SQL, business analytics and reporting tools such as Power BI and Tableau, and ETL tools such as Microsoft Integration Services.
• Applicant will be familiar with data warehousing concepts, such as Kimballs' techniques regarding dimensional modeling.

Additional Requirements ​​
 

Education:

• Bachelor's degree in Computer Science or related field plus 5 years of progressive experience in the job offered or in analytics/ETL/BI

Experience:

• 3 years with each: Design and implement of ETL and Data warehouse
• Dimensional data modeling; Build and implement data dictionary & data marts
• PowerBI/Tableau/Crystal Reports; Reporting tools (SSRS/SAP Bus Obj)
• ETL Tools (SSIS/Informatica)
• Data warehouse design and implementation.
• ETL design and implementation.
• Dimensional data modeling.

Required Documents:

• Resume
• Cover Letter

When applying, the document(s) MUST  be uploaded via the My Experience page, in the section titled Application Documents of the application.

Benefit Eligibility ​
 
Yes

Requires Compliance with University Covid-19 Vaccination Requirement
 

Yes

Pay Frequency ​
 
Monthly

Pay Range
 
Depends on Qualifications

Scheduled Weekly Hours ​
 
40

Union ​
 
Non-Union

Job is Exempt
 
Yes

Drug Test Required
 
No

Motor Vehicle Record Inquiry Required
 
No

Health Screen Required
No

Posting Date ​
 
2022-05-09-07:00

Remove from Posting On or Before ​
 
2022-11-09-08:00

Posting Statement: ​​
 

Employees must comply with the University’s COVID-19 vaccination requirements. More information about the requirements can be found on the University of Chicago Vaccination GoForward .
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.

 

We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.

 

All offers of employment are contingent upon a background check that includes a review of conviction history.  A conviction does not automatically preclude University employment.  Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.

 

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: http://securityreport.uchicago.edu . Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.