ETL Database Analyst

Job description

Position Details

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

Minimum Education and/or Work Experience

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.


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

Certificates/Credentials/LicensesComputer Skills

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

Supervisory ResponsibilitiesNoRequired operation of university owned vehiclesNoDoes this position require direct animal or patient contact? Physical DemandsNoneWorking ConditionsNoneOpen Date10/12/2019Close DateSpecial Instructions to ApplicantsQuick Link for Posting Questions

Required fields are indicated with an asterisk (*).

  1. * Do you have a Bachelor’s degree in computer science or related area or equivalent accelerated academic experience?
    • Yes
    • No
  2. * Do you have a Master's Degree?
    • Yes
    • No
  3. * Please indicate your years of experience working with complex relational databases and data extraction.
    • None
    • Less than 1 year
    • 1 - 2 years
    • 2 - 3 years
    • 3 - 5 years
    • More than 5 years
  4. * Why do you want to work for Loyola University Chicago?

    (Open Ended Question)

  5. * How did you hear about this employment opportunity?

    (Open Ended Question)

Applicant DocumentsRequired Documents
  1. Resume
  2. Cover Letter/Letter of Application
Optional Documents
  1. Curriculum Vitae




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 10/17/2019
Application Due: 11/14/2019
Work Type: