APU seeks employees who desire to contribute to 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 edifying to God and one another.
The Senior Data Analyst is a part-time expert role that supports the Universitys advanced reporting data analytics and complex problem-solving within the PeopleSoft ecosystem for up to 20 hours per week. This position provides high-level technical insight and hands-on development for analytics needs across HR Finance and other related operational areas.
The role is designed for an individual who can step into shifting priorities quickly understand the dynamic reporting needs of the business and deliver fast and accurate analytical solutions. This includes deep knowledge of PeopleSoft data structures strong mathematical reasoning optimization of large datasets and high-end scripting for PeopleSoft Portal development. Strategic thinking is essential. Prior experience with APUs data historical business rules and existing reporting patterns is critical to ensure accuracy and continuity.
This position supplements the full-time team by providing senior-level expertise that accelerates delivery and bridges specialized knowledge gaps. This position is part-time averaging 20 hours per week.
Required Education
- Bachelors degree in Mathematics Computer Science Information Systems Software Engineering or closely related field.
Required Experience
- Five to seven years of experience in analytics data engineering mathematical modeling or advanced reporting.
- Expert-level SQL with demonstrated experience tuning complex queries and working with very large datasets.
- Proven hands-on expert-level experience with PeopleSoft HCM Financials or Campus Solutions.
- Proven ability to build dashboards datasets and reporting tools with accuracy and clarity.
- Experience converting business needs into technical requirements that can be developed quickly.
- Ability to work independently and execute under limited hours while still delivering at a high level.
- Prior experience in higher education environments.
- Prior work with HR Finance or Student Systems data.
- Experience mentoring others in SQL data modeling & analytics or business intelligence.
- Familiarity with higher-ed systems and historical reporting logic.
Primary Duties/Essential Functions
- Serve as the senior SME for PeopleSoft reporting analytics and data structures.
- Build tune and maintain SQL queries views and data models used for enterprise reporting.
- Develop Insights dashboards Pivot Grids BI Publisher reports and custom datasets.
- Identify data gaps isolate root causes and recommend options for correction.
- Support high-end scripting and portal programming when needed for reporting or automation.
- Translate business questions into clear analytical outputs.
- Provide quick-turn solutions for complex reporting issues and data discrepancies.
- Advise on best practices for data architecture analytics workflows and long-term reporting needs.
- Support validation testing and rollout of new reporting tools.
- Provide analytics support for strategic university initiatives.
- Mentor COE staff in SQL practices optimization and data modeling.
- Other duties as assigned.
Skills
- Expert SQL including performance tuning and working with large and complex datasets.
- Expert knowledge of PeopleSoft table structures keys trees SetID rules and cross-module dependencies.
- Ability to design dashboards metrics and reporting models from concept to delivery.
- Strong analytical thinking with high attention to detail.
- Ability to diagnose issues quickly and recommend efficient solutions.
- Experience with analytics tools such as HighCharts Insights BI Publisher or Pivot Grids.
- Clear and direct communication with the ability to explain complex logic in simple terms.
- Strong prioritization and self-management skills in a low-hour high-output environment.
Mental Demands
- Strong analytical reasoning for complex problem solving.
- Highly self-directed with the ability to manage shifting priorities.
- Strong service orientation and respect for internal customers.
- High personal accountability and reliability with limited oversight.
- Aligned with APUs mission and values.
- Supportive of APUs Christian foundations and the 4 Cornerstones.
- Occasional evenings or weekends as needed for continuity of IT services.
Physical Demands
- Repetitive hand motions from computer work.
- Sitting or standing for long periods while working at a computer.
- Regular use of phone and video conferencing.
Visual Demands
- Reading from screens dashboards and technical documents.
Environment
- Primarily virtual.
- May involve occasional on-campus meetings.
- Work may require focus during multiple simultaneous requests or tight deadlines.
Technologies
- Oracle SQL / PL-SQL.
- PeopleSoft HCM Financials Campus Solutions.
- PeopleSoft Query Pivot Grids BI Publisher Insights.
- PeopleSoft Trees Table structures SetID logic.
- PeopleSoft Portal and scripting tools (Lucee JavaScript Python PowerShell).
- Data visualization tools (Insights Tableau Power BI).
- Version control.
- Report scheduling tools (Job automation and scripting PeopleSoft Process Scheduler).
- Advanced Excel (Power Query V&XLOOKUP Pivot Tables).
- Jira and documentation tools.
Compensation
- Grade 13: $32.97 to $37.92 is the hourly compensation for this role and reflects what Azusa Pacific University reasonably expects to pay for this position. Actual compensation may vary based on the qualifications experience and internal addition to compensation APU offers a competitive benefits package.
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. Please click the links to learn more aboutwhat we believe ourmission statement and our statement of faith.
You can learn more about APU by watching the stories of faculty staff and alumni as they carry out our mission here: 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.