Job Details

Salary: $64,875.20 - $84,344.00 Annually
Location : Remote/Online, AZ
Job Type: Full Time
Job Number: 2025-00242
Department: Institutional Research
Opening Date: 02/20/2026

Description of Position
The Programmer Analyst - Institutional Research provides advanced technical, analytical, and programming support to Yavapai College's Institutional Effectiveness & Research (IER) department. This role ensures the accuracy, integrity, and accessibility of institutional data by developing, maintaining, and optimizing data pipelines, integrations, reports, dashboards, and analytics systems used across the College.

This position plays a key role in institutional decision-support, student success initiatives, state and federal compliance reporting, accreditation support, and data quality assurance for Banner SaaS and the Ellucian Insights (ODS/EDW) environment.

This position may be fully remote, with occasional travel to Prescott, Arizona.

RESPONSIBILITIES

• Develop, maintain, and optimize SQL/PLSQL scripts, stored procedures, packages, and views to support analytics, dashboards, and operational reporting.
• Retrieve, validate, and reconcile data across Banner, SaaS data warehouse environments, third-party systems, and internal IER datasets.
• Create and maintain automated data workflows and pipelines to ensure reliable, timely data availability for institutional stakeholders.
• Develop datasets, dashboards, and analytics products for institutional leadership, student success teams, academic departments, and administrative units.
• Produce structured data files for mandatory state, federal, and accreditation reporting, including IPEDS, National Student Clearinghouse, AZ state reports, and HLC evidence documentation.
• Implement data validation routines, audits, and reconciliation methods to ensure data accuracy and consistency across systems.
• Document data definitions, logic, requirements, and technical specifications.
• Ensure adherence to institutional data governance practices, privacy laws, and data-security standards.
• Partner with academic and administrative departments to understand data needs and develop technical solutions that support planning, assessment, budgeting, and student-success initiatives.
• Provide consultation and technical assistance to end-users on data tools, dashboard navigation, and data interpretation.
• Assist with cross-functional projects, strategic planning efforts, and ad-hoc analysis requests.

Minimum Expectations & Requirements

• Bachelor's degree in Data Science, Computer Science, Information Systems, Statistics, or related field-or equivalent professional experience.
• At least four years of experience in database development/administration, data warehousing, programming, analytics, or business intelligence.
• Demonstrated expertise in SQL and PL/SQL.
• Experience working with enterprise systems (Banner preferred).
• Experience supporting compliance reporting (IPEDS, AZ state reporting, HLC, NSCH).
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience producing technical documentation and specifications.
• Ability to work independently and collaboratively, manage multiple projects, and meet deadlines.
• Strong written and verbal communication skills.
• Regular attendance is an essential job function as it demonstrates dependability towards the performance of job duties

Preferred Skills & Abilities

• Professional experience in a community college or higher-education environment.
• Experience with Ellucian systems: Banner, DegreeWorks, ODS/EDW, Insights, etc.
• Familiarity with BI tools (Power BI, Tableau), scripting languages (Python), or cloud data platforms.

Essential Functions
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements and competencies listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is frequently required to use hands to finger, handle, or feel. The employee is occasionally required to stand; walk and reach with hands and arms. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.

Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually quiet.
Yavapai College offers its full-time employees a comprehensive benefit package:

HEALTH/LIFE BENEFITS

• Medical/Dental/Vision Insurance: College's partial payment of premiums toward medical with pharmacy and/or dental plan options picked by employees for themselves (and eligible dependents)
• Flexible Spending Accounts: Pre-tax pay deductions to use for eligible medical or dependent daycare costs
• Employee Assistance Program (EAP): Counseling and referral services for employees and their immediate families for depression, stress, family/marital conflict, and alcohol/drug issues
• Vision: Provides an amount per plan year for eligible expenses such as vision exams, lenses, frames, prescription sunglasses, and contact lenses
• Life Insurance: The College provides Basic Life Insurance coverage at twice of the employee's annual salary. Dependents have automatic coverage of $2,000/spouse and $1,000/per child if enrolled in medical plan.
• Voluntary Individual And Family Term Life Insurance: Additional term life insurance coverage available for employee, spouse and children.
• Other Insurance Coverage: Short Term and Long Term Disability (replacement income insurance), and Workers' Compensation (compensation, medical expenses and death benefits for on-the-job injuries or occupational diseases)

RETIREMENT BENEFITS

• Retirement Benefits: Arizona State Retirement System or Optional Retirement Plan, and Social Security (which provides a basic retirement annuity based on age and years of contribution)
• Tax Deferred Annuities: Employees' contributions to designated tax-deferred annuities
• Unemployment Compensation: Employees who are laid off or terminated may receive benefits in covered wages meet requirements

LEAVE BENEFITS

• Vacation : 15 days of Vacation leave annually. NOTE: For employees who work an amount of contractual days, there will be no earned vacation.
• Sick Leave: 12 days sick leave annually. NOTE: Employees working less than full time or an amount of contractual days will receive a proration of sick leave.
• Personal Leave: Use of up to three personal leave days per year which are charged against accumulated sick leave to take care of items of personal business
• Other Leave: Bereavement leave, Civic Duty Leave (Jury duty, active military duty, military training), and Family Medical Leave Act (FMLA)
• Holidays: 24 days during the year as paid holidays for full-time employees which include Independence Day, Labor Day, Veteran's Day, 3 days at Thanksgiving, 10 days at Winter/year-end break, Martin Luther King Day, Spring Break, Memorial Day, and Juneteenth.

OTHER BENEFITS

• Breaking Bread: 32 meal swipes for use at the Prescott Campus Eatery. All Other Campuses and Sites receive a $140 credit each semester (fall and spring) to be used at the Open Market on campus/center
• Spanish Interpreter Incentive Program: Employees interested in additional compensation for their Spanish speaking skills agree to assist YC by attending two recruiting events and being available for Spanish Interpretation needs as they arise. Compensation is added to the employee's regular pay at the rate of $175 per month. Employees that are interested in participating let your HR Business Partner know, so they can schedule you for the ACTFL language proficiency test at the YC testing center.
• Direct Deposit: Paychecks deposited directly into the employee's bank account(s)
• Tuition Waiver: Eligible Full-time Faculty and Staff, their legally married spouse, and eligible dependents may enroll in a partial or full program of coursework without payment of tuition, exceptions may be lab fees and market-based additional fees
• Sabbatical: Faculty, professional, and administrative staff may apply for compensated leave of up to a year after six years of continuous service
• Professional Development Opportunities
• Additional Benefits and Services: Local community discounts to faculty and staff, computer loan program, mail and notary service.