ETL Database Analyst
Application Procedure:
Please apply directly on our careers site: https://www.careers.luc.edu/postings/19248
(no due date for application - open until filled)
(no due date for application - open until filled)
Job Duties
- 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.
Job Qualifications
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.
Computer 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.
Qualifications:
• Ability to work with complex relational databases
• Ability to code in SQL and similar languages
• Knowledge of data visualization techniques
Preferred Qualifications
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.
Computer 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.
Qualifications:
• Ability to work with complex relational databases
• Ability to code in SQL and similar languages
• Knowledge of data visualization techniques
Preferred 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.
Institution Description
We are Chicago's Jesuit, Catholic University. Our faculty, staff, and students come from all faiths and backgrounds, but together, we strive toward the same goal, being men and women for and with others. But what makes a Jesuit university different? Our students receive an education that stresses the importance of knowledge, curiosity, global perspectives, and cura personalis, which translates to “care for the whole person.”
Our Loyola community isn’t afraid to get its hands dirty cleaning up neighborhood parks and gardens—or use its expertise to mentor girls interested in STEM programs. They research local food deserts and volunteer with our student-run farmers market to make healthy food more accessible. Here, we don't talk about making the world a better place—we get to work.
Loyola University Chicago is a great place to work! We aim to provide excellent benefit offerings, a diverse, inclusive and equitable campus environment, and a work experience designed to help faculty, staff, and students develop personally and professionally through collaborative engagement. Thank you in advance for your interest in working at Loyola University Chicago.
Equal Opportunity/Affirmative Action Employer
Loyola University Chicago is an Equal Opportunity / Affirmative Action employer with a strong commitment to hiring for our mission and diversifying our faculty and staff. All qualified applicants will receive consideration for employment without regard to race, color, religion (except where religion is a bona fide occupational qualification for the job), national origin, sex, age, disability, marital status, sexual orientation, gender identity, protected veteran status or any other factor protected by law.
Loyola University Chicago is an Equal Opportunity Employer.
Loyola University Chicago is an Equal Opportunity Employer.
Benefits
Benefits information can be found here: https://www.luc.edu/hr/benefits.shtml
Application Due Date: 2022-09-16
Job Start Date: 2022-09-19
Salary: Dependent on qualifications and experience.
City: Chicago
State/Province/Region: IL
Institution: Loyola University Chicago
Reports To: Director of the Office of Institutional Effectiveness
Staff # Reporting to Position: 0
Reports In Office: Institutional Effectiveness
Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad.