Programmer Analyst

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.

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

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

• Professional experience in a community college or higher‑education environment.

• Experience with Ellucian systems:
  Banner, Degree Works, ODS/EDW, Insights, etc.

• Familiarity with BI tools (Power BI, Tableau), scripting languages (Python), or cloud data platforms.

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.

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.

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.