Institutional Research Analyst Programmer

The Office of Institutional Research is seeking an IR Analyst Programmer to serve as a key technical leader within the Office of Institutional Research. This role is responsible for designing and managing the office’s institutional data warehouse environment, including the analysis, design, modification, testing, installation, and maintenance of application programs, integrated systems, and database solutions. The incumbent leads the architecture and development of data warehouse structures, oversee ETL processes for efficient data integration, and ensures data integrity, performance, and usability.

This position provides expertise in Ellucian Banner and the Ellucian Operational Data Store (ODS), serving as the lead for database creation, management, and optimization to deliver reliable, accessible, and actionable data for institutional reporting and analytics.

• High School Diploma or equivalent (GED)
• 3-5 years of progressive experience in data analytics, business intelligence, or database management in a higher education environment. A minimum of five years of progressive experience is required for advanced technical skills.
• Substantial experience with Ellucian Banner and the Ellucian Operational Data Store (ODS). Demonstrated ability to extract, integrate, and model data from these systems.
• Expertise in SQL programming and experience with enterprise RDBMS (e.g., Oracle, SQL Server, or Postgre
  
  SQL). Demonstrated ability to write efficient and complex SQL queries.
• Strong knowledge of business intelligence (BI) tools such as Cognos, Power BI, or Tableau. Preferred experience utilizing Cognos Framework Manager or Power BI Dataflows.
• Proven experience in data warehouse modeling, database design, and ETL processes. Demonstrated ability to design and implement robust data solutions.
• Demonstrated ability to manage secure databases and uphold institutional data privacy standards. Knowledge of relevant data privacy regulations (e.g., FERPA).
• Developed analytical skills:
  Ability to diagnose complex data issues and derive insights.
• Effective communication skills:
  Ability to communicate complex technical information clearly to technical and non-technical stakeholders.
• Developed documentation skills. Ability to create comprehensive technical and user documentation.

Western Oregon University is a regional public, mid-sized university – committed to changing lives, strengthening communities and transforming our world. Located in Monmouth, the heart of Oregon’s lush Willamette Valley, WOU is about 20 minutes from Salem, the state’s capital and about 75 minutes from Portland, the state’s cultural hub. Western is one of Oregon’s oldest public institutions of higher education and was incorporated into the state system as a teacher training institution in 1882.

The university offers undergraduate and graduate degrees in arts and sciences, education and professional areas. It’s known for small class sizes, a focus on sustainability and a diverse liberal arts education in a student-centered environment. Western is a Hispanic Serving institution, with over 40% of undergraduates being students of color.

Western Oregon University offers an excellent benefits package for eligible employees which includes 95% premium paid healthcare, a generous retirement and vacation package, and reduced tuition rates for employee, spouse or dependent at any of the Oregon Public Universities. http://(Use the "Apply for this Job" box below). this link will open a new tab.

Application Due Date:

Job

Start Date:

City: Monmouth

State/Province/Region: OR

Reports To: IR Director

Staff # Reporting to Position: 0

Reports In Office: Institutional Research