Skip to main content

Business Intelligence Specialist

Job Description

TITLE: Business Intelligence Specialist

JOB CODE: 9842



EEO6 CODE: 5 = Technical/Para Professional

GRADE: Pay Grade 10

PAY PLAN: Annually
minimum 35,040.00
midpoint 45,204.00
maximum 55,368.00

PURPOSE: Work with multiple IT teams and the university departments to develop, maintain, and enhance reports and the reporting environment. Responsible for designing, developing, and supporting the reporting environment and serving as a hands-on report developer.

DUTIES AND RESPONSIBILITIES: Design (data mapping) and create reports and cubes (using Oracle Discoverer and PeopleSoft Tools) for business users. Interact with the user community to gather and document business requirements, conduct process analysis, and draft conceptual design. Work with users and other IT members on a routine basis to troubleshoot reported problems pertaining to the reports and the reporting database environment. Identify the cause, design or develop an approach for resolution. Upon approval, implement the correction to meet user specific needs. Assist the reports team in designing and maintaining the infrastructure for the reporting environment, including ETL processing, metadata maintenance, and data validation. Assist in the design and implementation of new Oracle tables in the reporting database. Provide user assistance and direction for ad hoc data reporting. Assist with testing, evaluation and implementation of new or upgraded software. Assist with training campus users on tools, and in the use of tools. Ability to design, code, test and install complex reports/queries based on technical specifications. Assess the impact of PeopleSoft updates on the reporting database and provide proposals for applying them effectively. Work on multiple projects with competing deadlines requiring strong attention to detail and analytics. Perform other duties as required.

REPORTING RELATIONSHIPS: REPORTS TO: General supervision from Business Intelligence Manager SUPERVISION: N/A SUPERVISION-OTHER: None


REQUIRED EDUCATION-OTHER: Bachelor's degree in Computing or Information Systems or related field.

REQUIRED EXPERIENCE / COMPETENCIES-OTHER: REQUIRED EXPERIENCES/COMPETENCIES: Six months experience in a combination of the following: relational database, client-server concepts, and SQL Plus (or RDBMS tools) and experience with, or knowledge of, BI tools (Oracle Discoverer preferred) and OLAP development and experience with, or knowledge of, ETL tools (Cognos DecisionStream preferred). Understanding of all phases of the application development lifecycle. Ability to analyze ERDs. Strong MS Office skills (Word, Excel). Certifications in supported technologies . Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills. Ability to work well with people in all levels of the organization. OTHER REQUIREMENTS: Use of standard office equipment , personal computer, and Microsoft office. Extremely accurate in record keeping and in all phases of work. General office conditions. Specific job requirements or physical location of positions allocated to this classification render the position security sensitive and thereby subject to the provisions of Section 51.215 Texas Education Code.