Other
Azusa, CA
- ID : S876
- Full-Time / Regular
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 University’s 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 APU’s 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
Bachelor’s 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 APU’s mission and values.Supportive of APU’s 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 equity. In addition to compensation, APU offers a competitive .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 about , our ', and our ''.
You can learn more about APU by watching the stories of faculty, staff, and alumni as they carry out our mission here : .
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.