Under supervision of the Associate Provost, the ETL and BI Developer Intern provides support for reporting, business intelligence and data quality through the development, testing and maintenance of various solutions including complex SQL queries, ETL development and report authoring.

Develop, test and maintain robust, well-designed reports to fulfill data reporting needs of OAIR and the university.

Participate in the development and maintenance of business intelligence solutions including the university data warehouse, metadata management, ETL, dashboards, visualizations, reports, multidimensional cubes and other analytical tools.

Assist with university data governance through creation of technical documentation, business process documentation, training materials, and metadata such as business definitions, technical details and the university data dictionary.

Develop proficiency with business intelligence, reporting, data warehousing and institutional research concepts.

The above statements describe the job’s essential responsibilities and requirements. They are not an exhaustive list of the duties that may be assigned to job incumbents.

*The physical requirements 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. 

This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.  While performing the duties of this job, the employee is required to speak and hear sufficiently to communicate effectively by phone or in person at normal volumes. The employee’s vision must be adequate to read correspondence, computer screen, forms, etc. The position requires good manual dexterity. This is a largely sedentary role; however, some filing is required. This would require the ability to lift files, open filing cabinets and bending or standing as necessary.