Association for Institutional Research (AIR) · 9 hours ago
Institutional Research Analyst Programmer
Eugene, OR
Full-time
Onsite
Mid, Senior Level
3+ years expThe Association for Institutional Research (AIR) 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 institutional data warehouse environment and providing expertise in data solutions for institutional reporting and analytics.
Association
Responsibilities
Designing and managing the office’s institutional data warehouse environment
Analysis, design, modification, testing, installation, and maintenance of application programs, integrated systems, and database solutions
Lead the architecture and development of data warehouse structures
Oversee ETL processes for efficient data integration
Ensure data integrity, performance, and usability
Provide expertise in Ellucian Banner and the Ellucian Operational Data Store (ODS)
Serve as the lead for database creation, management, and optimization to deliver reliable, accessible, and actionable data for institutional reporting and analytics
Qualification
Required
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 PostgreSQL). Demonstrated ability to write efficient and complex SQL queries
Strong knowledge of business intelligence (BI) tools such as Cognos, Power BI, or Tableau
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
Preferred
Preferred experience utilizing Cognos Framework Manager or Power BI Dataflows
Benefits
95% premium paid healthcare
A generous retirement and vacation package
Reduced tuition rates for employee, spouse or dependent at any of the Oregon Public Universities
Company
Association for Institutional Research (AIR)
The Association for Institutional Research (AIR) supports higher education professionals in the collection, analysis, interpretation, and communication of data, and the strategic use of information for effective decision making and planning.
11-50 employees
H1B Sponsorship
Association for Institutional Research (AIR) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2020 (1)
Funding
Current Stage
Early StageLeadership Team
JASON LEWIS
Deputy Director & CFO
Zehra Raza
Project Associate - Postsecondary Data Partnership
Company data provided by crunchbase