The Senior Business Intelligence Analyst (SBIA) is a core team member of the Business Intelligence team. This position focuses on developing reports and dashboards, providing technical support for the Enterprise Data Warehouse, and contributes 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 is responsible for maintaining an awareness of the organizations needs for Business Intelligence, and works closely with the functional areas to gather requirements and translate the requirements into effective and actionable BI solutions. These solutions may include new or modified reports, dashboards, or the creation of additional data models within the Enterprise Data Warehouse as well as maintenance and creation of ETL jobs.
The SBIA role requires 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.
Ability to analyze requirements and transform them from a business question/requirement form to actionable solutions.
Ability to develop working specifications from vague and often changing requirements.
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.
Strong verbal and written communication skills, with an ability to clearly articulate and explain business processes and concepts.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
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.
Serve as an internal consultant to functional users in matters related to system capabilities, proficiency training, and extraction and manipulation of decision-making information.
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.
Keep immediate supervisor and designated others fully and accurately informed concerning work progress, including present and potential work problems and suggestions for new or improved ways for dealing with such problems.
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.
Adhere to IMT methodologies for documentation, change management, work management and project management.
Appropriately tailor communication content to peer, supervisory, and customer audiences.
Responsible for daily electronic timekeeping as it applies to the scope of this position.
Regular, punctual attendance as required by the supervisor based on department needs.
Performs other duties as assigned by the supervisor.
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.
Excellent analysis and problem solving skills.
Ability to work quickly and efficiently.
Ability to work successfully in a team environment.
Ability to maintain harmonious work relationships with staff, students, faculty and University officials and the general public.
The SBIA must have experience with, or be able to adapt quickly to these types of technologies.
BI Analytics tools. i.e 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.
Productivity tools such as Microsoft Office and/or Google Docs
Email tools such as 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.
BACK TO TOP
Power Platform UGs Career Center is Just One of the Benefits.
Discover what else User Group has to offer!
The job you are trying to reach from was originally posted at Power Platform UGs Career Center.