Skip to main content

Senior Business Intelligence Analyst

Job Description

TITLE: Senior Business Intelligence Analyst

JOB CODE: 9844



EEO6 CODE: 5 = Technical/Para Professional

GRADE: Pay Grade 14

PAY PLAN: Annually
minimum 53,196.00
midpoint 70,752.00
maximum 88,308.00

PURPOSE: Works 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: Interact with the user community to gather and document business requirements, conduct process analysis, and draft conceptual design. Provide leadership to the reports team in designing and maintaining the infrastructure for the project, including ETL processing, metadata maintenance, and data validation. Design and implement new Oracle tables and fields in the reporting database. Plan, design (data mapping), and create reports and cubes (using Oracle Discoverer and PeopleSoft Tools) for business users. Provide user assistance and direction for ad hoc data reporting. 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. Test, evaluate, and implement new or upgraded software. Assist with training campus users on tools, and in the using tools. 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. Provide technical direction to less experienced team members. 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 the Business Intelligence Manager SUPERVISION: N/A SUPERVISION-OTHER: None


REQUIRED EDUCATION-OTHER: BS in Computer Science or related field.

REQUIRED EXPERIENCE / COMPETENCIES-OTHER: REQUIRED EXPERIENCES/COMPETENCIES: Eight+ years of systems design, analysis, and programming experience in a combination of (experience may run concurrently) 5+ years experience with relational database, client-server concepts, and SQL Plus (or Oracle 9i/10g tools) and/or 4+ years experience with BI tools (Oracle Discoverer preferred) and OLAP development and/or 2+ years experience with ETL tools (Cognos DecisionStream preferred). Ability to create and analyze ERDs. Strong understanding of all phases of the application development lifecycle and project management disciplines. Strong MS Office skills (Word, Excel). Experience with PeopleSoft Application Campus Solutions preferred (version 8.x+) 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 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.