ETL Database Analyst
Position DetailsPosition Details Job TitleETL Database AnalystPosition Number8102401Job CategoryUniversity StaffJob TypeFull-TimeFLSA StatusExemptCampusRogers Park-Lake Shore CampusDepartment NameINSTITUTIONAL EFFECTIVENESSLocation CodeINSTITUTIONAL EFFECTIVENESS (02004A)Is this split and/or fully grant funded? NoDuties and Responsibilities
•Work with the OIE staff to complete the transport of data to the data warehouse environment
•Team up with OIE staff to migrate and upgrade existing ETL scripts.
•Design and implement research projects using university and external data.
•Utilize data visualization to present complex information in interactive environments.
•Other duties as assigned by the Directors of the Office of Institutional Effectiveness or Institutional Research.
Bachelor’s degree in computer science or related area or equivalent accelerated academic experience. Two years experience working with complex relational databases and data extraction or combination of education and equivalent job experience.Qualifications
•Ability to work with complex relational databases including the student registration system, financial aid data, and faculty information files.
•Advanced knowledge of SQL.
•Ability to transport data from current data structures to the enterprise data warehouse.
•Collect, extract and analyze data.
•Summarize research methodologies, analyses and results in reports for a wide array of audiences.
•Adept at working independently and managing assigned projects.
• Familiarity with large databases commonly used in academic environments.
Minimum requirements: At least two years of coding experience using SQL and with relational databases. Knowledge of powerbi preferred. Relevant degrees or certificates in computing or computer science.
•Ability to work with complex relational databases
•Ability to code in SQL and similar languages
•Knowledge of data visualization techniques
Required fields are indicated with an asterisk (*).
- * Do you have a Bachelor’s degree in computer science or related area or equivalent accelerated academic experience?
- * Do you have a Master's Degree?
- * Please indicate your years of experience working with complex relational databases and data extraction.
- Less than 1 year
- 1 - 2 years
- 2 - 3 years
- 3 - 5 years
- More than 5 years
- * Why do you want to work for Loyola University Chicago?
(Open Ended Question)
- * How did you hear about this employment opportunity?
(Open Ended Question)
- Cover Letter/Letter of Application
- Curriculum Vitae