Business Intelligence Associate
The University of Illinois Chicago College of Dentistry is seeking a Business Intelligence Associate to support their Info Tech Services department. The role involves developing, modifying, and testing reports and dashboards while serving as a subject matter expert in business intelligence tools and applications. Responsibilities Build reports, dashboards, metrics, and self-service reporting capabilities that support UI Health business intelligence initiatives Collaborate with clinical application analysts and operational subject matter experts to design, test, and validate business intelligence content Write optimized SQL queries and extracts with respect to performance to pull data from various business intelligence data sources Create ad-hoc SQL queries to review data, determine requirements, and resolve data errors Deliver data, reports, metrics, and dashboards through utilization of tools in the business intelligence suite of applications Assess impact of healthcare application software upgrades on business intelligence content and implement necessary updates and changes to coincide with upgrade timelines Maintain business intelligence catalog of content Adhere to defined style guidelines when developing custom reports and dashboards Participate in the development and maintenance of training content as part of the business intelligence training program Utilize ITSM application and defined ITIL processes to fulfill requests, resolve incidents, and submit requests for change Perform other related duties and participate in special projects as assigned Skills Bachelor Degree - Computer Science, Engineering, Information Systems Management, related information management field or a clinical area of study Minimum of one (1) year professional level IT experience within Data Analytics & Integration which includes demonstrated experience in designing, implementing, and supporting clinical application interfaces, as well as developing, modifying, distributing, and testing reports, metrics, dashboards, and self-service reporting capabilities in the business intelligence suite of tools and applications Working knowledge of business intelligence tools and applications which may include SAP Business Objects, Crystal Reports, Tableau, or Microsoft SQL Server Integration Services, as well as electronic health records applications, such as Epic Knowledge of system management principles, business intelligence development and testing strategies, and data warehousing concepts such as relational models, star and snow flake schemas, indexing, partitioning, and ETL Strong analytical, interpersonal, and communications skills Demonstrated ability to multi-task, meet commitments, and balance work demands Benefits Health Dental Vision Life Insurance A Retirement Plan Paid time Off Tuition waivers for employees and dependents Company Overview The University of Illinois at Chicago College of Dentistry is a worldwide leader in oral health education, clinical care and research that is patient-centered and evidence-based, with a foundation in preventive and public health sciences. It was founded in 1913, and is headquartered in Chicago, Illinois, USA, with a workforce of 201-500 employees. Its website is Company H1B Sponsorship University of Illinois Chicago College of Dentistry has a track record of offering H1B sponsorships, with 2 in 2024, 1 in 2023, 3 in 2021. Please note that this does not guarantee sponsorship for this specific role.