The Senior Business Intelligence Analyst (SBIA) is a core team member of the Business Intelligence team. This position will focus on developing reports and dashboards, providing technical support for the Enterprise Data Warehouse, and will contribute to the design of Dimensional Data Models and ETL (Extract Transform Load) in support of the Business Intelligence program. The SBIA is a highly interactive role requiring a combination of technical skill, communication, and innovation in order to successfully deliver Business Intelligence solutions to the University.
The SBIA role will require highly developed problem solving skills, programming knowledge and the ability to quickly adapt to changing requirements. The individual in the position needs to be comfortable dealing with ambiguity, complexity, and technical problems.
Bachelor's degree or equivalent experience is required. Preferred majors include Business Administration, Business Systems, Computer Information Systems, Management Information Systems or similar.
3-5 years of relevant experience with BI tools, report development and dashboard design and development, preferably in a higher education setting.
Understanding and working experience with the star schema data model design methodology.
Experience working with enterprise reporting tools.
Advanced SQL experience in an Oracle Server environment preferred.
Familiar with programming languages Java, Python, VBscript etc.
Knowledge of IT systems in general and experience troubleshooting basic client and network issues.
Ability to interpret a complex variety of technical instructions and deal with several abstract and concrete variables.
Self-starter, ability to work independently, and ability to work with a diverse set of stakeholders.
Demonstrated time management and priority setting skills.
Primary Duties/Essential Functions
Participate in the design of star schemas and dimensional data models to build up available data within the Enterprise Data Warehouse.
Conduct data profiling and mapping exercises to support the design and development of efficient ETL.
Design & develop reports and dashboards that meet customer and institutional requirements.
Document and maintain report and term definitions.
Develop and maintain training materials, how-to guides, and other related information to help inform and educate the University on what BI can provide and how to take advantage of the capability.
Perform data analysis, business process capture, and database design activities in collaboration with Data Analysts, functional users and other IMT resources.
Develop and recommend policies and procedures designed to increase end user accuracy, efficiency, and effectiveness of systems to functional users and managers.
Work closely with analysts and other IMT staff in diagnosing systems-related problems and in documenting support for business intelligence applications.
Respond to customer requests for ad-hoc reporting, including developing custom reports and queries as needed and assisting Data Analysts with their reporting efforts.
Experience with Business Intelligence and Enterprise Data Warehouse tools, Oracle Data Integrator a plus.
Experience with creating and maintaining best ETL implementations from business requirements
Basic understanding Relational Database Management System (RDBMS).
Proficient with the use of MS Office products: Word, Excel, Visio and PPT.
Proficient with report and dashboard development tools such as SQL Developer, Tableau, PSQuery, XML Publisher, or other similar tools.
Basic Understanding of Java, Python, Groovy or similar coding languages
Ability to understand technical documentation and systems architecture.
Familiar with ITIL, incident, change and project management processes.
Proficient in the development of documentation for systems and functional processes.
Ability to learn quickly and develop expertise with applications, tools and systems in use at APU.
Excellent written and verbal communication skills.
Ability to work successfully in a team environment and possess the flexibility and adaptability to changing requirements is required.
Ability to maintain harmonious work relationships with staff, students, faculty and University officials and the general public. Must be collaborative and an effective team member and team builder.
Intermittent sitting, standing and walking.
Ability to sit for extended periods of time.
Hearing and speaking in person and on the telephone.
Ability to lift, pull, grasp, reach, and stoop.
Repetitive wrist/finger motions with use of a computer.
Computer usage for extended periods of time.
Ability to conduct business at other offices on campus.
Ability to lift up to 20lbs occasionally.
BI Analytics tools such as Oracle Business Intelligence and Tableau
ETL Tools such as Oracle Data Integrator
Oracle/PeopleSoft for Higher Education (Campus Solutions, HCM, Finance)
PeopleTools 8.4 and higher.
Integration technologies, XML and Web Services
Reporting tools such as SQL, PS Query, etc.
Microsoft Office and/or Google Docs
Microsoft Outlook and/or GMail
Azusa Pacific University is acting as an Employment Agency in relation to this vacancy.
Azusa Pacific University is a comprehensive, evangelical, Christian university located 26 miles northeast of Los Angeles, California. A leader in the Council of Christian Colleges and Universities, APU is committed to excellence in higher education. Offering more than 100 bachelor's, master's, and doctoral programs on campus, online, and at seven regional centers across Southern California, APU continues to be recognized annually as one of America's Best Colleges by U.S. News & World Report.