The University System Office seeks a Business Intelligence Technical Analyst to provide support for the business intelligence (BI) architecture of Decision Support including the technical infrastructure of the Enterprise Data Warehouse (EDW), BI applications, and related systems environment. This position maintains BI systems, operational reliability, capacity planning, disaster recovery mechanisms, and plans for future BI delivery.
The University of Illinois is an Equal Opportunity, Affirmative Action employer that recruits and hires qualified candidates without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability or veteran status. For more information, visit http://go.illinois.edu/EEO.
Additional responsibilities include:
Administer applications providing Business Intelligence (BI) services (e.g. Business Objects, Tableau, Microsoft Analysis Services, etc.). This responsibility involves design and configuration of the software, overall management of the application and working with staff involved in daily operations with the software. This also includes supporting research and evaluation activities related to new technologies to support data storage, analytics and business intelligence.
Design, manage, and monitor security design processes related to the security of Data Warehouse and Business Intelligence security. Monitor security operations to ensure compliance with existing university and departmental security policies. Monitor security implementation to ensure continued compliance with intended access plans. Review university policies and guidelines to ensure that Decision Support security policies and procedures remain in compliance through partnership with the AITS Enterprise Systems Assurance team. Recommend changes or new policies as appropriate.
Provide operational support for university-wide systems used by students, employees, and university clients. Work with IT professionals across the University of Illinois to provide core systems integration and operational services.
Miscellaneous duties including:
Conduct research to identify opportunities for improving the BI Architecture and Decision Support product delivery focusing on new industry products, new features to existing products and industry trends with BI and data warehousing techniques.
Identify methods to collect operational metrics in support of the following: measurement of return on investment - usage analysis - and security analysis. Analyze systems and processes to identify opportunities for increased efficiency and efficacy.
Serve as principle analyst for BI Environment Management activities: Collaborate closely with the Project Management team to schedule Development, QA, and Dress Rehearsal environments- Coordinate with the AITS Database Administration team to create or refresh database environments; Design, manage, and monitor implementation processes related to testing, security, risk analysis, and quality assurance for ongoing Data Warehouse new releases; Collaborate with the DS Information Delivery team to support security and changes to existing structures during project implementation phases; Perform risk analysis, provide statistics, and report findings to the AITS Leadership Team.
Serve as subject matter expert on enterprise infrastructure components and middleware. Monitor production, test, QA, and development Business Intelligence environments. Escalate issues to the appropriate team. This includes the data warehouse and BI technology environments; Capacity planning for Business Intelligence Architecture and Decision Support products; Back-up and disaster recovery plans, procedure testing, and implementation for Business Intelligence Architecture; Business Intelligence Architecture documentation and standards; Defining and implementing Business Intelligence Architecture standards for the Decision Support environment.
Participate in committees and projects for AITS (e.g., service improvement initiatives) and/or partner organizations (e.g. Technology Services, ITS and ACCC) to meet enterprise objectives.
As needed, serve as a backup resource for the Associate Director for Operational BI & Architecture and other members of the Business Intelligence Architecture team.
Other related responsibilities as appropriate for a BI Technical Analyst
Education and Experience
Any combination totaling two (2) years from the following categories: progressively more responsible work experience in an Information Technology (IT) related profession; college course work which included Information Technology (IT), IT Management, or a closely related discipline, as measured by the following conversion table or its proportional equivalent:60 semester hours or Associate's Degree equals one (1) year, 90-120 semester hours or Bachelor's Degree equals two (2) years
Bachelor's/Master's degree in relevant area (computer science, mathematics, statistics, engineering, etc.)
Knowledge, Skills and Abilities
Two years of experience with relevant platforms (Windows Server and Oracle).
Three years of experience with software application management.
Experience with or potential to develop and understand security structures and hierarchies.
Experience with or potential to develop and understand analytic queries.
Experience with workstation and server security mechanisms.
Experience with data management and administration, preferably in data warehousing.
Experience in various business intelligence technologies (e.g. Business Objects, Tableau, Microsoft Power BI, Data Mining, Dashboards).
Experience with cloud-hosted technologies, preferably in data storage or business intelligence.
Experience in managing technology projects and standard project management techniques.
Experience with creating and implementing security plans.
Experience with large applications or systems.
Experience with large, multi-project implementations.
Experience creating and maintaining standardized procedures- experience with ETL products (Informatica).
SALARY AND APPOINTMENT INFORMATION
This is a full-time Civil Service Information Technology Technical Associate appointed on a 12 month service basis. The expected start date is as soon as possible after November 18, 2020. Salary is commensurate with experience.
APPLICATION PROCEDURES AND DEADLINE INFORMATION
Applications must be received by November 18, 2020. Apply for this position by going to http://jobs.illinois.edu. If you have not applied before, you must create your candidate profile at http://jobs.illinois.edu. If you already have a profile, you will be redirected to that existing profile via email notification. To complete the application process:
Step 1) Submit the Staff Vacancy Application.
Step 2) Submit the Voluntary Self-Identification of Disability forms.
Step 3) Upload your cover letter, resume (months and years of employment must be included), academic credentials (unofficial transcripts or diploma may be acceptable) and names/contact information for three references.
In order to be considered as a transfer candidate, you must apply for this position by going to http://jobs.illinois.edu. Applications not submitted through this website will not be considered. For further information about this specific position, contact Melissa McMullen at [email protected] For questions about the application process, please contact 217-333-2137.
The System Office conducts background checks on all job candidates upon acceptance of a contingent offer of employment. Background checks will be performed in compliance with the Fair Credit Reporting Act. The University of Illinois System requires candidates selected for hire to disclose any documented finding of sexual misconduct or sexual harassment and to authorize inquiries to current and former employers regarding findings of sexual misconduct or sexual harassment. For more information, visit https://www.hr.uillinois.edu/cms/One.aspx?portalId=4292&pageId=1411899
The University of Illinois System requires candidates selected for hire to disclose any documented finding of sexual misconduct or sexual harassment and to authorize inquiries to current and former employers regarding findings of sexual misconduct or sexual harassment. For more information, visit Policy on Consideration of Sexual Misconduct in Prior Employment