Business Intelligence & Analytics Analyst

The University Of Chicago; Chicago, Northern (IL, KY); Hybrid; USD 70,000 - 110,000; Full time

Job summary

The University of Chicago seeks a Business Intelligence & Analytics Analyst to design, develop, and support ETL/ELT processes and data models for enterprise reporting. You will ensure data quality and security while supporting BI applications across academic, administrative, and clinical areas.

Responsibilities include developing SQL queries, maintaining data structures, and translating business needs into technical solutions, with collaboration across stakeholders and IT teams.

Qualifications

• Minimum requirements include a college or university degree in related field.
• 2-5 years of work experience in a related job discipline.

Responsibilities

• Design, develop, test, and maintain ETL/ELT processes for enterprise reporting and analytics.
• Design and support dimensional data models, database objects, and reporting data structures.
• Develop and optimize SQL queries, stored procedures, views, and related database components.
• Gather and translate business and reporting requirements into technical solutions.
• Create and maintain technical documentation, metadata, data definitions, and source-to-target mappings.
• Support BI reports, dashboards, and analytic applications.
• Monitor and troubleshoot ETL jobs, data issues, and BI application problems.
• Ensure data quality, integrity, security, access control, and compliance.

Skills

SQL

Power BI

Tableau

Data modeling

ETL

Education

Bachelor's degree in CS or related

Tools

Microsoft SSIS

SQL Server

Job description

Department

BSD BIS - Business Intelligence Services

About the Department

The University of Chicago biomedical enterprise houses three entities: the Biological Sciences Division (BSD), the University of Chicago Medicine (UCM), and the Pritzker School of Medicine. Collectively called UCM, we are one of the nation's leading academic medical institutions and have been at the forefront of discovery, education, and clinical care since 1927. Located 20 minutes south of downtown Chicago, our Hyde Park main campus provides a single environment for learning, world-renowned basic science and clinical research, and outstanding clinical care. The BSD is the largest academic unit within the University. The BSD is comprised of faculty from ten basic science departments, 13 clinical departments, and several Centers and Institutes. The approximately 1,300 faculty and 3,000 staff members working in the BSD collaborate across the organization to achieve our Mission, Vision, and Values (MVV):

Mission, Vision, and Values (MVV)

MISSION: As part of the University of Chicago, we pursue globally impactful solutions to seemingly unsolvable challenges. Through our rigorous research, innovative education, and comprehensive care and healing, we collaborate on life-changing advancements that create meaningful results for our community and the world, including a greater, more equitable future for all.

VISION: Together, we elevate the human experience with knowledge and health care.

Values

• Commit to Excellence: We contribute our exceptional talents to all we do and empower the same spirit of excellence in others.
• Embrace Curiosity: We stay open to new ideas, champion diverse perspectives, and drive a culture of thoughtful risk-taking to deliver transformative innovation.
• Embody Equity: We identify systemic issues and then foster change to drive a more equitable environment inclusive of diverse people, ideas, and fields of science.
• Grow Together: We meaningfully collaborate with one another to create something bigger than we could ever achieve alone.
• Make a Difference: We lead with heart and compassion in all our interactions. We create positive change in our areas of influence, whether expanding scientific inquiry, developing the next generation of leaders, or healing our community.
• Take Ownership: We accomplish what we say we will and hold ourselves and one another accountable for our actions.

The MVV serves as our True North, charting our strategic plan for the next ten years and beyond.

It is an exciting time to be a part of the University of Chicago and the BSD. Our team is helping to shape the future for our learners, staff, faculty, patients, and community.

Job Summary

The Business Intelligence & Analytics Analyst designs, develops, and supports data integration, data modeling, and business intelligence solutions that enable enterprise reporting and analytics. This role is responsible for building and maintaining ETL processes, database objects, and reporting data structures; ensuring data quality and security; and supporting BI applications and users across academic, administrative, and clinical areas.

Responsibilities

• Design, develop, test, and maintain ETL/ELT processes for enterprise reporting and analytics.
• Design and support dimensional data models, database objects, and reporting data structures.
• Develop and optimize SQL queries, stored procedures, views, and related database components.
• Gather and translate business and reporting requirements into technical solutions.
• Create and maintain technical documentation, metadata, data definitions, and source-to-target mappings.
• Support BI reports, dashboards, and analytic applications.
• Monitor and troubleshoot ETL jobs, data issues, and BI application problems.
• Ensure data quality, integrity, security, access control, and compliance.
• Support software upgrades, testing, deployment activities, and continuous improvement efforts.
• Plans and executes requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design.
• Works with users to ensure deliverables are meeting or exceeding expectations.
• Provides support and communicates issues to users as defined by IT standards.
• Monitors access control and troubleshoot BI and analytic applications.
• Performs other related work as needed.

Minimum Qualifications

• Education: Minimum requirements include a college or university degree in related field.
• Work Experience: Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.
• Certifications: ---

Preferred Qualifications

• Education: Bachelor’s degree in computer science, information systems, data science, engineering, business analytics, healthcare analytics, or a related analytical or STEM field strongly preferred.
• Experience: 2-5 years of professional experience in data engineering, analytics engineering, business intelligence, healthcare analytics, or related technical roles strongly preferred.
• Demonstrated experience writing optimized SQL queries, stored procedures, and data transformation logic strongly preferred.
• Demonstrated experience working with large and complex datasets across multiple enterprise systems strongly preferred.
• Experience supporting analytics reporting, automated workflows, or ETL/data integration processes strongly preferred.

Preferred Competencies

• Proficient in Microsoft SQL, business analytics and reporting tools such as Power BI and Tableau, and ETL tools such as Microsoft Integration Services.
• Familiar with data warehousing concepts, such as Kimballs' techniques regarding dimensional modeling.
• Demonstrated ability to communicate effectively with both technical and non-technical stakeholders.
• Ability to manage multiple projects and priorities in a fast-paced and evolving environment.
• Ability to handle sensitive and confidential information in accordance with organizational privacy and security standards.
• Strong verbal, written, and interpersonal communication skills.

Working Conditions

Office Environment.

Job Family Information

• Technology Role Impact: Individual Contributor
• Scheduled Weekly Hours: 40
• Drug Test Required: No
• Health Screen Required: No
• Motor Vehicle Record Inquiry Required: No
• Pay Rate Type: Salary
• FLSA Status: Exempt
• Pay Range: $70,000.00 - $110,000.00
• The included pay rate or range represents the University’s good faith estimate of the possible compensation offer for this role at the time of posting.
• Benefits Eligible: Yes
• The University of Chicago offers a wide range of benefits programs and resources for eligible employees, including health, retirement, and paid time off. Information about the benefit offerings can be found in the Benefits Guidebook.

Posting Statement

The University of Chicago is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, or expression, national or ethnic origin, shared ancestry, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.

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. 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.

Annual Security & Fire Safety Report

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.

About the University

The University of Chicago is an urban research university that has driven new ways of thinking since 1890. Our commitment to free and open inquiry draws inspired scholars to our global campuses, where ideas are born that challenge and change the world. We empower individuals to challenge conventional thinking in pursuit of original ideas. Students in the College develop critical, analytic, and writing skills in our rigorous, interdisciplinary core curriculum. Through graduate programs, students test their ideas with UChicago scholars, and become the next generation of leaders in academia, industry, nonprofits, and government.

To learn more about the university click here http://www.uchicago.edu/