APU is seeking employees who desire to engage in our thriving culture by cultivating community through professional interactions, demonstrating a posture of lifelong learning, and modeling Christ-like character. Working together, employees at APU commit to establishing a university atmosphere that is pleasing to God and edifying to one another.

The Sr. Business Systems Analyst, Business Intelligence (BSA) is primarily responsible for leading the Business Intelligence (BI) product area for the Enrollment Technology Solutions team (ETS) in Enrollment. The BSA will enhance and facilitate technology innovation and efficiency improvement, and will serve as the technology lead in their product area for Enrollment. As part of the overall federated IT model, the BSA will work closely with the Platform Product Manager in Information Media Technology (IMT) to leverage and extend the platform for Enrollment’s needs. The BSA will also be responsible for developing effective reports and dashboards to help drive strategic university decision making, including extracting and visually organizing data from enterprise software for use by Enrollment leadership. This position will help provide technical support for the Enterprise Data Warehouse (EDW), and contribute to the design of Dimensional Data Models and Extract Transform Load (ETL) for the BI program. This position requires technical and analytical skill, high functional knowledge, communication, coordination, leadership, and innovation.

The BSA will work closely with functional teams and executive Enrollment leadership to gather requirements and translate them into effective BI solutions. These solutions include creation or modification of reports, scorecards, dashboards, or additional data models from the EDW and other enterprise software.  This position must have a strong working knowledge of data structures and business processes for enrollment areas such as Admissions, Registrar, Financial Aid, and Student Financials. The BSA must have robust operational reporting experience, including building effective measures toward goals, productivity, and efficiency. 

As the lead for the BI product area in Enrollment, the BSA must have the ability to train and mentor others in the data reporting areas of the organization. This position must also help drive strategic direction in data reporting and analytics, including advocating for technology innovation and process efficiencies. The BSA must be familiar with the construction of data standards, including data dictionaries, data mapping, and quality management while advocating for their adoption throughout the organization.

This role requires good leadership acumen, excellent problem solving skills, a strong ability to learn, and the ability to adapt to shifting requirements. The person in this position must be able to coordinate and marshal resources from multiple areas to help deliver effective BI solutions.

REQUIRED EDUCATION

• Bachelor's degree, preferably in Business Administration, Business Systems, Computer Information Systems, Mathematics, Engineering, or similar.
• Master’s degree in Business Administration, Computer Information Systems, Engineering or similar, or equivalent experience preferred.

REQUIRED EXPERIENCE

• Working knowledge in projects involving data mining, data visualization, reporting, and dashboards is required.
• 5-9 years of experience with the following:
  • Database reporting with student information systems or related database reporting. PS Query and BI Publisher preferred.
  • Experience in an enrollment management ERP environment, preferably in PeopleSoft Campus Solutions
  • Business intelligence models and data visualization tools, e.g., Tableau, Domo, Power BI, or PS Query, BI Publisher, or similar.
  • Data mining tools. Rapid Miner or Oracle Data Miner preferred. (2-5 years preferred)
  • Business Intelligence/Database Warehouse Architect in combination with database analysis or other relevant, equivalent work experience.
  • Strong experience with designing, developing, and maintaining best ETL implementations from business requirements.
• Experience with IDEs such as Oracle SQL Developer, Aqua Data Studio, or similar.
• Experience leading teams without a direct line of authority.
• Strong customer service experience with an emphasis on customer satisfaction.
• Experience with incident, configuration and change management.
• Experience with programming languages such as VBScript, Java, or Python a plus.
• Experience in an Agile development environment preferred.

PRIMARY DUTIES/ESSENTIAL FUNCTIONS

• Provides technical leadership within BI product area for Enrollment to establish reporting and analytic requirements.
• Drives continuous improvement, change management, and other disciplines to promote innovation for product area in Enrollment.
• Designs and develops queries, reports, presentations, scorecards, and dashboards that meet customer and institutional requirements.
• Responds to customer requests for ad-hoc reporting, including developing custom reports, queries, and tools, as needed.
• Designs and develops ETL processes.
• Supports data profiling and mapping exercises to support the design and development of efficient ETL.
• Creates business intelligence tools and reports, such as physical data models and dimensional analyses.
• Designs, codes, tests, and aggregates results from SQL queries to provide information to users.
• Participates in the design, development, and analysis of data architecture and warehousing approaches.
• Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team.
• Develops prototype views and reports of the data, and works with business users, both internal and external, to obtain and refine their requirements.
• Collaborates and works with cross functional IT and business teams.
• Creates efficient and well-designed data models that meet business requirements.
• Documents and maintains report and term definitions.
• Helps area data teams with the process of building and maintaining reporting tools and dashboards for Enrollment.
• Performs data analysis, business process capture, and database design activities in collaboration with data analysts, functional users and area resources.
• Serves as internal consultant to functional users in relation to system capability, extraction, and manipulation of decision-making information.
• Works closely with data analysts and IMT staff in diagnosing system-related problems and in documenting support for business intelligence applications.
• Works closely with the Executive Director and other area leadership to understand business needs, optimize business processes and systems configuration, and prioritize work in the product area.
• Cooperates with other partnering areas on campus to ensure best data practices, including furthering of effective data standards, data dictionaries, data mapping, and quality management and advocates for their adoption throughout the organization.
• Adheres to university-wide methodologies for change management, work management, and project management.
• In conjunction with Executive Director, IMT, and other enrollment areas, helps develop and prioritize product area-based backlog.
• Provides feedback to department management regarding potential projects and initiatives within BI product area.
• Facilitates, provides, and arranges training and knowledge transfer within BI product area, including training on new business tools.
• Supports design of dimensional data models to build up available data within the Enterprise Data Warehouse.
• 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.

SKILLS

• Strong ability to lead and manage implementations.
• Excellent communication, collaboration, and leadership skills.
• Effective team building skills and a team player.
• Ability to work successfully in a team environment and possess flexibility and adaptability with changing priorities.
• Very high-level of expertise with software development using PL/SQL, drill down reports, and query optimization knowledge.
• Strong understanding of normalized Relational Database Management Systems (RDBMS).
• Highly proficient with report and dashboard development tools such as SQL Developer, Tableau, PS Query, BI Publisher, or other similar tools.
• Strong knowledge of data structures, schemas, and business processes for enrollment areas such as Admissions, Registrar, Financial Aid, and Student Financials
• Ability to prioritize, organize and manage multiple tasks and projects at once in a deadline oriented environment.
• Ability to identify, analyze, troubleshoot and solve complex technical and functional problems.
• Ability to learn new technical skills quickly and identify resources to assist in that learning.
• Ability to work efficiently in designing and implementing technical solutions.
• Ability to translate end-user needs into functional designs.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Strong customer service focus is required.
• Ability to manage details and follow through. 
• Knowledge of Enterprise Data Warehouse tools.
• Certified Scrum Product Owner a plus.
• Familiarity with Predictive Analytics and Data mining preferred.
• Knowledge of IT systems in general and experience troubleshooting basic client issues.
• Oracle Advanced PL/SQL Developer Certified Professional a plus.
• A solid knowledge of OLAP and MDX is preferred.
• Oracle PL/SQL Developer Certified Associate preferred.
• Knowledge of MuleSoft is preferred.
• Strong knowledge of software development.

MENTAL DEMANDS

• In agreement with the purpose and goals of Azusa Pacific University in providing a Christian-based higher education for its students.
• Ability to read, analyze and learn from complex and lengthy technical documents, including text, diagrams and flowcharts, demonstrating application expertise.
• Ability to design and support solutions by combining relevant knowledge and experience to create new and extended functionality to ensure applications meet business needs and technical requirements.

PHYSICAL DEMANDS

• Requires repetitive motion and sitting at computer keyboard.
• Hearing and speaking on the telephone.
• Meetings may require walking and/or driving to various University locations.
• Ability to pull, push, bend, grasp, reach and lift up to 20 lbs.
• Must be able to climb stairs multiple times in a work day.

VISUAL DEMANDS

• Computer monitor and reading.

ENVIRONMENT

• Pleasant office setting, comfortable temperature.

TECHNOLOGIES

The following technologies are typical of the context within which the BSA will work, though this is not intended to be an exhaustive list.

• BI tools such as Oracle Business Intelligence, Tableau
• Oracle PeopleSoft for Higher Education (Campus Solutions, HCM, Finance)
• Salesforce
• Reporting tools such as PS Query, BI Publisher, etc.
• PeopleTools 8.4 and higher.
• IDEs such as Oracle SQL Developer, Aqua Data Studio, etc.
• Oracle Database
• Google G Suite (Google Apps), Microsoft Office, Word, and Excel
• Data mining and analytics tools such as Rapid Miner or Oracle Data Miner

COMPENSATION

• Grade 14: $35.44 - $46.08/hour

Azusa Pacific University is a Christ-centered, multicultural community that values and seeks faculty and staff who are committed to diversity, work effectively with diverse populations, and engage others in ways that honor our rich cultural mosaic and biblical foundation. 

Click below to discover some of the many benefits APU employees enjoy including competitive health care options and a generous tuition discount.

http://www.apu.edu/humanresources/benefits/ 

You can learn more about APU by watching the stories of faculty, staff, and alumni as they carry out our mission here: http://www.apu.edu/stories/

_ _

Azusa Pacific University will conduct a background check on all final candidates.

Review of applications will begin immediately, and the position will remain open until filled unless otherwise stated. Azusa Pacific University does not discriminate on the basis of race, color, national origin, sex, age, disability, or status as a veteran in any of its policies, practices, or procedures. Women and minorities are encouraged to apply.

Required Skills Required Experience