Senior Data Analyst (Part-Time) - Information Technology

Join our team of difference makers • Azusa, CA

6d • $33 - $38

About The Position

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.

Requirements

• Bachelor’s degree in Mathematics, Computer Science, Information Systems, Software Engineering, or closely related field.
• 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.
• 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.
• 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.
• Repetitive hand motions from computer work.
• Sitting or standing for long periods while working at a computer.
• Regular use of phone and video conferencing.
• Reading from screens, dashboards, and technical documents.
• 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.

Responsibilities

• 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.

What This Job Offers

• Job Type: Part-time
• Career Level: Mid Level