New

Database Analyst - School of Public Health Information Technology

University of Illinois Chicago
United States, Illinois, Chicago
Feb 21, 2025
Database Analyst - School of Public Health Information Technology Database Analyst - School of Public Health Information Technology Hiring Department: School of Public Health Information Technology Location: Chicago, IL USA Requisition ID: 1030978 FTE: 1 Work Schedule: Monday - Friday 9:00 am - 5:00 pm Shift: Days # of Positions: 1 Workplace Type: Hybrid Posting Close Date: 3/6/2025 Salary Range (commensurate with experience): $75,000.00 - 80,000.00 / Annual Salary About the University of Illinois Chicago UIC is among the nation's preeminent urban public research universities, a Carnegie RU/VH research institution, and the largest university in Chicago. UIC serves over 34,000 students, comprising one of the most diverse student bodies in the nation and is designated as a Minority Serving Institution (MSI), an Asian American and Native American Pacific Islander Serving Institution (AANAPSI) and a Hispanic Serving Institution (HSI). Through its 16 colleges, UIC produces nationally and internationally recognized multidisciplinary academic programs in concert with civic, corporate and community partners worldwide, including a full complement of health sciences colleges. By emphasizing cutting-edge and transformational research along with a commitment to the success of all students, UIC embodies the dynamic, vibrant and engaged urban university. Recent "Best Colleges" rankings published by U.S. News & World Report, found UIC climbed up in its rankings among top public schools in the nation and among all national universities. UIC has nearly 260,000 alumni, and is one of the largest employers in the city of Chicago. Benefits eligible positions include a comprehensive benefits package which offers: Health, Dental, Vision, Life, Disability & AD&D insurance; a defined benefit pension plan; paid leaves such as Vacation, Holiday and Sick; tuition waivers for employees and dependents. Click for a complete list of Employee Benefits. UIC is seeking a Database Analyst to join our School of Public Health Information Technology team. This role will work closely with the Lead Data and Application Analyst in the Information Technology Department of the School of Public Health, the Database Analyst is responsible for the management of administrative databases used within the School. Develops internal data systems to support the integration of data collection, reporting, and analytics within the School. Responsible for implementation and monitoring of data quality and security. Provides reporting on data management and quality issues and concerns. Provides .NET programming support when necessary. Duties & Responsibilities: Provide customers data-driven output based on their requests. Work with stakeholders to ensure data requirements are feasible and to further understand business objectives. Analyze functional and performance issues, collaborate with peers on possible solutions and implement corrective actions in a timely manner. Act as a technical and institutional resource on the best practices and use of software, strategy, and tools to design and implement enterprise systems scalable client solutions. Analyze, design, create, implement and maintain databases for use within the School of Public Health. Perform data analysis/visualization to answer the business questions using appropriate tool. Partner with key stakeholders to understand their unique requirements and leads the development of key architecture development and solutions. Works with user departments to implement solutions utilizing C# and .NET Framework coding languages. Utilize SQL Server Integration Systems (SSIS) to extract data from data sources. Dynamically connect the front-end web/application to third-party applications such as Banner, Electronic Data Warehouses, and authentication systems such as Shibboleth, BlueStem, LDAP, Computer Associates' SiteMinder, and Insight Symplicity. Create proper documentation and run a log of all system builds and processes. Complete individual projects and tasks assigned by supervisor on time with quality. Provide supervision and support to the student IT staff to triage, prioritize, and respond to IT web development. Actively seek out relationships with customer community by seeing out other analysts in their field, proactively communicating relevant information and discussing their needs, initiatives, and service levels through periodic meetings. Provide updates on a regular basis to team on status of projects or tasks assigned. Manage expectations of customers to resolve customer satisfaction issues. Research and recommend new approaches, methodologies, tools, techniques and guidelines for building data information systems within SPH. Participate in planning, developing and implementing cloud strategy. Collaborate with security administrators to secure cloud infrastructure. Understand, design, and deploy cloud services based on application needs. Partner with other Technology Team members on complex problems and strategic initiatives. Perform other related duties and participate in special projects as assigned. Minimum Qualifications Required: Bachelor Degree within Computer Science or closely related field of study Minimum 1 years of professional IT experience within Database Design and Administration which includes demonstrated experience in the design, creation and implementation of databases, including data models, logical and physical databases, data dictionaries and schemas, validation checks and data security. Preferred Qualifications: Working understanding of SQL Data Analysis Services, SQL Reporting Services, and SharePoint content management environment, C#, .NET Framework. Demonstrated experience designing, developing, maintaining, and administering databases via SQL Server Management and Oracle Enterprise Manager; demonstrated experience using reporting tools to generate end-user reports using SQL. Provide administration and maintenance for MS SQL Server. Connect .NET Framework-based applications to databases. Knowledge of data warehousing environments including Business Intelligence reporting. Applications front end public facing sites and WordPress development competence. An extensive understanding of .NET Framework. Problem analysis; project management; entity-relationship modelling. Stored procedures (sproc), complex queries, correlated/nested sub-queries, and derived tables. Ability to develop programs and reports using SQL in a .Net environment and Oracle in Database Management; Ability to handle confidential information with appropriate discretion; The ability to code and debug issues for plausible solutions. Strong organizational and time management skills; ability to manage multiple projects under tight deadlines; ability to work with a diverse user community with varying levels of experience related to data management. To Apply: For fullest consideration click on the Apply Now button, please fully complete all sections of the online application including adding your full work history with specific details of your duties & responsibilities for each position held. Fully complete the education, licensure, certification and language sections. You may upload a resume, cover letter, certifications, licensures, transcripts and diplomas within the application. Please note that once you have submitted your application you will not be able to make any changes. In order to revise your application you must withdraw and reapply. You will not be able to reapply after the posting close date. Please ensure the application is fully completed and all supporting documents have been uploaded before the posting close date. Illinois Residency is required within 180 days of employment. The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit Required Employment Notices and Posters to view our non-discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, and employment eligibility review through E-Verify. The university provides accommodations to applicants and employees. Request an Accommodation To apply, visit https://uic.csod.com/ux/ats/careersite/1/home/requisition/14362?c=uic Copyright 2024 Jobelephant.com Inc. All rights reserved. Posted by the FREE value-added recruitment advertising agency jeid-8aeeb26294088d41a34e2e9b77ff2740