Reporting Analyst

Chicago, United States | Posted on 02/09/2026

Chicago (Loop) with ability to work remotely part of each week

Shared Services — Information Services

Vice President of Information Services

Exempt

• Design and maintain data views needed for requested reports.
• Assist power users with utilization of data views to produce their own ad-hoc reports.
• Build and maintain advanced reports as requested by end-users.
• Create and monitor extract/transform/load processes used in database population and application integrations.
• Document all data structures, relationships, and attributes in organizational data dictionaries.
• Identify and report data integrity issues across data sources to promote ongoing data quality.
• Assist Information Services staff with making data visualizations available on other platforms such as the organization’s intranet.
• Utilize the department ticketing system to obtain position-related end-user support requests, and work with the users to resolve their issues.
• Perform other duties as assigned.

• Intermediate knowledge of MS Power BI.
• Excellent structured query language skills.
• Ability to create and maintain basic ETL scripts.
• Working knowledge of MS SQL Server management studio environment.
• Ability to create thorough documentation for maintenance and end-user training.
• Advanced knowledge of MS Excel and various delimited text file formats for data movement.
• Demonstrates a collaborative spirit and values team goals above personal contributions.
• Ability to be self-motivated for constant improvement/optimization of existing processes.
• Demonstrates passion for showcasing advanced capabilities of existing tools.
• Ability to perform the role with the utmost integrity including maintaining the privacy and protection of institutional data.
• Excellent verbal and written communication skills, and comfortable communicating in-person as well as through video conferencing.

• Experience using Power BI to design high impact visualizations on board-level reports.
• Knowledge of SharePoint integrations with Power BI.
• Advanced knowledge of MS SQL Server table/query optimization and complex ETL scripting.
• Experience with accessing data from a variety of cloud hosted applications.
• Knowledge of reporting tool utilization in an MS Azure environment.
• Industry or role-related certifications.
• Prior experience working in health care or academic settings.

• Prolonged periods of sitting at a desk and working on a computer.

• Bachelor’s Degree in Computer Science, Business, Management or other related fields, or equivalent work experience preferred.
• 2 years of work experience performing similar duties.